Importing and Exporting Inventory

This site contains archived merchant documentation for a version of Adobe Commerce and Magento Open Source that has reached end-of-support. The documentation available here is intended for historical reference only and is not maintained. The Adobe Commerce Merchant Documentation for current releases is published on the Adobe Experience League.

For catalogs with a large amount of products, use the Import and Export features of Magento with expanded Inventory Management options to update sources and quantities by SKU. With these options, you can add new sources and update inventory quantities for all or a specific source. For example, you can export products for a source in Germany without affecting product information for sources in France, England, or the US.

Magento automatically assigns the Default Source to your products when upgrading Magento or importing new products. If you import products with a custom source assigned, the Default Source will still be added with a quantity of 0. To update sources and quantities, use these import instructions.
Single Source merchants use import to update only product quantities. All existing and added products are assigned to the Default Source.
Multi Source merchants use import to add multiple sources and quantities per row per SKU.

To import updates, first export a CSV file for a specific or all sources. Edit the CSV file and add a row per SKU for each source and quantity. You need the source’s code when adding a new source and adding quantities of stock. You cannot add or update stocks using import-export features.

CSV file content

The export-import file includes the following information according to source:

source_code - The code for sources in Magento. You will see a row for each source and SKU.
sku - The SKU for the product in Magento. 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 this option 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

On the Admin sidebar, go to System > Data Transfer > Export.
For Entity Type menu, 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 Magento.

Export Stock Sources for product data and sources

Export product data for a specific source

On the Admin sidebar, go to System > Data Transfer > Export.
For Entity Type menu, 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 Magento.

Export Stock Sources for product data and sources

Import product data

On the Admin sidebar, go to System > Data Transfer > Import.
For Entity Type menu, 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.

Import product data and sources