Shopify gives you three ways to change many counts at once. The bulk editor is a spreadsheet-like grid in the admin, quick but without an audit trail of where stock came from or went. The inventory CSV in the All states format checks each row against the live count and skips any that changed since you exported, which protects sales made in between. A stock count is the safest for counted quantities: staff record what's there, a manager approves, and the history shows it as a count.
The short version
- Bulk editor: fast, in the browser, sets absolute quantities, no record of movement.
- Inventory CSV (All states): offline editing, overwrite protection, emails failed rows.
- Stock count: for physically counted numbers, with review and approval.
- None of them make a product active at a new location.
- Shopify recommends Chrome, Firefox or Safari for the bulk editor.
Which to use
| Situation | Method |
|---|---|
| You just counted the shelf | Stock count |
| Prices, SKUs, barcodes, cost per item for many variants | Bulk editor |
| Starting quantities for a new location | Inventory CSV, then activate products there |
| Syncing from another system every day | Bulk editor or CSV, knowing there's no movement record |
| A few corrections with reasons | Adjust by on the Inventory page |
The bulk editor
- Products > Inventory, select the variants (or open the bulk editor from a single product).
- Add the columns you need: quantities by location, cost per item, SKU, barcode, continue selling, track quantity.
- Edit cells. Copy down works like a spreadsheet.
- Save.
Shopify's help center is direct about the trade-off: the bulk editor sets absolute quantities without an origin or destination, so it doesn't create an audit trail of inventory movements. If track quantity is greyed out on a variant, it's part of an unfulfilled order or an active transfer.
The inventory CSV
Export All states, fill in On hand (new) for the rows you're changing, leave the rest blank, import. The On hand (current) column is compared with the live count; rows that changed since export are skipped and emailed to you. Shopify inventory CSV template covers every column.
A made-up example: three updates, three tools
Wailuku Wax Works updates stock three times in November:
- New prices on 60 candle variants: the bulk editor, in five minutes.
- A new shop location: exported CSV with shop quantities, imported, then received a transfer to make products active there.
- The monthly count of 40 best sellers: a stock count, reviewed and approved, so the history shows "count" instead of a mystery change.
Mistakes to avoid
- Typing over quantities in the bulk editor during business hours. A sale between loading the grid and saving is overwritten.
- Clearing On hand (current) to force a CSV import. It removes the overwrite check.
- Using bulk tools for routine changes. Deliveries and breakage belong in adjustments with reasons, so the history explains itself.
Where this stops working
Bulk tools change numbers on finished products. For a maker, the biggest daily change is a batch: materials used, products made. Bulk-editing the products after each batch leaves no record of the batch and no change to the materials. Shopify inventory adjustment and Shopify raw materials inventory cover recording that properly.
How TaroStack does it
TaroStack for Shopify runs inside your Shopify admin and adds finished products to Shopify as each batch finishes, rather than setting totals, so sales made in the meantime stay counted. Every change has a reason and a lot behind it, ingredients and packaging included. A daily check shows any difference between TaroStack and your store. Free for 14 days.
