How to Detect Dead Stock in a Wine List

Every bottle of wine that has been sitting in your cellar for more than 90 days without selling isn't just a stagnant product. It's tied-up capital you could have invested in references that actually generate a return. Dead stock doesn't hurt until you count it. And when you count it, it usually hurts a lot.

What Exactly Is Dead Stock

Dead stock isn't old wine or bad wine. It's any reference that has gone an excessive amount of time without generating a sale. Typical thresholds: | Category | Days Without Sale | Status | |---|---|---| | Active | < 30 days | Normal | | Alert | 30-60 days | Monitor | | At risk | 60-90 days | Take action | | Dead stock | > 90 days | Decide: liquidate or remove | A restaurant with 120 references and an average cost of €10 per bottle, with an average of 3 units in stock, has €3,600 in the cellar. If 18% is dead stock, that's €648 of dormant capital. Multiply that by 12 months and you're financing nearly €8,000 per year in wine that nobody orders.

Why Dead Stock Accumulates

Dead stock doesn't appear overnight. It builds up through small, repeated decisions: - Buying without rotation data: adding references because they seemed interesting, not because there was proven demand. - Restocking by inertia: ordering the same thing without checking what actually sold. - Incomplete wine-by-the-glass management: opening bottles that aren't ordered enough to turn a profit. - Ignoring alerts: not having a system that flags non-moving wines. - Loyalty to the supplier over the business: keeping references to maintain relationships, not results.

How to Detect Dead Stock in Your Cellar

Method 1: The Manual Review (monthly) Once a month, review your complete stock and mark every reference that hasn't sold in the last 30, 60, and 90 days. It's tedious, but if you have no system, it's the minimum. Method 2: The Sales Velocity Report If you have POS data, export sales by reference for the last 90 days. Any reference with zero or near-zero sales enters the dead stock watchlist. Sort by days since last sale, descending. Method 3: Automated Monitoring A system that automatically tracks stock age by reference, alerts when a wine crosses the 30/60/90-day thresholds, and generates weekly dead stock reports. This turns detection into a process rather than a project.

How to Quantify the Impact

Dead stock costs more than the purchase price. To calculate the real impact: 1. Count units: How many bottles are classified as dead stock? 2. Calculate value: Units × purchase price = capital tied up. 3. Add opportunity cost: What would that money have generated if invested in high-rotation references? 4. Add storage cost: The physical space those bottles occupy has a cost. 5. Consider depreciation: Some wines lose value over time. Others don't. Quick Formula Monthly dead stock cost = (Units × Avg. purchase price) + (Units × Avg. monthly margin of active reference) This gives you both the capital cost and the opportunity cost combined.

The 5 Actions to Reduce Dead Stock

1. Set a Dead Stock Policy Define clear rules: any reference with more than 90 days without sales enters automatic review. No exceptions, no sentiment. 2. Create an Exit Strategy For each dead stock reference, choose: - Promotion: feature as wine of the day or pairing suggestion. - Events: include in private dinners, tasting menus, or special events. - Return: negotiate return to the supplier. - Markdown: reduce price to accelerate sell-through. - Write-off: accept the loss and free the space. 3. Fix the Intake Process Dead stock is a buying problem, not a selling problem. Before adding any new reference, require: minimum expected rotation, target margin, and a slot it fills on the list. 4. Review Monthly Don't wait for the annual inventory. A monthly 15-minute dead stock review prevents accumulation. 5. Automate Manual processes get forgotten. A system that tracks, alerts, and reports dead stock automatically is the only reliable way to keep it under control.

Frequently Asked Questions

Is dead stock the same as slow-moving stock? Not exactly. Slow-moving stock still sells occasionally. Dead stock has zero or near-zero movement over an extended period. The boundary is typically 90 days without a sale. Can premium wines be dead stock? Absolutely. Price doesn't determine rotation. A €50 bottle that nobody orders for 4 months is dead stock, regardless of its quality. What percentage of dead stock is acceptable? Ideally less than 10% of total references. Above 15% is a serious problem that's actively eroding your margins. --- → [Winerim Supply: purchasing intelligence](/producto/winerim-supply) → [Winerim Core: list analytics](/producto/winerim-core) → [Dead wine checklist](/recursos/checklist-deteccion-vinos-muertos) → [Monthly margin review](/recursos/plantilla-analisis-margenes) → [Request a demo](/demo)