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.

Example CSV file for import - export inventory data

Export product data for all sources

  1. On the Admin sidebar, go to System > Data Transfer > Export.

  2. For Entity Type, choose Stock Sources.

    The export only extracts data for products with a SKU.

  3. 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 stock sources for product data and sources

Export product data for a specific source

  1. On the Admin sidebar, go to System > Data Transfer > Export.

  2. For Entity Type, choose Stock Sources.

    The export only extracts data for products with a SKU.

  3. 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.

  4. 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

  1. On the Admin sidebar, go to System > Data Transfer > Import.

  2. For Entity Type, choose Stock Sources.

    The export only extracts data for products with a SKU.

  3. Select configurations for the Import Behavior.

  4. Select the .csv file to import.

  5. Click Check Data and complete the import.

Import product data and sources

Previous pageTransfer inventory to source
Next pageOverview