Think Build Implement Repeat
London, UK +44 7367 067226
WhatsApp FOLLOW f in X
  1. Home
  2. Blog
  3. Predicting Stockouts Before They Happen
AI & Machine Learning

Predicting Stockouts Before They Happen

A reorder point reacts to stock falling. Predicting which lines will run out, and when, gives time to act - and phantom inventory is the hidden cause.

Updated 2 min readBy SpiderHunts Technologies

Free estimateNo obligation

Get a free estimate

Tell us what you need. A senior engineer reads every enquiry.

Takes under a minute. We never share your details.

  • Free consultation
  • No commitment
  • NDA on request

Prefer to talk? Book a free 30-minute call →

Quick answer — TL;DR

Predicting stockouts means combining demand forecast, current stock, inbound deliveries and lead time reliability. The most common hidden cause is stock records that do not match reality, which no forecast can overcome.

Reacting versus anticipating

A reorder point triggers when stock falls to a level. That is reactive by design - by the time it fires, the lead time clock starts and a stockout may already be unavoidable.

Predicting the stockout instead gives a window: this line will run out in about eleven days, the supplier takes fourteen, so act now. That difference is where the value is.

What goes into the prediction

  1. Demand forecast for the line, at the location that matters.
  2. Current stock, with an honest view of its accuracy.
  3. Inbound orders and their realistic arrival dates, not the promised ones.
  4. Lead time distribution for that supplier and item, not the quoted figure.
  5. Any known upcoming events - a promotion, a large order, a seasonal shift.

Points three and four matter more than people expect. Planning on promised delivery dates when the supplier's actual history says otherwise builds the optimism straight into the projection.

Phantom inventory

The most common reason a stockout prediction fails is that the recorded stock figure is wrong. The system says fourteen; the shelf has three.

CauseDetection
Theft and shrinkageCycle counts, sales stopping while stock shows available
Receiving errorsReconciliation against delivery notes
Misplaced stockPhysically present, not where the system says
Damage not written offCounted as sellable, is not
Returns processed incorrectlyStock added that never came back

A useful and often overlooked signal: a line showing stock available that has sold nothing for an unusually long period, when comparable stores or the previous pattern say it should have. That is frequently phantom stock rather than a demand change.

Prioritise the alerts

Predicting stockouts across a large catalogue produces more alerts than anyone can act on. Ranking by consequence rather than probability is what makes it usable.

Rank by expected lost margin - probability of stockout multiplied by the value at stake - and by whether the item is substitutable. A stockout on a product with a close alternative on the same shelf costs far less than one on a line customers came specifically for.

Measure prevention, not prediction

The awkward thing about a stockout prediction system working well is that the predicted stockouts do not happen, because someone acted. Accuracy measured against outcomes will look poor.

Measure the operational outcome instead: stockout incidents, availability on key lines, and expedited orders avoided. And keep a record of which alerts were acted on, so prediction accuracy can be assessed on the ones where nothing was done.

The stockout you predicted and prevented will look like a false alarm. Measure availability, not accuracy.

FAQ

Frequently asked questions

The questions readers ask us after this guide.

Still have a question?

Ask us directly — a senior engineer will get back to you.

Ask about your project

How accurate does the stock figure need to be?

Accurate enough that the projection is meaningful. Where record accuracy is poor, fixing that comes before any prediction work.

Should this replace reorder points?

It can complement them. Reorder points are simple and robust; prediction adds foresight on the lines where it matters most.

What about slow-moving items?

Prediction is weak there because demand is erratic. A policy-based approach usually serves better - see our piece on forecasting intermittent demand.

How far ahead can stockouts be predicted?

Usefully, about as far as your demand forecast remains reliable. Beyond that the projection is mostly assumption.

Keep reading

More on AI & Machine Learning

Start here

Want machine learning project details from us?

Tell us what you are trying to predict and roughly what data you hold. We will come back with an honest view on whether machine learning is the right tool, what the work would involve and a realistic cost range. If a spreadsheet would do the job, we will say so.

  1. You tell us what you needTwo minutes on the form, or a message on WhatsApp.
  2. A senior engineer reviews itAnd comes back with questions, a realistic range and an honest view on fit.
  3. Free 30-minute scoping callWe talk through scope, options and a realistic estimate — with no obligation.
Free estimateNo obligation

Talk to someone who builds this

Send a short brief and we will come back with an honest view and a realistic range.

Takes under a minute. We never share your details.

  • Free consultation
  • No commitment
  • NDA on request

Prefer to talk? Book a free 30-minute call →