What dead stock means in Optiply

Keep the dead-stock quantity and its value separate. Each measure has its own unit:

MeasureUnitWhat it counts
Dead-stock quantityUnitsThe units of a product's stock on hand above the 730-day-equivalent demand threshold.
Dead-stock valueCurrencyThe purchase-price value of those units. Analytics shows it as Deadstock value on the Overview card and Deadstock Value in chart legends.
Simulated dead-stock cashCurrencyA figure from a planning simulation, shown with the simulated values in the Cashflow report.

Dead stock is a calculated measure of long-horizon excess stock, not proof that a product has never sold. A product can have surplus stock without all of that surplus being classified as dead stock.

How Optiply calculates dead-stock quantity and dead-stock value

Optiply calculates dead stock for each product in these steps:

  1. Optiply takes the product's forecast daily demand: the forecast daily average. For established products, that is the average of the first 30 forecast days.
  2. The 730-day-equivalent demand threshold is that daily demand multiplied by 730. It scales one daily average. It does not sum a two-year forecast.
  3. The dead-stock quantity is the product's stock on hand minus the threshold, kept at zero or above. Stock on hand is the current stock shown as Free stock on the product page. Incoming stock is not added.
  4. For inventory valuation, Optiply multiplies each product's dead-stock units by its purchase price and adds those values together. The purchase price is the active supplier's purchase price. The fallback is the average of the non-zero linked supplier prices. Price adjustments apply.

Why dead-stock value grows or is high for an ABC category

Dead-stock value can grow from more stock on hand, lower forecast daily demand, a changed purchase price or a change in the products included. To find the cause, compare the dead-stock quantity and purchase price of the same products at two moments.

The ABC category label alone does not explain a high or growing dead-stock value. Dead-stock value for a category is the sum of dead-stock quantity times purchase price for the included products in that category. A high purchase price or a large dead-stock quantity can give C products a high total. The C category classifies a product by its relative contribution. It does not mean the product has no stock or no value.

Example: dead-stock value for hose reels and pruning saws

This example uses made-up numbers. You sell garden tools and check two slow sellers:

  • Hose reels: 93 units in stock on hand, forecast daily demand 0.1 units, purchase price €5 per unit
  • Pruning saws: 156 units in stock on hand, forecast daily demand 0.2 units, purchase price €8 per unit

The example values the stock at a single moment, at the active supplier's purchase price with no price adjustments. A chart averaged over several dates can differ from this single-snapshot calculation.

  1. Hose reels: threshold 0.1 × 730 = 73 units, dead-stock quantity 93 - 73 = 20 units, dead-stock value 20 × €5 = €100.
  2. Pruning saws: threshold 0.2 × 730 = 146 units, dead-stock quantity 156 - 146 = 10 units, dead-stock value 10 × €8 = €80.
  3. Total dead-stock value: €100 + €80 = €180.

The €180 is the purchase-price value of the units already classified as dead stock.

Now you hold 161 pruning saws instead of 156. Their dead-stock quantity becomes 161 - 146 = 15 units, they contribute 15 × €8 = €120, and the total dead-stock value becomes €100 + €120 = €220.

Before you decide how to handle the stock of either product, check its demand outlook and incoming orders in Optiply.

Where to find dead-stock quantity and value in Optiply

Dead-stock quantity per product is in the Dead stock column of Products, in whole units. Product exports show the same quantity. Multiplying exported Dead stock units by the prices you see may not match the Analytics figure exactly. An export can also cover a different set of products or use a different valuation. To compare an export with the Deadstock value card, check the filters, dates, rows and price basis of both.

Dead-stock value is on the Analytics Overview report, which is available when Analytics is enabled for your webshop. Open Analytics → Overview and look for the Deadstock value card. Overview Metrics (Totals) charts can also include Deadstock Value in their legends.

Analytics Overview with the Deadstock value card and Last 12 months selector. Figures are illustrative.
Analytics Overview with the Deadstock value card and Last 12 months selector. Figures are illustrative.Enlarge

Read the Deadstock value card's currency and vs Previous month label separately from the charts' date range and grouping. The Last 12 months selection in the screenshot is an example, not a required setting. The headline card and a chart do not necessarily use the same period or aggregation.

On the Deadstock value card, an upward percentage is not automatically an improvement. Read the amount and the comparison label rather than judging an arrow or colour alone.

Analytics Overview is separate from the Home page: dead stock is not one of the standard Home KPI cards.

How to review dead stock in Optiply

Review dead stock product by product. The right remedy depends on your own costs, supplier obligations and sales options, which the dead-stock metric does not include. Use these steps when a dead-stock figure needs a closer look:

  1. Identify the exact card or chart, the measure it shows and whether it is in units or currency.
  2. Check its period, grouping, filters and stock scope before you compare figures or decide what action to take.
  3. Review the stock on hand and purchase price for the affected products. Open Products, open the product and go to the Product tab. Free stock is in the Stock info section. Purchase price in the Supply chain section shows the active supplier's price (Cost price for assembled products). The Suppliers tab shows each linked supplier's price.
  4. Check the demand outlook and incoming orders before deciding how to handle the stock.
  5. Compare like-for-like measures. For simulations, keep the selected run and dates consistent.
  6. If the figure is still unclear, contact Support with the webshop, report, measure and active settings. Never send credentials or secret access links.

How dead stock differs from unsellable stock, overstock, purchasing and simulated cash

Dead stock is a measure for reviewing stock. These readings of it are common mix-ups:

  • Dead stock and stock that can never sell: A product with dead stock can still sell. Use the metric to prioritize a stock review, not to declare future sales impossible.
  • Dead stock and overstock: Overstock value compares stock on hand plus incoming stock with Order up to. Dead stock compares stock on hand with the 730-day-equivalent demand threshold. Both use purchase prices for their value. The two can overlap, so read them side by side: they do not replace each other and are not additive.
  • Dead-stock value and what the stock brings in: Dead-stock value is the purchase-price value of the units. Their sales value, a predicted loss and the cash you receive by selling them are separate amounts.
  • Dead stock and purchasing: The dead-stock figure and stock time are metrics, not purchasing switches. Purchase advice starts from Order up to minus Stock position, then applies conditions such as a manual minimum stock, MOQ and lot size. Review product and supplier purchasing settings separately: the metric alone is not an instruction to stop ordering. No sales in the last 30 days alone does not mean the forecast is zero. Today's dead-stock figure alone cannot explain an earlier purchase: check the advice and order details from that date.
  • Dead-stock value and simulated dead-stock cash: simulated dead-stock cash is a different measure from reported inventory value. Different reports can use different aggregation, periods and stock scopes, so a simulated cash figure and an inventory-value total need not match.

These articles cover the Analytics reports where dead stock appears: