Update the item inventory (inStock quantity) in file with only 2 columns:

ItemExternalID - the unique item code of the item

InStockQuantity - the value of the inventory in stock

A sample file is attached below.

File names required for FTP upload:

API_Inventory_2011-03-24_114327_Distributor_xxxx.csv

API_Inventory_Overwrite_2011-03-24_114327_Distributor_xxxx.csv

xxxxx in the file names stands for your distributor ID number - How to find my distributor ID number

The overwrite file will set the inventory value of all items not included in the file to zero.

If you are updating the inventory of matrix items with color/size or other variants the following applies:

1. You can include the variant item codes only, no style (parent) codes
2. When uploading a variant item’s inventory – it will calculate the total style code inventory by applying the increase or decrease in the variants inventory to the style.

The inventory for the style code is the sum of the inventory of the variants.

For example if you have a style code ABCDE with variants 111,222,333,444

and the existing inventory of ABCDE is 200 and the variants' inventory as follows:

The new style code ABCDE inventory will be 200 - 5 - 5 - 5 +17 = 202