The store says 14. The rack says 9. Five orders from now, someone is refunded instead of shipped.
Overruns and the own label sell online. The store, the warehouse sheet and Tally each keep their own count, and Tally only finds out at month end — with the GST place of supply wrong on a third of the vouchers.
- SKUs drifting today
- 3
- vouchers typed by hand
- 0
- stock agreed across all three
- Daily
| A | B | C | D | E | F | G | |
|---|---|---|---|---|---|---|---|
| 1 | SKU | Item | Store says | Rack (counted) | Tally | Drift | Action |
| 2 | KS-2231-OLV-M | Crew tee · olive · M | 14 | 9 | 9 | +5 | store pulled to rack count |
| 3 | KS-2231-OLV-L | Crew tee · olive · L | 22 | 22 | 22 | ||
| 4 | KS-2232-INK-S | V-neck long sleeve · ink · S | 6 | 6 | 6 | ||
| 5 | KS-2240-SUN-4Y | Kids’ dress · sun · 4Y | 31 | 28 | 28 | +3 | store pulled to rack count |
| 6 | KS-2218-SND-M | Lounge set · sand · M | 9 | 9 | 9 |
The nightly count: the store, the warehouse sheet and Tally, side by side. 2 SKUs disagree. The store thinks it has 14 olive Ms; the rack has 9.
- Shopify order and fulfilment webhooks
- Stock across channels
- Dispatch confirmations
- Does channel stock match actual stock?
- Has anything shipped without being recorded?
- The customer, with order and shipping updates
- Your accountant, with the data already in Tally’s shape
Already out there, said honestly: Unicommerce and Vinculum do this at platform scale and price. For a small Shopify exporter that deployment is oversized; glue is the proportionate answer.