The 10 inventory mistakes almost every small store makes first

By 9:40 on a Tuesday morning you've handled three emails: a customer asking when the cedar dog harness will be back (it's been out of stock since Friday), a supplier confirmation for a PO that's nearly double what you meant to order, and your bookkeeper asking why inventory on the balance sheet and your count sheet disagree by a four-figure amount. Three unrelated fires? No. All three trace to inventory habits that almost every small store picks up in its first two years, and every one of them has a specific, documented fix.

This article diagnoses the ten most common, grouped by the kind of damage they do, with the symptom or number that exposes each one. Every diagnosis links to a deep-dive that owns the repair — the job here is correct diagnosis and a fast handoff, not re-teaching each specialty. If you'd rather work on prevention before something breaks, the six inventory SOPs worth writing first is the procedures-side companion to this list.

The ordering mistakes

1. Reorder triggers live in your head

The bin looks light, so you order. That system works until a strong sales week and a slow supplier arrive together. A quick worked example: your hiking socks sell 4.5 pairs a day, steady across the year. Your trigger is "when the shelf looks about half" — call it 120 pairs. Your supplier takes 24 days from PO to sellable stock. Demand during the wait is 4.5 × 24 = 108 pairs, so a half-full trigger leaves you 12 pairs of slack on an average cycle and none at all when anything runs long. The fix is writing the trigger down as a formula instead of a feeling: the reorder point formula (demand during lead time plus a buffer) takes about ten minutes per SKU and produces a number you can audit later.

2. You plan against the supplier's quoted lead time

Related, and more expensive: that 24 days was the quote, not the record. Suppliers quote production time; your reorder math needs order-to-sellable, including transit, customs, and your own receiving shelf. The gap between quoted and actual is the largest silent input error in small-store ordering — rebuilt on a measured number, the same sock trigger moves from 120 pairs to something meaningfully higher, and the panic orders stop. How to measure your real lead time from PO history is the whole subject of the supplier lead time deep-dive.

3. Your velocity math counts the days you were dark

Average daily sales computed over a period that includes out-of-stock days understates demand exactly where you can least afford it — the SKUs that ran out. Say a phone stand sold 4.2 units a day while in stock, but sat dark for 5 of the last 30 days: a naive 30-day average reports 3.5/day, and your next reorder point inherits the lie. The deeper version of this mistake is not knowing which SKUs were dark at all, so the error never gets found.

Since the correction is the whole point, a note on what we build: InventoryX computes velocity in-stock-only and keeps a per-SKU ledger of the days each product was out of stock — that's the correction above, applied automatically. What it doesn't do is forecast: it fixes your history and ranks the estimated damage; the buying judgment stays yours.

4. You fix a miss by doubling the next order

The emotional sequence after a dark week: order triple, promise yourself it won't happen again, then carry the surplus for two quarters while the cash conversion cycle stretches. Panic sizing is a mirror image of the original mistake — it treats a planning failure with a quantity, when the fix is a buffer sized on purpose. Safety stock has a formula, and the deliberate version almost always costs less than the panic version. If the overbuy has already happened, the cash-recovery sequence — freeze, rank, work it down — lives in the over-order triage guide rather than in a second panic in the opposite direction.

Worth knowing what a dark week actually does to customers: a shopper who hits an empty shelf doesn't usually wait for your restock — most buy the item somewhere else, and some never come back to check. The shelf goes quiet in a way the sales report shows only partially.

The accuracy mistakes

5. One count a year, for the accountant

The annual stocktake exists to satisfy the books, which means it finds errors up to eleven months after they were made — long after you could have traced the cause. A cycle count routine of one or two categories a week catches variances while the trail is still warm: the mislabeled tote, the unrecorded damage, the return that never made it back to a bin. The full counting process, including how to keep Shopify honest during a count, is covered in the Shopify counts guide.

6. Case packs and eaches blur together

You buy coffee beans in 5 lb bags and sell 12 oz bags, or you reorder 40 "units" of a harness and the supplier ships 40 case packs of six. When the Shopify SKU is set up in eaches but ordering happens in cases, receiving goes in wrong, the on-hand number inflates, and the first symptom is a top seller running out while the admin shows plenty. The fix is boring and non-negotiable: one unit of measure per SKU, defined before the first PO, with the unit of measure conventions written down where whoever receives can see them.

7. "Set quantity" becomes the fix-all button

A count says 40, the shelf says 34, and the fast fix is editing Shopify to 34. Done without a reason, repeated across a quarter, and you've built a catalog whose numbers are folklore. The inventory adjustments log is an audit trail — every edit, who made it, when — and its value depends entirely on whether each adjustment carries a reason you'll recognize in March. Save the set-to-N button for counted results, and route everything else through named reasons like damage, theft, or receiving error.

8. One product, two listings, split stock

The re-shot product went up as a new listing and the old one never got archived. Now the cedar harness exists twice: one listing shows 12 units, the other shows 3, customers buy from whichever ranks better, and both can oversell or starve independently. Duplicates are common after migrations, rebrands, and variant restructures — and the stock damage is invisible until you search for it. The find-and-merge procedure is in the duplicate products guide.

The attention mistakes

9. Every SKU gets the same care

Five hundred SKUs reviewed with equal diligence means your best sellers get whatever attention is left over on Friday afternoon. ABC analysis exists to end that arrangement: the A items that drive most of your revenue deserve a weekly look, C items a monthly glance. The classification can run on a spreadsheet or, these days, on native analysis in the Shopify admin (Shopify Help Center, accessed November 2026) — the mistake isn't the tooling, it's reviewing a bestseller and a dead pin design on the same schedule.

10. Dead stock is a tax-time discovery

Slow movers announce themselves early — 90 days without a sale, weeks of cover climbing past 150 — but they're easiest to ignore, so most stores meet them at year-end instead, when the options have narrowed to write-off. Catching them at 90 days keeps markdown, bundling, and return-to-vendor on the table. What dead stock is, why it accumulates, and what it costs monthly are laid out in the dead stock guide; the quarterly pruning routine that prevents it lives in the SKU rationalization workflow.

A two-minute self-audit

One honest caveat: no list of common inventory mistakes ships with a universal dollar figure, because the damage depends on your margins and velocity. What holds for everyone is the sequencing — accuracy mistakes poison the ordering decisions, so counting cadence is the first fix with compounding returns.

Common questions

What's the most common inventory mistake for small stores? Reordering by feel — no written reorder point, no measured lead time, trigger set by how the shelf looks. It's the most common because it works early on, when the catalog is small and the owner sees every bin daily. It fails quietly around a few hundred SKUs, exactly when the manual habit is hardest to unlearn.

How do I find out which of these mistakes my store has? Work the self-audit table above against the last quarter of your own operations. Counting and adjustment history reveal the accuracy mistakes within a week: run one category count and read every adjustment line for missing reasons. The ordering mistakes surface in your PO history — compare trigger dates against the dates you actually went dark.

Which mistake should I fix first? Counting cadence. Every other number — reorder points, velocity, ABC ranks, dead stock flags — is computed from on-hand quantities, so an unreliable count makes every downstream fix unreliable too. Set a weekly cycle count routine, then move to reorder math with numbers you can finally trust.

Do these mistakes really cost that much money? There's no honest universal number; anyone quoting one is guessing. You can bound it yourself: count the days each of your top SKUs was out of stock last quarter, multiply by its daily sales and margin, and you have an estimated floor for mistake #3 alone. For most stores that exercise is uncomfortable enough to fund the fixes.

Do these apply to POS and brick-and-mortar shops on Shopify? Same ten, plus one twist: physical locations add a per-location counting burden, so mistakes #5 through #7 hurt faster. A shop that sells in person and online should count by location and treat the POS till's same-day sales as part of the reconciliation, or the online number drifts from the shelf within days.

Next step

Pick the single mistake whose symptom you've seen twice this month — not the one that's easiest to fix. If it's an ordering mistake, compute the reorder point formula for your five fastest SKUs this week; if it's an accuracy mistake, schedule the first weekly count. When the diagnosis phase is done, turn each fix into a written procedure using the six inventory SOPs worth writing first, so the repair survives busy season even when you're not the one doing it.