How to Do a Stocktake on Shopify (Without Closing the Store for a Weekend)

Every Shopify merchant eventually discovers the same uncomfortable truth: the numbers in your admin are not the numbers on your shelves. Units get miscounted at receiving, returns go back in stock but never get logged, something walks out the door. The gap compounds quietly until it shows up as an oversell, a refund, and an apology email. A stocktake is how you close that gap. This guide covers how to run one on Shopify — the planning, the counting, the reconciliation — and why the annual weekend-long shutdown is usually the wrong way to do it.

What a stocktake actually is

A stocktake is the process of physically counting the products you have on hand and comparing that count against what your system says you have. The count itself is the easy part. The value comes from the third step everyone skips: investigating the variances so the same error doesn’t recur next quarter.

There are two ways to do it:

	Full physical count	Cycle counting
Frequency	A few times a year	Continuously, in small batches
Disruption	High — usually requires closing	Low — runs alongside normal operations
Effort	Concentrated into one brutal push	Spread evenly across the year
Error detection	Up to 12 months late	Within days or weeks

Most stores default to the full count because it feels thorough. In practice it’s the worse option for everything except your accountant’s year-end. You close for a day, everyone’s exhausted, accuracy suffers precisely because the count is so large — and any error you find might have been costing you money for eleven months.

Cycle counting: count a little, constantly

Cycle counting means counting a subset of your inventory on a regular rotation instead of counting everything at once. Over a year you still cover the whole catalog, but you never take the store offline to do it.

The standard approach is the ABC method, which counts products in proportion to how much they matter:

• A items — roughly the top 20% of your catalog driving ~80% of revenue. Count these monthly.
• B items — the next tier, ~15% of revenue. Count quarterly.
• C items — the long tail, ~5% of revenue. Count annually or semi-annually.

Your bestsellers get checked twelve times a year; your slow movers get checked once. Effort follows revenue. If you’ve already segmented your catalog for safety stock and reorder points, you can reuse the exact same ABC classification here.

A few other patterns worth knowing:

• Opportunity-based counting — verify stock at moments you’re already touching the product: receiving a shipment, picking an order, processing a return, or when an item hits its reorder point. Nearly free, since someone is holding the item anyway.
• Control group counting — count a small, fixed set of products repeatedly to test whether your process is sound before rolling it out across the catalog. If the same 30 SKUs keep coming up wrong, the problem is your method, not your stock.

How to run a stocktake on Shopify, step by step

1. Plan the count

Pick a quiet window — before opening, after closing, a slow weekday morning. Set a hard cutoff time and stop inventory movement during the count: no receiving, no transfers, no picking. Uncounted stock moving mid-count is the single most common source of phantom variances.

Decide the scope up front (which locations, which product classes), and assign sections to specific people so nothing gets counted twice or skipped.

2. Organize the space

Divide the stockroom into clearly labeled zones and count zone by zone. Products that live in multiple bins or locations need a documented rule for how they’re totaled — multi-bin products are a notorious source of double-counting.

If products don’t have scannable labels yet, fix that before you start. See how to print barcode labels for Shopify products — an unlabeled shelf turns a scan-through into a manual search.

3. Count — by scanning, not typing

This is where the method makes or breaks the whole exercise. Manual counting on a clipboard, then keying results into Shopify later, introduces errors at two separate points: the count and the transcription. Scanning removes both.

With a barcode workflow you walk the shelf, scan each item, and enter the quantity — the product is identified by the scan, so there’s no lookup and no chance of updating the wrong variant. Our Barcode Scan & Label app handles this on a phone or a dedicated scanner: scan to pull up the variant, set or adjust the quantity, and push the updates straight to Shopify in bulk. It also generates labels for anything unscannable, so a stocktake doubles as a chance to close the labeling gaps. The full scanning workflow is covered in bulk-updating Shopify inventory with a barcode scanner.

Two counting rules that matter:

• Count zero-stock items too. An item your system says is out of stock but that’s actually sitting in a back corner is a pure lost-sales bug. It only surfaces if you verify zeros.
• Break large counts into multiple smaller counts when several people are counting simultaneously. Concurrent counts on one big list tend not to reflect each other’s updates in real time, which produces conflicts you then have to unpick by hand.

4. Reconcile the variances

Compare physical counts against system records and calculate your inventory record accuracy (IRA):

IRA = (1 − (total discrepancies ÷ total units counted)) × 100

Counted 148 units where the system said 150? That’s 98.7% accuracy for that line. Track this number over time — it’s the metric that tells you whether your process is improving.

For each variance, log a reason: damage, shrinkage, receiving error, unrecorded transfer, data-entry mistake, or a return that never went back in stock. The reason codes are what turn a stocktake from a correction into a diagnosis.

One Shopify-specific catch: the admin’s inventory adjustment history is limited to 90 days. If you want a durable audit trail of what changed and why, export or record your stocktake results outside that window rather than assuming you can look it up next year.

5. Adjust and improve

Push the corrections to Shopify, then act on the patterns. If receiving errors dominate, tighten your receiving process — scan shipments in rather than eyeballing packing slips. If shrinkage clusters in one category, that’s a security or storage question. Then set the next count’s schedule before you close the laptop, or the cadence quietly dies.

Frequently asked questions

How often should I do a stocktake? Annual or semi-annual for a full physical count if your accounting requires one. But the better answer is continuous cycle counting: A items monthly, B quarterly, C annually. Perishable and high-value goods warrant weekly checks.

Do I need a barcode scanner? For a small catalog, no — but you’ll count slower and make more transcription errors. Once you’re past a few hundred SKUs, scanning is what makes frequent counting practical rather than theoretical. A phone camera works as a scanner for most stores.

Should I close the store during a stocktake? For a full physical count, yes, or at least freeze inventory movement. That’s the main argument for cycle counting — small batches let you count during business hours without stopping anything.

What’s an acceptable inventory accuracy rate? Aim high — 95%+ as a floor, with your A items closer to 99%. More important than the absolute number is the trend: accuracy should climb as you fix root causes.

The takeaway

Stocktakes fail when they’re rare, huge, and manual. Make them frequent, small, and scanned instead: rotate through the catalog with ABC cycle counts, scan barcodes rather than typing SKUs, verify your zeros, and log a reason for every variance so the same error doesn’t come back. Your inventory numbers become something you can actually trust — which is the whole point, since every restock decision downstream depends on them.

Ready to count by scanning instead of typing? Get Barcode Scan & Label and run your next stocktake from your phone.