Product Availability Field Reference

The Product Availability object is used to track the availability status of SKUs stored at the warehouse and define specific availability dates for different departments, sales points, or clients.

The availability is checked for each product in the cart during the delivery creation.


Object API name: orders__ProductAvailability__c


Field API name Type Description

Account

orders__AccountId__c

Lookup(Account)

If specified, product availability is assigned for a certain Account.

Active

orders__IsActive__c

Checkbox

This field defines whether the setting is active or not. Only active settings can be applied.

Availability Type

orders__AvailabilityType__c

Picklist

It defines whether a product is available in a specific period from orders__StartDate__c to orders__EndDate__c. Available values:

  • Available

  • Not Available

End Date

orders__EndDate__c

Date

It is a required field with the end date when the product is available.

The delivery date should be within the start and end dates of the product availability.

External Id

orders__ExternalId__c

Text(255) (External ID) (Unique Case Sensitive)

Unique identifier of the record.

Order Type

orders__OrderType__c

Picklist (Multi-select)

It is a required field to select one or more order types. Available values:

  • Order

  • Return

  • Pre-Sale

Product

ProductId__c

Lookup(Product)

This is a custom lookup to store a custom product identifier.

Please create this field in case of using the custom CT Product or Pharma Product.

If the product is a bundle, then the product availability is applied to the whole bundle or separately to included products, depending on the value in the Calculate Price On field.

Product

orders__Product2Id__c

Lookup(Product)

This is a default lookup to the standard Product record in case of working with the CG Cloud solution.

If the product is a bundle, then the product availability is applied to the whole bundle or separately to included products, depending on the value in the Calculate Price On field.

Product Type

orders__ProductType__c

Picklist(Multi-select)

It is a required field to select one or more product types to apply the product availability to them. Available values:

  • Product

  • Freebie

Promotion

orders__PromotiontId__c

Lookup(Promotion)

The relationship with the Promotion with the added product.

Retail Store

RetailStoreId__c

Lookup(Retail Store)

If specified, a Product Availability record is assigned for a certain Retail Store.

Create this field in case of working with the CG Cloud solution.

Sales Organization

orders__SalesOrganizationId__c

Lookup(Sales Organization)

It is a required field to relate a Product Availability record to a certain Sales Organization.

Start Date

orders__StartDate__c

Date

It is a required field with the start date when the product is available.

The delivery date should be within the start and end dates of the product availability.
``