Export and import inventory data

It is common to import inventory data from external systems.

Once you have set up your inventory, as outlined in Understand catalogs, you can import inventory data. The following section describes the fields and validation that occurs when exporting or importing inventory data.

Inventory export and import fields

The following fields are exported and imported for inventories:

Field Name	Description
locationId	The location of the inventory item.
skuNumber	The ID of the SKU.
displayName	The display name of the product.
stockLevel	Indicates the number of products available for purchase.
stockThreshold	The threshold of the stock level that triggers a warning event.
preorderLevel	Indicates the number of preordered SKUs.
preorderThreshold	The threshold at which the status of the SKU changes from preordered to out of stock.
backorderLevel	Indicates the number of backordered SKUs.
backorderThreshold	The threshold at which the status of the SKU changes from backordered to out of stock.
availabilityDate	The date at which the SKU becomes available.
availabilityStatus	The status of the SKU, for example, PREORDERED, BACKORDERED or OUT_OF_STOCK.
availableToPromise	A collection of date/quality pairs that represent when and how much inventory can be promised.

Inventory validations

Additionally, the following validations are performed when importing inventories:

• The skuNumber is a valid SKU ID.
• The locationId is valid.
• The required stockLevel is valid when creating the import, and should be a non-negative long number.
• The stockThreshold is a non-negative long number.
• The preorderLevel is a non-negative long number.
• The preorderThreshold is a non-negative long number.
• The backorderLevel is a non-negative long number.
• The backorderThreshold is a non-negative long number.
• The availabilityDate is a valid date.

For detailed information on working with inventories, refer to Understand catalogs.