Inventory levels data file (inventory.csv)

The inventory levels data file, otherwise known as inventory.csv, is used to add or update SKU inventory values within your inventory.

Each row defines the inventory values for an individual SKU at an individual Inventory Location. For example, if you were to have the same SKU at five Inventory Locations, then five row entries would be used to describe the unique inventory values for the SKU at each Inventory Location.

The values that are contained within the file are used to update your inventory levels. For example, if inventory values that are contained within your Commerce+ inventory differ, then the values that are contained within the file are applied.

Usage considerations

  • Before loading inventory level values, you must load the corresponding catalog data for each SKU with the Catalog data file (items.csv) to ensure that their definitions are contained within the Inventory.
  • Any file name can be used.
  • The file header contents and column order must be identical to the sample template. No empty columns for spacing are permitted.
Restriction:
  • English is the only supported language for inventory content.
  • No deletion is possible.
  • Files must not contain conflicting inventory references. That is, a row containing the unique combination of SKU (PARTNUMBER), at an Inventory Location (INVENTORYLOCATION_ID) for a Store (STORE).

    While still valid, this action will result in one of the conflicting references being applied within the Inventory. The reference that is applied cannot be predetermined.

Sample template

A sample of the inventory.csv is as follows.
INVENTORYLOCATION_ID PARTNUMBER STORE AVAILABLE_QTY UNAVAILABLE_QTY RESERVED_QTY
R00B2C BD-BEDS-0001-0001 Ruby 91 10 20
SG2050 BD-BEDS-0001-0001 Ruby 108 10 20
YC2050 BD-BEDS-0001-0001 Ruby 82 10 0
... ... ... ... ... ...

Column descriptions

INVENTORYLOCATION_ID
Mandatory: The INVENTORYLOCATION_ID is the unique identifier for an Inventory Location. This is used to describe the SKU inventory values at the Inventory Location that is specified.
PARTNUMBER
Mandatory: The PARTNUMBER, or part number, is the unique identifier for a SKU. Once a part number is used on your store front, it is a best practice to use a new part number, instead of recycling one that was previously used for merchandise.
STORE
The STORE, is the unique identifier for the online storefront. For example, Ruby, or RubyB2B.

If a value for STORE is not specified, then the quantity is accounted for as unassigned. That is, not assigned to an online store. In this case, the value of _unassigned_ is applied, and can be selected within the store drop-down.

AVAILABLE_QTY
The AVAILABLE_QTY value corresponds with the quantity of the SKU (PARTNUMBER) that is located within the Inventory Location (INVENTORYLOCATION_ID) that is specified on the row.

This value is a numeric value. The value is measured in the QUANTITYMEASURE value that is defined within Catalog data file (items.csv). For example, the weight of cheese, length of fabric, or, most typically, the number or count of a packaged product.

If a value for AVAILABLE_QTY is not specified, then the default of 0 is applied for any new records. To an existing record, no changes are made.

UNAVAILABLE_QTY
The UNAVAILABLE_QTY value corresponds with the SKU quantity of unsaleable product that is located within the Inventory Location (INVENTORYLOCATION_ID) that is specified on the row. Examples of unsaleable products can be those that are physically damaged, or spoiled / out-of-date.

This value is a numeric value. The value is measured in the QUANTITYMEASURE value that is defined within Catalog data file (items.csv). For example, the weight of cheese, length of fabric, or, most typically, the number or count of a packaged product.

If a value for UNAVAILABLE_QTY is not specified, then the default of 0 is applied for any new records. To an existing record, no changes are made.

RESERVED_QTY
The RESERVED_QTY value corresponds with the SKU quantity of reserved product that is located within the Inventory Location (INVENTORYLOCATION_ID) that is specified on the row. Reserved products are in stock and good quality, but cannot be sold because they are intentionally set aside.

This value is a numeric value. The value is measured in the QUANTITYMEASURE value that is defined within Catalog data file (items.csv). For example, the weight of cheese, length of fabric, or, most typically, the number or count of a packaged product.

If a value for RESERVED_QTY is not specified, then the default of 0 is applied for any new records. To an existing record, no changes are made.