What inventory mistake costs Shopify merchants the most money?

Hi everyone,

I’ve been reading quite a few discussions about inventory lately, and something I’m trying to understand is where inventory problems actually become expensive for merchants.

There seem to be lots of possible issues — stockouts, overstocking, inaccurate quantities, supplier delays, transfers between locations, products sitting too long, etc.

But I’m curious about the merchant perspective:

What inventory mistake or problem has actually cost your business the most money or caused the biggest headache?

And what caused it?

For example, was it:

  • ordering too much,
  • running out of a bestseller,
  • inventory being wrong across locations/channels,
  • ordering too late,
  • supplier delays,
  • or something completely different?

I’m particularly interested in what happened before you realized there was a problem.

Did Shopify warn you early enough, did another tool catch it, or did you only discover it after something went wrong?

I’m researching how merchants actually deal with these operational problems, so real experiences would be really helpful.

Thanks!

In our experience, most of our users were dealing with inaccurate inventory across locations and channels because they lacked real-time synchronization, along with late reordering due to the absence of timely low-stock alerts.

We’ve been addressing those gaps with ChannelBay and are now expanding into other workflows our users have been asking for as well.

Hi @vedasuite
I think inaccurate inventory across multiple locations or sales channels can be especially costly because the problem may not become obvious until an order has already been placed. A low-stock alert can help with reordering, but if the inventory quantity itself is incorrect, the alert may not be reliable either.

I’d be interested to know how merchants currently verify that their inventory data is accurate across all locations and channels before relying on those alerts.

@vedasuite That makes a lot of sense. I especially agree that the real problem is often the gap between the inventory becoming inaccurate and the merchant actually discovering it.

The examples around returns, damaged stock, and sync delays are interesting because each one can create small discrepancies that go unnoticed until they affect a customer. I’d be curious to know what kind of early warning would actually be useful for merchants here for example, alerts when inventory data starts drifting between locations or channels rather than only when stock reaches a low threshold.

Hi @vedasuite :raising_hands:

For us, the most expensive inventory issue wasn’t overstocking or supplier delays — it was inaccurate inventory across multiple sales channels.

The frustrating part was that everything looked fine until it wasn’t. Products were selling normally, inventory numbers seemed reasonable, and there were no obvious warning signs. We only realized there was a problem after customers started ordering items that were technically already sold elsewhere.

In our case, the root cause was inventory being shared across multiple products and sales channels without a reliable synchronization process. One product would sell, but the related inventory wouldn’t update everywhere quickly enough, which occasionally led to overselling.

Shopify’s inventory tracking is great for many use cases, but when inventory is shared between products, bundles, multiple stores, or multiple locations, things can become much more complicated.

What ultimately helped was moving to a shared inventory setup with automatic synchronization. We currently use Easify Inventory Sync for that, but honestly the biggest lesson wasn’t the tool itself — it was realizing that inventory errors often stay hidden until they directly affect a customer order.

By the time you discover the issue, you’ve usually already lost time dealing with cancellations, customer service, refunds, or urgent stock transfers.

So if I had to pick one inventory problem that caused the biggest headache, it would definitely be inventory discrepancies rather than stock levels themselves.:heart:

A few of you have mentioned something that I hadn’t separated clearly before — the problem may not just be low inventory, but whether the inventory number itself can be trusted.

For merchants actually running stores, I’d especially love to hear real examples of this:

How do you currently discover that Shopify’s inventory quantity is wrong?

Is it usually a stock count, an oversold order, a return that wasn’t adjusted correctly, a supplier/warehouse discrepancy, or something else?

And roughly how often do you actively verify inventory accuracy rather than waiting for a problem to expose it?

I’m particularly interested in first-hand merchant experiences rather than tools or solutions at this stage.

Thanks — the days-of-cover approach makes much more sense than a fixed low-stock threshold.

What I’d really like to understand now is whether merchants here are actually using something like this in practice.

If you’re running a store and using sales velocity + supplier lead time to make reorder decisions, are you calculating this in Shopify, a spreadsheet, or another tool?

And what usually causes the forecast to go wrong — sudden demand changes, supplier delays, inaccurate inventory, or something else?

I’m particularly interested in first-hand examples where the warning came too late and actually caused a stockout or over-order.

The working-capital angle is interesting — most of the discussion so far has focused on stockouts and inaccurate inventory rather than the cost of inventory that simply isn’t moving.

Since you work specifically on this problem, do you have a sense of what merchants typically do once a slow-moving SKU is identified?

For example: stop reordering, discount it, bundle it, transfer stock, change pricing, or something else?

I’m trying to understand whether identifying the problem is actually the difficult part, or whether deciding what action to take afterwards is the bigger challenge.

Those are two different questions and the answers aren’t the same.

On what breaks the forecast. It’s rarely demand moving. It’s lead time variance, and the on-hand number being wrong before the math ever runs. If a supplier quotes 14 days and actually lands somewhere between 12 and 40, your safety buffer is doing all the work and the velocity calculation is decoration. Minimum order quantity is the other one people leave out. You can compute a perfect reorder point of 37 units and then find out the supplier ships in cases of 144.

But the bigger issue is that days of cover is computed on available inventory. If available is wrong then the forecast is wrong too, and it stays confident the whole time.

On how the count goes bad quietly, a few that come up constantly. Returns put back on the shelf without an adjustment. Damaged stock nobody writes off. Transfers marked complete when the truck leaves rather than when someone receives it, so for a week both locations think they have the same units.

That last one is worth checking today if you run more than one location. Keep transfers in transit until the receiving side actually accepts them.

Counting has the same trap. If you run a stock take without freezing the SKUs you’re counting something that’s still moving. Someone fulfils an order halfway through and the count is wrong the moment you finish it. Freeze the SKUs, count, then release.

Your second question is the more interesting one. Identifying slow movers is easy, anyone can rank them in a spreadsheet in ten minutes. Deciding is where it stalls, and usually because the cost basis is soft. If landed cost is approximate then the margin on the discount you’re weighing is approximate too, and in my experience the error almost always makes the product look better than it really is. So people hesitate, and the stock sits another quarter.

One problem I’d add to this list is cost drift.

Inventory quantity can be perfectly correct while the financial side is quietly wrong.

Supplier cost changes, but Shopify still has the old Cost per item. Nothing visibly breaks - stock is available, orders keep flowing - but the margin you’re looking at is no longer the margin you’re actually making.

I think that’s what makes it dangerous compared with a stockout. A stockout is obvious immediately. A wrong product cost can sit there for weeks before somebody notices that a product that looked healthy on paper is barely making anything.

For physical retail, I’d probably treat supplier cost verification at receiving as an inventory control, not just an accounting task.

The thread has named the expensive mistakes, so here is the variable that decides how expensive: time to discovery. An inventory number that is wrong for an hour costs you one oversell. The same number wrong for three weeks quietly reprices your reorders, your ads and your promises to customers, and Easify-Jennifer’s story upthread shows exactly that shape - everything looked fine until orders exposed it.

What makes this class nasty is that nothing in the system volunteers the information. A sync that stopped reports nothing; a miscount contradicts no screen; the platform’s own adjustment history is per-variant, one at a time, so nobody reads it preventively.

The cheap ritual that catches most of it: export your inventory CSV weekly and diff the quantities against last week’s export. Big unexplained jumps, negatives, and items that have not moved a unit in a store that sells daily - that is your check-this list, ten minutes a week, no app required. It does not tell you which number is right, but it tells you where to look, and “where to look” is the whole game when the failure mode is silence.

Disclosure of trade: my app (StoreTwin) exists for the two-store version of this problem - its daily job is comparing end states and naming differences - so measuring time-to-discovery is professionally my whole worldview. Weigh accordingly.

The mistake nobody here has priced is phantom stock, and it never shows up in the ledger.

A unit exists in Shopify and does not exist on the shelf. Not damaged, not sitting at another location, not a sync fault: somebody took it, or broke it, or sold it at the counter months ago under a neighbouring barcode, and nothing anywhere looks wrong. Then a customer buys it online, waits three days, and gets an apology and a refund. The refund costs you postage and picking time. Losing that customer costs you every order they would have placed over the next two years.

They never tell you, so the loss never lands beside the incident that caused it.

Nothing catches this except counting, since no report holds the information. One section every six weeks, fifteen minutes at a time, is the entire fix, and it costs a rota rather than a subscription.

Disclosure: I build Binly (Binly ‑ Stocktake & Reorder - Stocky replacement: phone stocktakes, POs & smart reorder | Shopify App Store), and section counts are what it sells, so weigh the emphasis accordingly.

(post deleted by author)

@KynaatJohn’s question is the sharper one here, a low-stock alert is only as good as the number it’s alerting on, and that’s where the real cost hides. The most expensive version of this isn’t usually a dramatic single event, it’s a slow-drift problem: inventory counts becoming quietly wrong over weeks through returns processed incorrectly, damaged stock never written off, manual counts done once a quarter instead of continuously, or sync delays between POS and online that compound small errors over time. By the time it’s “obvious” (an oversell, a customer refund, a stockout that shouldn’t have happened), the actual cost has usually already accumulated invisibly for weeks.

The “before you realized there was a problem” question is the right one to focus on, because most merchants don’t catch this through a warning system at all, they catch it through a customer complaint or a physical stock count that doesn’t match the screen. That gap (no early warning until something customer-facing breaks) is usually the actual expensive part, more than any single inventory decision like over-ordering or under-ordering.

Best,
Vikash Jha - Apploy

@VikashJ That’s a really good point. I think the “slow-drift” issue is easy to overlook because nothing looks seriously wrong at first, but those small discrepancies can add up over time.

I especially like your point about the gap between the inventory number being wrong and the merchant actually realizing it. By the time it shows up as an oversell or stockout, the problem has already been there for a while.