If you run more than one location, Shopify's inventory screen asks you to think about one product at a time across all your locations, or one location at a time across all your products. What it never shows you is the grid — every product down the side, every location across the top, which is how stock actually lives in anyone's head.
A stocktake, a warehouse transfer, a seasonal rebalance: all of these are grid operations, and all of them are painful through a UI that only shows you a slice.
What the sheet looks like
SheetSync builds two tabs.
Inventory — one row per variant. Fixed columns for Product ID, Product Name, Variant ID, Variant Name, SKU, Barcode and Tracked, then one Available - <Location> column for each of your locations.
Location Reference — one row per location with its ID, name, whether it is active, whether it fulfils online orders, and the exact column heading it maps to. That last column is the one to check before a big edit: if two locations share a name, their column headings are disambiguated with the location ID so the push can tell them apart.
SKU and Barcode sit beside each other and are both read-only. The sheet matches on Variant ID; those two columns are there because they are what a human — or a supplier's file — actually recognises.
What the grid makes possible
A stocktake you can actually reconcile. Export, add a "counted" column next to each location, and the variance is a subtraction. You see every discrepancy at once, sorted by size, instead of discovering them one at a time.
Rebalancing between locations. Move 40 units from the warehouse column to the shop column and both sides update in one sync. Doing the same in admin is two separate edits with a window in between where your total is wrong.
Finding the dead stock. Sort by a location column descending and the things you have 200 of are at the top. That is a merchandising conversation, and it starts with a sort.
Spotting the imbalances. A product with 150 at one location and 0 at another is a transfer waiting to happen, and it is invisible unless you can see both numbers side by side.
Opening a location. Fill a whole column from an opening-stock list and the new site is live with accurate counts.
Step by step
- Open the Inventory page in SheetSync and create or connect an inventory spreadsheet.
- Export. Every variant arrives with its quantity at every location.
- Check the Location Reference tab so you know which column is which.
- Edit the
Availablecolumns, and theTrackedcolumn where needed. - Paste formula results as values.
- Sync back and review the preview before approving.
The rules, and why they are what they are
- A blank cell means "leave this alone", not zero. This is the opposite of most SheetSync sheets and it is deliberate: zero is a meaningful stock level, and a half-filled column must never empty a warehouse. To set a variant to zero, write
0. - Tracking has to be on before a quantity can be set. If Shopify is not tracking a variant, there is no level to write to. The row is reported as an error that tells you to put
Yesin the Tracked column, rather than being skipped in silence. - You cannot switch tracking off and set a quantity in the same row. The two instructions contradict each other, so the push asks you to clear one of them.
- Switching tracking off is flagged as a warning. Shopify stops counting that variant down as it sells, so it can be oversold indefinitely. That is a decision, not a typo, and it is surfaced rather than applied quietly.
- The Tracked column is forgiving about wording but not about guessing.
Yes,Y,true,1,onandtrackedall mean tracked;No,false,0,offanduntrackedall mean not tracked. Anything else is an error — reading an unrecognised word as "false" would switch tracking off across a catalogue. - A variant not stocked at a location is reported, not created. Add the location to the variant in Shopify first.
- Quantities are written as a correction. Shopify requires a reason on every inventory set, and a merchant restating the true count is exactly what "correction" means.
Practical notes
Count first, then edit. Export at the start of a stocktake so the sheet is a snapshot of what Shopify believed before you started counting. That snapshot is what makes the variance meaningful.
Beware of selling during a stocktake. Quantities you set replace whatever is there, so orders placed between export and sync are overwritten. For a busy store, count and sync in sections.
Keep the dated copy. Duplicate the tab before a large correction. It is the only record of what the numbers were before you decided they were wrong.
Getting your quantities from a supplier rather than a count? See updating stock from a supplier feed.
See every location in one grid
Export your stock across all locations, edit it in Google Sheets, and sync it back.
Try SheetSync today