Importing Inventories in bulk

In this tutorial, you will learn a convenient way to import Inventories for a bulk of ProductVariants with an ImpEx command.

ProductVariants to which inventories have to be imported

Suppose you would like to import Inventories to five ProductVariants in your Merchant Center project. The image below shows the list of the five ProductVariants whose Inventory: Quantity (Channel) entries are currently empty.

ProductVariant Main Page

Instead of adding Inventories one by one for each ProductVariant, you can import Inventories for all ProductVariants in one step with an ImpEx command.

Inventory import command

From the ImpEx command pull-down menu, select Inventories importer.

Inventories importer command

Inventory import

To import a bulk of inventories, you need to upload a file in the Inventories importer command page (see the image below) either in CSV or XML format, and the CSV file must contain at least two columns: one for the SKUs of the ProductVariants and the other for the Inventory quantities to be imported. The following table is an example CSV file for five ProductVariants identified by their SKUs and their respective Inventory quantities to be imported. The column headers must be spelled exactly as shown in the example.

skuquantityOnStock
M0E20000000E2Q555
M0E20000000E2Q673
M0E20000000E2Q745
M0E20000000E2Q865
M0E20000000E2Q932

As shown in the image below, we need to drop the CSV file on the drop file area of the Inventories importer and then hit the Run command button.

File upload

If successful, a response like the one below is returned. Note that it confirms the successful import of 5 new Inventories.

Output new products

The inventory gets updated only if the Inventory quantity to be imported is different from the current one in the platform. The image below shows that only 2 Inventories were updated. This will happens if you import Inventories again with the same CSV file in which you change the quantity of only 2 Inventories, leaving the other three as they are.

Output existing products

Verify ProductVariant Inventories

To be completely sure that the Inventories of ProductVariants have been imported in the project, you can verify their Inventory: Quantity (Channel) in the Merchant Center. If the ProductVariant page looks as follows, the inventory import was successful. Please be aware that updating the Inventory information on the ProductVariant page can take some minutes after importing the Inventory information.

Inventories after import

The image below shows the Inventory of an individual ProductVariant after using the Inventories importer.

Individual Product Inventory after import

Further information about Inventory import features, such as importing Inventories per supply channel or the usage of custom fields, can be found on the GitHub repository of the tool that is executed by the ImpEx Inventories import command.

Developer Center
HTTP APIGraphQL APIBETAPlatform Release NotesCustom ApplicationsBETASDKs & Client LibrariesImport & ExportSUNRISE Starter FrontendsTutorialsFAQ
Copyright © 2021 commercetools