Skip to content

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

Bulkvane

Free CSV template

Shopify inventory CSV template, by location

One row per variant and one column per location. Each cell is the available quantity at that location. An empty cell leaves that location's stock alone.
Download the CSV template

Free, no sign-up. Opens in Excel, Numbers and Google Sheets.

The columns

ColumnNeededWhat to put
HandleYesThe product's handle. Repeat it on every variant row.
Variant SKUYes, or Variant IDPicks the variant.
Inventory: Main warehouseOne per location“Inventory: ” and your location's name exactly as in Shopify (capitals don't matter). Available quantity as a whole number.
Inventory: ShopOptionalAdd as many location columns as you need; remove the ones you don't.

What's in the file

Handle,Variant SKU,Inventory: Main warehouse,Inventory: Shop
classic-tee,TEE-S,40,6
classic-tee,TEE-M,52,8
classic-tee,TEE-L,35,
Example rows. Replace them with your own before you import.

How to import it

  1. Rename the Inventory columns to your own location names, and fill in the quantities.
  2. In Bulkvane, open Import, add the file and choose Update only.
  3. Click Check file: each variant's stock, old beside new, per location.
  4. Apply. If a variant's stock changed after the preview (say, an order came in), it's skipped instead of overwritten.

Tips

  • Variant Inventory Qty, the total in an export, is for reference and can't be imported. Change the per-location columns instead.
  • Variants that don't track inventory, or aren't stocked at a location, are skipped with a warning.
  • Updating products you already have? Export them from Bulkvane instead of starting from the template. The export already holds each product's handle, ID and current values.

Step by step: How to bulk update Shopify inventory by location. Every column is in the column reference.

Questions

Can I set stock to zero?

Yes. Type 0. An empty cell leaves the stock as it is.

What if my location name has a typo?

The check stops before anything changes and says which location it couldn't find, with the names of your store's locations. Correct the header and check the file again.

Preview every change.Undo any import for 30 days.

Install free