Physical inventory counts happen at the end of the month or quarter. The inventory management that normally hums along quietly looks different on this day. While warehouse staff count shelves one by one, Shopify keeps taking orders and the auto-sync keeps rewriting your sheet. When this "data in motion" collides with "data you want to hold still," the count results become untrustworthy.
The secret to a successful count is simple: intentionally carve out time when nothing moves. This time we walk through the full flow—prep the day before, sheet operations on the day, and resyncing afterwards—as a single continuous path.
Prep before count day
More than half of a count's success is decided by the day-before prep. Scrambling on the day itself with "this is missing, I don't know that" is a sign of insufficient prep. Start by sharing the schedule and the "no sheet editing" window with everyone involved.
Next, lock down the current sheet as "the latest version before freezing." Ideally, after closing the day before, every pending inbound and outbound movement is reflected. A supplier delivery came in, a return came back, a sample shipped out—if you head into the count with these exceptions hanging, identifying the source of any discrepancy becomes very hard.
Take a snapshot of the sheet
Take a snapshot (a copy) of the sheet the day before. In Google Sheets, use File, Make a copy, and save it under a different name. Something like "inventory-master_2026-04-30_pre-count" with the date in the name is easy to find later.
Google Sheets has version history, so in theory you can always roll back. In practice, however, keeping a copy of "the state at that exact moment" is far easier to work with. You will inevitably end up wanting to compare the actuals in sheet A with the actuals in sheet B side by side for discrepancy analysis.
Operations during the count
During the count, the iron rule is to freeze the sheet. That said, freezing absolutely everything is not realistic. Shopify orders do not stop, and customer inquiries keep coming. So you adjust the operational rules.
- 01Pause the auto-sync from the sheet to Shopify several hours before the count starts
- 02Record orders that come in on the Shopify side in a separate "frozen-period log" sheet
- 03Write physical count tallies into a dedicated count sheet (never touch the master)
- 04Set aside any incoming supplier deliveries during the count in separate boxes; do not put them on the shelves
- 05Answer inquiries using the snapshot's numbers
The point comes down to one thing: do not touch the master sheet. Every time a number moves during the count, you lose the ability to tell whether that move is a real actual or a count discrepancy. That is why you route every movement somewhere else.
If the count will take more than half a day, you can also choose to show some Shopify products as "out of stock" during the count. This is the stronger measure of physically halting orders in that window. For an annual count, some stores prioritize data trustworthiness over half a day of missed sales.
What to sync once you finish
When the count is done, it is finally time to reflect the results in the master sheet. Overwriting everything in one sweep is dangerous. For products with large discrepancies in particular, if you overwrite without checking causes, you later cannot trace why a number became what it became.
The recommended approach is a two-step reflection. First, on the count sheet, build a list of differences between "actual" and "the figure on the sheet." Products with zero, one, or two units of difference are fine—accept them as within the margin of error. Pull out only the products with large discrepancies and investigate each cause one by one.
- Damage or loss: record in a write-off log, then reduce
- Missed return processing: confirm the relevant order and reflect
- Discovered mis-shipment: hold; this needs a customer-service decision
- Missed receiving: confirm with the supplier, then reflect
- Cause unknown: log it as "unexplained discrepancy" to feed trend analysis
Once you have confirmed the causes, update the master sheet and resume the auto-sync. Right before resuming, take another snapshot of the sheet. The "immediately post-count" and "immediately pre-resync" snapshots become anchor points you can use later to trace what moved after that count.
Count day is one of the most nerve-racking days in running a store. Yet if you stick to your prep and your sheet freeze rules, you can reduce incidents dramatically. If you use a sheet that syncs with Shopify, intentionally carve out "time when sync is paused" and "time when no one touches the master." That alone takes the precision of your count up a notch.
The prep that feels tedious is the single best investment you can make in your future self. On your next count day, try carving out that "do not move" time on purpose.