Shopify supports multiple locations well on its own. Problems start when other systems join in — a point of sale, a warehouse tool, a marketplace connector, a spreadsheet — and each one believes it owns the stock figure.

The four ways stock drifts

  1. Overwrites. System A says “7 in stock” at the same moment system B records a sale. B’s change is lost.
  2. Late recording. A delivery is received on Monday but entered on Thursday; the website oversells in between.
  3. Transfers in limbo. Stock leaves the warehouse but is never received in the shop.
  4. No history. When a number is wrong, nobody can see why, so it gets “fixed” by hand — and drifts again.

Design rule 1: one source of truth

Decide which system owns the stock number — for most Shopify merchants, Shopify itself. Every other system reads from it and reports changes to it.

Design rule 2: send adjustments, never counts

Integrations should say “minus one” or “plus twenty”, not “the count is now 7”. Adjustments from two systems at the same moment add up correctly; absolute counts overwrite each other. This single rule removes most drift.

Design rule 3: keep a ledger

Record every movement — sale, return, receipt, transfer, stock-take, write-off — with who, when and why. The current stock is simply the sum of the ledger. When something looks wrong, you can trace it in minutes.

Design rule 4: model transfers properly

A transfer has two ends. Stock should leave the sending location when dispatched and arrive at the receiving location when received, with “in transit” visible between.

Design rule 5: reconcile on a schedule

Compare your ledger with Shopify’s figures daily and investigate differences while they are small. Cycle-count a few products each week rather than closing for a big annual count.

Where an ERP helps

When you add purchasing, batch or expiry tracking, several stores or a busy physical shop, a Shopify-native ERP that follows these rules saves a great deal of manual correction. That is exactly how we built Canopy.

Not sure where your stock is drifting? A free Shopify audit includes an operations check.