Stock in Shopify is a number per variant per location, and Shopify's bulk editing page says inventory is bulk edited "only from the Inventory section".
For a few dozen rows: Products, Inventory, select the variants, edit the quantities in the bulk editor, Save.
For hundreds: export the inventory CSV, change the "On hand (new)" column, import it back. Both routes are free.
Before either, decide which number you mean. "Set stock to 10" gives different results depending on whether 10 is on hand or available, and the arithmetic below shows by how much.

Available, on hand and committed, in numbers
Shopify keeps several numbers per variant per location. Committed is stock reserved for orders not yet fulfilled. Unavailable covers stock set aside as damaged, reserved, safety stock or in quality control. Available is what a customer can buy. On hand is the total: available plus committed plus unavailable.
Take one variant at one location: 10 available, 3 committed to open orders, 2 set aside as damaged. On hand is 15. Now someone says "set stock to 10".
The inventory CSV settles the ambiguity by letting you edit only on hand. Shopify lists Incoming, Unavailable, Committed and Available as columns you cannot edit in that file.
| Available | Committed | Unavailable | On hand | |
|---|---|---|---|---|
| Before | 10 | 3 | 2 | 15 |
| Set on hand to 10 | 5 | 3 | 2 | 10 |
| Set available to 10 | 10 | 3 | 2 | 15 |
On hand = available + committed + unavailable. The committed and unavailable units do not move; the edit lands on whatever is left.
A few dozen rows in the Inventory section
Products, Inventory. The list is one row per variant, and the quantities shown are for a location. Select the variants, edit the counts, Save. If a row fails, fix it and Save again; a variant missing a required SKU is the error Shopify names as common.
Values are literal, so "add 24 to every row" means doing the sum yourself, and there is no undo after Save. The product bulk editor is the wrong place for counts; it is for price, SKU and barcodes, as covered in bulk editing variants in Shopify.
Stocktake by CSV, step by step
The inventory CSV has one row per variant per location, identified by Handle, Location and the option values (Option 1 Value, plus Option 2 and 3 where the product uses them). Three locations means three rows per variant. The file can be up to 15 MB.
- Step 1: Products, Inventory, Export. Shopify offers two formats, "All states" and "Available".
- Step 2: Leave "On hand (current)" alone. It is the count at export time, and Shopify uses it to check that nothing changed between export and import.
- Step 3: Type the counted numbers into "On hand (new)". Whole numbers only.
- Step 4: Do not retype location names. They are case-sensitive, and "Main warehouse" and "Main Warehouse" are different.
- Step 5: Leave "Not stocked" where it is. It marks a variant that was never stocked at that location.
- Step 6: Import the same day. A file that sat in a folder while orders came in no longer matches "On hand (current)".
- Step 7: Keep the export. It is the record of what the counts were, and the only undo the CSV route gives you.
Track quantity and continue selling
These two sit next to the count and are not part of it. They are product CSV columns, not inventory CSV columns. Inventory tracker sets whether Shopify tracks the variant's stock; export one product that is already tracked to see the value Shopify writes there, and copy it. Continue selling when out of stock takes deny (the default) or continue.
Turn tracking on first, then set the counts. A quantity on a variant that is not tracked is inert: the variant stays purchasable whatever the number says, and nothing looks broken. Turn continue selling on only for products you can restock, because it lets the count go below zero.
The product CSV also has an Inventory quantity column, but it covers a single location only. In the bulk editor, add these fields through Columns if your admin offers them; Shopify does not publish the full column list.
Where stock numbers go wrong
Most stock mistakes are a wrong number name or a wrong location, not a wrong count.
- Setting available when you meant on hand. Units held for open orders reappear as sellable stock.
- Counts on untracked variants. The number changes, nothing else does, and the variant keeps selling.
- A location name typed by hand in the CSV. One capital letter and the row does not match.
- An old export imported after a busy weekend. "On hand (current)" no longer matches.
- A blank Inventory quantity in a product CSV. It imports as 0, so leave the column out on a store with more than one location.
- Bulk editing counts that an ERP or 3PL owns. The next sync puts them back, and the fix belongs in the source system.
When the change is a rule, not a count
A stocktake is a list of numbers, and the CSV is built for it. "Add 12 to every variant of vendor X at the warehouse" or "set every variant in Winter to 20 on hand at Brooklyn" is a rule, and the free tools make you turn it into a list by hand first.
Matrixify, Ablestar and Hextom can set or adjust stock by filter and by location, and some sync from a supplier feed on a schedule. Backup and undo windows vary by app and plan.
ApiMate takes the rule as a sentence. It asks which location if you have more than one and named none, shows each variant with its current and new count, turns tracking on or activates the location in an earlier step where needed, and writes nothing until you approve. If stock moved between the preview and the write, the write is refused and re-planned. Revert sets every row back to the count read before the write, which overwrites any sales since, so check first. The free plan covers small jobs, and the walkthrough is in the inventory tracking and locations case. Other fields are in the overview of Shopify bulk edit methods.
Questions
How do I bulk edit inventory in Shopify?+
From Products, Inventory: select the variants and edit the quantities in the bulk editor. For many rows, export the inventory CSV, edit "On hand (new)" and import it.
What is the difference between available and on hand?+
On hand is available plus committed plus unavailable. Committed stock is held for unfulfilled orders, so setting available instead of on hand changes the total.
How do I turn on track quantity for many products?+
Use the Inventory tracker column in the product CSV. Copy the value from an exported product that is already tracked. Turn tracking on before setting counts.
Can I undo a bulk inventory change?+
The admin has no undo; re-import your export. ApiMate reverts to the counts read before the write, which overwrites any sales since, so check first.
Related
- How to bulk edit Shopify productsAdmin, CSV, apps, chat: what each one is for.
- Turn on inventory tracking across every product and locationTracking, activation and counts per location, with a preview.
- How to bulk edit variants in ShopifyPrices, SKUs and options at the variant level.
- How to undo a bulk edit in ShopifyWhat each method gives you after a bad write.
- Bulk update prices and inventory in Shopify, with undoThe chat path, row by row.
Run this on your own catalog
Install from the Shopify App Store. Every write shows its rows before it runs, and applied jobs can be reverted from history.