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

  1. Open the Inventory page in SheetSync and create or connect an inventory spreadsheet.
  2. Export. Every variant arrives with its quantity at every location.
  3. Check the Location Reference tab so you know which column is which.
  4. Edit the Available columns, and the Tracked column where needed.
  5. Paste formula results as values.
  6. Sync back and review the preview before approving.

The rules, and why they are what they are

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
← Update stock from a supplier feed