How to import stock for the bulk of products?
Are you looking for a way to import stock for the bulk of products in one step? In this tutorial we walk you through a convenient way for doing this with one of the powerful commercetools™ platform commands.
Products to which stock has to be imported
Imagine we have 5 products in our project to which we would like to import stock. Given image below shows the list of products, where the Availability shows n/a (not applicable).
Since we don’t want to waste our time in adding stock for each product one by one in the ↗ Admin Center EU (or ↗ Admin Center US ), we rather look for a way to import stock for all the products in one step. Following is the image for single stock import.
Stock import command
From IMPEX tool, we select the Stock import command which we are going to use for importing stock to our products like shown below:
For importing stock of the bulk of products, we need to upload a file either in CSV or XML format, that contains only two columns with header ‘SKU’ and ‘quantity’. The given image below shows the Stock import page.
Following image is an example of csv file for 5 products with the SKU and quantity as headers.
As shown in the image below, we need to upload the CSV or XML file to Stock import, before we hit the
Run command button.
If everything went well we’ll get a response like the one below confirming that the stock of 5 new products have been imported successfully.
Below image shows what will be the output, if the stocks are imported only for already existing products.
Verify product stock
To be really sure that stock of products have been imported in our project, we can verify their Availability in the ↗ Admin Center EU
(or ↗ Admin Center US
If the Products page looks like the one shown below, we have succeeded in importing stock.
The image below shows the stock of an individual product after using the stock import tool.