A bottle that has not sold for more than 90 days deserves a review, even if it may have a cellaring or seasonal role. Its cost forms part of tied-up capital: review its role before deciding whether to reallocate future purchases.
Dead stock does not hurt until you count it. And once you count it, it often hurts quite a lot.
What exactly is dead stock?
Dead stock is not old wine or bad wine. It is any wine that has gone an excessive time without a sale. These thresholds are review examples, not universal benchmarks. Adjust the criteria for seasonality, cellaring role, availability and demand:
| Category | Days without a sale | Status |
|---|---|---|
| Active | < 30 days | Normal |
| On watch | 30-60 days | Monitor |
| At risk | 60-90 days | Take action |
| Dead stock | > 90 days | Decide: clear or delist |
Fictional example: 120 wines × 3 bottles × €10 unit cost = €3,600 of inventory. If 18% of that value, not just of the number of wines, corresponds to the non-moving stock defined for the review, that is €648 of capital tied up at that moment. Do not multiply that same stock by twelve to calculate an annual cost. Estimating financing requires an explicit rate and period.
How to detect it without software
Method 1: The quarterly manual audit
- List all your active wines.
- For each one, record the actual last sale date, not an estimate.
- Calculate the days since the last sale.
- Mark everything over 60 days in red.
- Add up the capital invested in those wines.
Review time: measure it using your records; it depends on list size, data quality and the process. No duration has been validated for this article.
Method 2: The dust test
Dust is only a signal to inspect, not proof of a lack of sales: a bottle may be intended for cellaring. Check the sale date, inventory, condition and role of that wine.
Method 3: Ask the service team
The service team knows which wines do not sell. They know because they never recommend them, customers do not ask for them and those bottles have been in the same place for months. Ask them: "Which 5 wines would you remove from the list?" Treat the answers as hypotheses and check them against sales and inventory.
The 5 main causes of dead stock
1. Impulse buying
It was bought because someone liked it at a tasting, the sales representative recommended it or "we needed something from this area". Without assessing actual demand.
2. Misaligned pricing
The wine could work, but its selling price does not fit the list's price ladder. It sits in no-man's-land.
3. Lack of visibility
It is on the list, but no one sees it, recommends it or knows it. It is a ghost.
4. Overstocking the initial purchase
Fictional example: 12 units are bought and one sells each month, with no further purchases or losses. After the first sale, 11 units remain: at the same rate, they represent 11 additional months of stock cover. This is a projection, not a calculated financing cost or a certainty about demand.
5. The list is not reviewed
The wine was added a year ago and no one has assessed whether it still makes sense.
Action plan: what to do with dead stock
For wines with little remaining stock (1-3 units):
- Daily recommendation with an appealing service-team pitch.
- Special pairing linked to a seasonal dish.
- Discounted glass to move stock quickly without losing the entire margin.
For wines with substantial remaining stock (4+ units):
- Negotiate a return with the supplier if the agreed terms allow it.
- Include in set menus for groups or events with an adjusted margin.
- By-the-glass clearance offer with an end point: "while stocks last".
For wines without an identified commercial outlet:
- Review recoverable value with the person responsible for accounting and decide how to treat the stock; a lack of sales does not justify an automatic write-off.
- Document why they failed: impulse purchase? Misaligned pricing? Lack of service-team training?
- Use the lesson in the next purchasing decision.
The cost of dead stock that nobody calculates
| Item | Calculation |
|---|---|
| Tied-up capital | Number of dead-stock bottles × average cost |
| Opportunity cost | Profit from a viable alternative, with explicit demand, period, costs and assumptions |
| Storage cost | Attributable floor area × cost per square metre and a defined period |
| Management cost | Time spent managing wines that do not sell |
Fictional example: 25 bottles × €12 unit cost = €300 of tied-up capital. That value does not allow you to infer a monthly or annual margin by multiplying it by a margin percentage: selling price, units sold, demand and period are missing. Separate capital, financing cost and the potential profit of an alternative; do not present them as demonstrated losses.
How to prevent it from building up
- Proposed monthly review: review, for example, the 10 wines with the lowest turnover, adjusting the frequency to the business.
- Purchasing rule: assess whether a new wine meets a need or replaces another; do not impose automatic removals.
- Maximum stock per wine: calculate it using actual sales rate, not what the supplier offers you.
- Indicative 60-day alert: it can trigger a review, not automatic removal; adjust the period for cellaring and seasonality.
- Automation: a system can support the review if its data and integrations are sufficient; verify its coverage and measure time and errors before attributing an improvement to it.
Frequently asked questions
How much dead stock is "normal"? No normal percentage has been validated for this article. Define whether you measure bottles, wines or value and compare equivalent periods, considering cellaring and seasonality before setting targets.
Should I record it as a loss? Slow turnover does not by itself establish an accounting loss. Review the wine's condition, recoverable value and actual sale or return options with the person responsible for accounting; do not automatically write off inventory for exceeding a threshold of days.
Is it worse in large or small restaurants? The impact depends on inventory value and the establishment's resources. Compare the absolute amount and its proportion of stock or budget; venue size alone does not determine the damage.
→ Winerim Core: dead stock detection → Winerim Supply: purchasing intelligence → Dead stock calculator → Dead wine stock detection checklist → Request a demo