The Ghost Stock: How to Anticipate Customer Orders Before They Call You
Published on March 31, 2026 | Success Story
In the warehouse of any wholesale distributor, the same silent enemy usually hides: ghost stock. These are those rows of boxes gathering dust on the back shelves that tie up your working capital, while at the sales desks, the phones won't stop ringing for products that are out of stock, with no idea when they will arrive. Buying blindly, relying solely on intuition of what sold last year, is a daily lottery.
The Trap of Reactive Purchasing
Most traditional distributors operate under a reactive scheme that generates constant inefficiencies:
- The client calls or sends a message with their usual order list.
- The administrative staff checks the warehouse and discovers one of the key products is missing.
- The sale is lost, partially delivered, or urgent freight is incurred to comply.
- The purchasing manager places orders with suppliers based on the "hunch" of the week.
This workflow usually translates into a high percentage of stockouts and expired or immobilized merchandise that reduces the business's net margin.
The Solution: Spotting Your Customers' Natural Rhythm
It's not about incorporating complex systems that require data analysts, but about organizing a simple background system that reads your billing history. Every client has an implicit purchasing rhythm that the office's daily routine doesn't let you see, but is recorded in the data.
We structured a flow that constantly analyzes these variables:
- Interval of purchase: How many days pass, on average, between each client's orders.
- Real seasonality: Which products see increased sales depending on the time of year or weather.
- Consumption trend: If a chain of stores has been steadily increasing its orders in a category.
How It Works in Practice
Every Monday morning, the purchasing manager receives a clean list of projections for the week in their email:
Weekly Order Projections - February 5 to 11
Client: El Sol Distributor
Likely orders:
- Flour 000 25kg: 50 bags (probability: 88%)
- Common sugar 50kg: 20 bags (probability: 82%)
Details: The client made their last purchase 12 days ago, and their average replenishment cycle is 14 days.
Tangible Results
A food distributor that implemented this projection system achieved:
- Reduction in shortages: Stockouts for fast-moving products dropped drastically.
- Less waste: By buying what is actually needed, expired merchandise was reduced almost completely.
- Purchasing planning: The manager went from spending the whole day on emergency purchases to resolving supply in a single morning.
Building Trust in the System
At first, it is natural for the purchasing manager to look skeptically at the system's suggestions and prefer to rely on experience. However, within a few weeks of comparing projections with actual orders, the tool becomes their best ally.
The system doesn't replace the manager's judgment, but gives them a solid foundation to decide with real data. It uses historical information as a starting point and adjusts final purchases based on daily occurrences (such as knowing a supplier will close for maintenance or that a client will open a new branch).
Key Lesson: You don't need to predict the future. Your historical data already holds the answer to what your clients will order next week. You only need a simple system to organize that information and show it to you clearly so you can buy with confidence and certainty.