How to Do an Inventory Audit for Your Shopify Store

An inventory audit is a physical count and verification of your stock against what your records say you should have. You open Shopify, you look at the inventory numbers, and then you go count what's actually on the shelf. When those two numbers match, you're in good shape. When they don't, you have a problem you need to find and fix.

Most Shopify merchants audit too rarely. Small discrepancies build up over time — a return that got restocked without a record update, a shipment that was short-counted on receipt, a damaged unit that was tossed without a write-off. After a year without an audit, the discrepancies compound and your inventory records become unreliable. You can't trust your reorder points. You can't trust your COGS numbers. You definitely can't trust your "days of stock remaining" estimates.

Types of inventory audits

Full physical count

You count every single SKU in your warehouse or storage. Everything stops. Staff count. You reconcile against Shopify. This is the most accurate method and the most disruptive. Most small businesses do this once a year, typically at year-end for accounting purposes.

Cycle count

You count a subset of SKUs on a rotating schedule. Instead of one big audit per year, you're continuously auditing — maybe 20 products a week or all products in one product category per month. By the end of the year, every product has been counted at least once. Less disruption, same coverage over time.

Spot check

You pick a few high-value or high-velocity SKUs and count them. No schedule — you do it when something looks off. Useful for catching specific problems but not a substitute for systematic auditing.

How to run a Shopify inventory audit: step by step

Step 1: Export your current inventory from Shopify

Go to Products > Inventory in your Shopify admin. Export to CSV. This gives you a snapshot of every SKU with its recorded quantity on hand. This is your "book inventory" — what the system thinks you have.

If you have multiple locations, export each location separately. Don't mix them — a product that Shopify thinks is at your warehouse when it's actually at your 3PL is an audit discrepancy even if the total count is right.

Step 2: Freeze inventory movements (if possible)

During a full count, pause order fulfillment if you can. If orders are being picked and shipped while you're counting, your count will be off before you finish. For small operations, close order processing for a morning. For larger operations, plan your audit for a low-volume period like early Sunday.

If you can't stop order flow, note the orders being processed during the count and adjust your count results accordingly.

Step 3: Count without looking at expected numbers

This is important. Don't give counters the Shopify export while they're counting. If someone knows the system says 47 units and they count 45, they'll often recount until they get 47. You want raw, unbiased counts. Give them blank count sheets with product name, SKU, and location only. Record what they find.

Step 4: Reconcile count against book inventory

Compare your physical count sheet to the Shopify export. Mark every discrepancy. A discrepancy is any product where the physical count doesn't match the system quantity — whether over or under.

For significant discrepancies (more than 5% variance on a product), recount before accepting the result. Small discrepancies on high-volume products can be counting errors.

Step 5: Investigate discrepancies before correcting

Don't just update Shopify to match the physical count immediately. First figure out why the discrepancy exists. Common causes:

• Returns restocked without a Shopify inventory update
• Received shipment entered incorrectly (wrong quantity or wrong SKU)
• Items damaged and discarded without a write-off
• Theft or shrinkage
• Items moved between locations without a transfer record
• Fulfillment errors — items shipped but not recorded as picked

Understanding the root cause lets you fix the process, not just the number. If returns keep being restocked without record updates, fix the returns process. If received shipments are consistently miscounted, improve your receiving procedure.

Step 6: Update Shopify inventory quantities

Once you've investigated, go to Products > Inventory in Shopify and update quantities to match your verified physical count. For bulk corrections, use the CSV import function. For individual corrections, use the "Update quantity" option directly on the product.

Add a note in your inventory management records explaining any significant adjustments. If you write off $2,000 of damaged inventory, document that. It matters for your tax records and for understanding your actual COGS.

What to look for during an audit

Beyond the count-versus-book reconciliation, use the audit as an opportunity to assess inventory quality and catalog health:

Dead stock: Products with no recent sales movement that are taking up physical and financial space. Flag anything with zero orders in the past 90 days. These need a liquidation decision.

Damaged or expired product: Anything that can't be sold at full price. Write it off immediately or route it to clearance pricing. Keeping it in inventory at full cost inflates your inventory value and makes your margins look better than they are.

Mislabeled or mis-shelved items: Products in the wrong location or with incorrect labels create fulfillment errors down the line. Fix them during the audit.

SKU proliferation: Products that exist as separate SKUs but are effectively the same thing. Slight variations in a product that got created as separate items instead of variants. These create unnecessary catalog complexity and split sales data.

How often to audit

The right frequency depends on your order volume and catalog size:

If you're using a 3PL, ask them for their cycle count reports. Most 3PLs perform regular counts and will share the results. You should still reconcile their counts against your Shopify records — 3PLs make receiving errors too.

Using ShelfMerge's inventory health score before and after audits

ShelfMerge calculates a shelf health score that factors in dead stock percentage, SKU proliferation, duplicate products, and slow-moving inventory. Before an audit, your health score tells you which areas are likely to have problems. After an audit, re-running the score shows what actually moved as a result of corrections.

A typical Shopify store that hasn't audited in 12+ months will find 3–8% inventory variance when they do a full count. At $100,000 in inventory value, that's $3,000–$8,000 of discrepancy that's been distorting every financial metric the store tracks. An audit doesn't just fix your numbers — it fixes every decision that's based on those numbers.