CSV file content
The export-import file includes the following information according to source:
source_code
- The code for sources in Commerce. There is a row for each source and SKU.sku
- The SKU for the product in Commerce. The SKU must match a product in your store to properly update Inventory Management data.status
- 0 for Out of Stock. 1 for In Stock. This value must be 1 to purchase stock from this source.quantity
- The total amount of inventory available for this SKU and source.
Use a CSV file to quickly update multiple products and assigned sources to update and correct any inaccuracies in inventory records rather than one at a time through the application interface. For a base file, export first and update as needed.
Export product data for all sources
-
On the Admin sidebar, go to System > Data Transfer > Export.
-
For Entity Type, choose
Stock Sources
.The export only extracts data for products with a SKU.
-
Click Continue.
The file generates and downloads to open and edit.
After updating inventory amounts and product data, import the file back into Commerce.
Export product data for a specific source
-
On the Admin sidebar, go to System > Data Transfer > Export.
-
For Entity Type, choose
Stock Sources
.The export only extracts data for products with a SKU.
-
Use the Entity Attributes to filter the exported products for a specific source.
For
source_code
, enter the code for the source in the filter field. -
Click Continue.
The file generates and downloads to open and edit.
After updating inventory amounts and product data, import the file back into Commerce.
Import product data
-
On the Admin sidebar, go to System > Data Transfer > Import.
-
For Entity Type, choose
Stock Sources
.The export only extracts data for products with a SKU.
-
Select configurations for the Import Behavior.
-
Select the .csv file to import.
-
Click Check Data and complete the import.