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
| Column | Needed | What to put |
|---|---|---|
| Handle | Yes | The product's handle. Repeat it on every variant row. |
| Variant SKU | Yes, or Variant ID | Picks the variant. |
| Inventory: Main warehouse | One per location | “Inventory: ” and your location's name exactly as in Shopify (capitals don't matter). Available quantity as a whole number. |
| Inventory: Shop | Optional | Add 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,
How to import it
- Rename the Inventory columns to your own location names, and fill in the quantities.
- In Bulkvane, open Import, add the file and choose Update only.
- Click Check file: each variant's stock, old beside new, per location.
- 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