Shopify Inventory Audit: How to Count Stock and Fix Discrepancies

Shopify's stock count is only as accurate as the last time someone checked it against reality. Returns get processed incorrectly, purchase orders get received in the system before physical stock arrives, and damaged units disappear without a Shopify adjustment. Over months, these errors compound into a gap between what Shopify shows and what you actually have. A structured inventory audit closes that gap — and a cycle counting schedule prevents it from reopening.

Why Shopify Inventory Counts Drift From Reality

A Shopify inventory count starts perfectly accurate the moment you set it. Over time, without active maintenance, it drifts. The drift is not random — it comes from predictable, repeatable sources:

• Purchase order receiving errors. The most common source. You receive 98 units from a supplier but mark the PO as received for the full 100 ordered. Shopify adds 100 to inventory; you physically have 98. That 2-unit discrepancy repeats across every partial delivery.
• Returns not restocked. A customer returns a product, you process the refund in Shopify (which restores inventory), but the physical item is damaged and you discard it. Shopify now shows 1 extra unit that doesn't exist.
• Theft and shrinkage. Products disappear — from shipping, warehousing, or retail environments. Shopify has no way to know unless you record an adjustment.
• Damaged goods. A unit is dropped, broken, or becomes unsellable. If no Shopify adjustment is made, it stays on the books as available inventory.
• Data entry errors. Manual inventory imports, CSV uploads, or quantity adjustments where someone entered 100 instead of 10.
• Multi-location miscounts. Stock transferred between locations but not recorded in Shopify — or recorded at the wrong location.

Full Stocktake vs Cycle Counting — Which to Use

You have two approaches to inventory auditing. They are not mutually exclusive — most merchants use both.

Full stocktake

Count every single SKU at every location in a single session. Shopify is usually paused for new orders during the count to prevent discrepancies from in-transit inventory. Full stocktakes are accurate but operationally disruptive — they require staff time, may require closing the store, and produce a point-in-time snapshot that starts drifting immediately after.

Best for: annual or semi-annual reconciliation, pre-season preparation before peak demand, or post-acquisition due diligence.

Cycle counting

Count a rotating subset of SKUs on an ongoing basis — for example, 10–15 products per week. Over the course of a year, every product gets counted at least once. High-velocity (A) items get counted more frequently because they have higher transaction volume and therefore higher discrepancy risk.

Best for: ongoing accuracy maintenance, catching discrepancies before they compound, and avoiding the disruption of an annual shutdown count.

Step-by-Step: How to Run a Shopify Inventory Audit

1. Export your current Shopify inventory

   Go to Shopify Admin → Products → Inventory. Click Export in the top-right corner. Select "Current inventory quantities" and your preferred format (CSV). This file is your expected count — what Shopify thinks you have at each location. Save it as your baseline before you touch anything else.

2. Count physical stock

   Count every unit physically, by SKU and location. For a full stocktake: pause new order fulfillment during the count period (or count before business hours). For cycle counting: count only the selected SKUs for this week's rotation. Record physical counts in a separate column in the exported spreadsheet. Do not adjust Shopify yet — you need the comparison first.

3. Compare physical vs digital counts

   Add a Discrepancy column to your spreadsheet: Physical Count − Shopify Count. Positive numbers mean you have more than Shopify shows (often from unreceived POs counted early in Shopify, or returns that weren't restocked). Negative numbers mean Shopify is overstating your stock (theft, damage, data entry errors). Flag every non-zero row for investigation.

4. Investigate before adjusting

   Before changing any Shopify quantities, find out why the discrepancy exists. Check: open purchase orders (stock received physically but not yet marked received in Shopify?), recent returns (physical return disposed but inventory restored?), recent transfers between locations. Understanding the root cause prevents the same error from recurring after you fix the number.

5. Adjust inventory in Shopify

   Go to Products → Inventory, search for the product variant, click the quantity for the relevant location, enter the correct quantity, and select an adjustment reason (Received, Return restock, Damage, Theft, Correction, or Other). Shopify logs every adjustment with a timestamp, reason, and quantity change. This audit trail is important for bookkeeping and for tracking which reason codes appear most frequently.

6. Set a cycle count schedule and prevent recurrence

   The adjustment fixes the current number. The schedule prevents future drift. Classify your SKUs by velocity: A items (top 20% by sales) — count monthly. B items (middle 30%) — count quarterly. C items (bottom 50%) — count annually. Schedule it in your team calendar as a recurring task. Review your most common adjustment reason codes quarterly to identify systemic process problems (e.g., if "Received" discrepancies are common, your PO receiving process needs tightening).

How EZStock Reduces Inventory Discrepancies at the Source

Most inventory discrepancies in Shopify start at the purchase order receiving stage. When stock arrives, merchants often mark a PO as fully received in their system regardless of whether the physical count matches what was ordered. Over time, these small receive-quantity errors — 48 units received, 50 recorded — compound into significant inaccuracies.

EZStock's purchase order workflow addresses this at the point of receipt. When you mark a PO as received in EZStock, you can enter the actual received quantity for each line item — not just confirm the ordered quantity. EZStock then updates Shopify inventory with the real received quantity, not the ordered quantity. This prevents the most common source of drift before it starts.

EZStock also supports partial receipts: if a supplier ships 3 of 5 line items, you can receive only those 3, keeping the other 2 as "outstanding" on the original PO. Shopify inventory reflects what actually arrived, not what you expected to arrive.