Update stock in bulk with a file

After a stock count, you edit the quantities of many variants in Excel and import them back in one go, instead of opening each product.

The stock file only changes On hand. Prices and other product details stay as they are.

Export the stock file

1. Go to Products › Inventory.
2. If you only need some of the variants, search by keyword or choose a filter. The file only includes the rows currently shown in the table.
3. Click Export. On a phone, tap the three-dot icon More actions and choose Export.

The downloaded file is a CSV file with one row per variant.

Fill in the new quantities

1. Open the file in Excel or Google Sheets.
2. In the rows you want to change, enter the new number in the On hand (new) column. This is On hand after the change.
3. Leave the On hand (new) column empty in the rows that stay the same.
4. Save the file as CSV.

Don’t edit the Variant ID and On hand (current) columns. EcomWeb uses Variant ID to find the variant, and uses On hand (current) to check that the stock hasn’t changed since you exported the file. Columns marked not editable are only there for you to compare against.

Import the file

1. Go to Products › Inventory.
2. Click Import.
3. Drag the CSV file into the upload box, or click the box to choose the file.
4. Click Import in the dialog.
5. Read the result. The dialog shows how many rows were updated, left unchanged and skipped. Each skipped row has its row number in the file and the reason.

The difference between the old and new numbers is added to or taken from Available. Every change is recorded in the variant’s inventory history.

Frequently asked questions