How do I set available quantity for my product in bulk through an inventory upload?

Build your file

1. Create a .CSV file with SKU number in column A and available quantity in column B.
2. For column A, enter your SKU numbers that you would like to set an available quantity for.
3. For column B, enter the Available Quantity you would like to set for each product.
4. Save this file as .CSV (comma delimited file).

Next, you will build a format within ecomdash to match your file

1. Log into ecomdash and navigate to Administration -> Inventory import/export
2. Choose 'add new format' and give your import format a name such as ' Set Available Quantity' and click 'add'.
3. From the storefront dropdown at the top of your format, choose the storefront you would like to set your available quantity for such as 'eBay'. (Note: this will only set the available quantity value for that specific storefront; if you'd like to set every storefront's available quantity, choose All Storefronts on the dropdown).
4. From the product attribute dropdown find the attribute 'SKU number' and click 'add field'.
5. From the product attribute dropdown find the attribute 'Available Quantity' and click 'add field'.
6. Click 'Save' to save your import format.

Now you are going to upload your file
1. Click the quick links at the top left of your screen with the lighting bolt icon.
2. Choose 'Upload inventory'.
3. Choose the format you created, the file and 'Overwrite existing product details'.
4. Click 'Upload'

Was this article helpful?
2 out of 3 found this helpful