Skip to content

NewSchedule your Black Friday sale: prices drop at the start and go back by themselves. See how

Bulkvane

How to bulk update Shopify inventory by location

Update stock for every variant at every location from one spreadsheet, with a before/after preview, a check for stock that changed, and undo.

The Bulkvane teamPublished Last updated 2 min read
Illustration of a stock spreadsheet with one Inventory column per location, current and new quantities for each variant, and the read-only Variant Inventory Qty total.

One column per location

In a Bulkvane file, stock is a column per location, named “Inventory: ” followed by the location's name, like “Inventory: Main warehouse” or “Inventory: Shop”. Each cell holds that variant's available quantity at that location, as a whole number.

  • Location names are matched to your Shopify locations without caring about capitals.
  • Empty cells never change stock, so you can update one location and leave the others blank.
  • Variant Inventory Qty, the total across locations, is exported for reference and can't be imported.

Update stock in four steps

  1. Export your products with Bulkvane and choose the locations you want. Each one becomes a column.
  2. Type the new quantities, or paste them from your stocktake or supplier file. Keep the ID and Variant ID columns.
  3. Import the file with Update only.
  4. Check the preview (every variant's stock, old beside new, per location) and apply.

Stock that changes while you work

Stock keeps moving while you edit: orders come in, returns go back on the shelf. If a variant's stock changed between the preview and the import, Bulkvane skips that variant instead of overwriting the newer number.

And if a stock update goes wrong, undo the import for 30 days to put the previous quantities back.

Supplier stock files

If your supplier shares stock as a Google Sheet or a file link, import it from the link. When they update it, open the job and click Run again. You still see a preview before anything changes.

What about the spreadsheet editor?

The spreadsheet editor changes product details, prices, SKUs and barcodes, but not stock. For stock, use an export and import as above. See metafields and inventory.

Frequently asked questions

Can I update stock with the Variant Inventory Qty column?

No. It's the total across all locations, exported for reference. Use one “Inventory: <location name>” column per location.

Do I have to fill in every location?

No. Empty cells never change stock, so you can update one location and leave the others blank.

What if an order comes in while I'm editing the file?

If a variant's stock changed between the preview and the import, Bulkvane skips that variant instead of overwriting the newer number.

Can I import my supplier's stock file?

Yes, from a Google Sheet or a file link. When the supplier updates it, open the job and click Run again; you still see a preview first.

Related guides

How to bulk edit Shopify productsFree CSV templatesBrowse the help center

Preview every change.Undo any import for 30 days.

Install free