How to Calculate the Cost of Stockouts for Your DTC Brand
Selling out can look like a sign that a product is working. But when a bestseller disappears for two weeks, the cost can show up in missed sales, emergency freight and a buying plan that understates demand again next month.
For a growing consumer brand, the useful question is how much contribution you are losing, what is causing the shortage and whether the cost of preventing it is commercially justified.
This guide explains how to estimate stockout costs, adjust sales history for availability and turn the analysis into better purchasing decisions.
All figures and charts below are illustrative worked examples, not client results or industry benchmarks.
What is a stockout?
A stockout happens when a customer cannot buy the product or variant they want because sellable inventory is unavailable. That can mean an entire product, a particular size or colour, a bundle component, or stock at the warehouse serving that customer.
You can have significant inventory overall and still lose sales. Cash sitting in slow-moving colours does not replace a missing bestseller. Likewise, stock in transit is not available to fulfil today's order.
How do you calculate the cost of a stockout?
Start with the contribution you would reasonably have earned from demand that is genuinely lost, then add incremental costs caused by the shortage.
Estimated stockout cost = lost contribution + additional recovery costs.
Estimate lost units using expected daily demand during the unavailable period. Then allow for customers who bought an alternative or returned after the restock. A substitute sale can preserve some contribution, so counting it as a fully lost sale exaggerates the impact.
Calculation | Worked example |
|---|---|
Expected daily demand × days unavailable | 20 units × 10 days = 200 potential units |
Less demand recovered through substitutes or later purchases | 200 × 25% = 50 recovered units |
Estimated net lost units | 200 − 50 = 150 units |
Net revenue at risk, excluding sales tax | 150 × $40 = $6,000 |
Contribution at risk | 150 × $16 = $2,400 |
Additional freight caused by the shortage | $450 above the normal freight cost |
Estimated economic impact | $2,400 + $450 = $2,850 |
The example assumes recovered purchases preserve the same contribution and do not displace other sales. If customers switch to a lower-margin product, include that margin difference separately.
This is an estimate of economic impact, not a line item that will necessarily appear in your accounts. The missed contribution is an opportunity cost; the extra freight is an actual additional expense.
Try your own figures: use our stockout cost calculator as a starting point for estimating the impact on your brand. Then refine the assessment using the contribution and recovered-demand adjustments explained below.
Why sales history can hide the demand you missed
Imagine a product sold 400 units in a 30-day period but was available for only 20 days. Dividing by all 30 days gives 13.3 units a day. Dividing by the 20 available days gives 20 units a day.
If you use the first number to set your next purchase, you may build the shortage into the forecast. Customers could not buy during the unavailable days, so recorded sales alone cannot tell you what they would have purchased.
Figure 1. Availability-adjusted sales rates can reveal demand hidden by stockouts. Illustrative data.
In-stock sales rate = units sold while available ÷ time genuinely available to buy.
Use this as a starting point rather than a guaranteed demand forecast. Promotions, advertising spend, seasonality and weekday mix can all change the expected rate. A product that was available only during a launch promotion should not have that peak rate extended across an ordinary month.
Shopify documents inventory fields for days in stock and days out of stock, based on each day's ending inventory. Those fields can help identify availability issues, but an end-of-day measure will not capture every intraday shortage. Check the definitions of the report you use and reconcile availability with your warehouse and sales channel records.
Use contribution, not revenue, to assess the commercial impact
In the example, the initial revenue opportunity is $8,000: 200 units at $40 each. After allowing for recovered demand, net revenue at risk is $6,000. Neither figure equals lost profit.
Here, contribution per unit is $16 after the variable costs that would have accompanied the sale. Define those costs consistently: landed product cost, payment fees, fulfilment, shipping subsidy and expected returns may all be relevant. Use actual net selling prices after discounts and exclude sales tax.
Figure 2. Revenue, contribution and additional costs measure different parts of the same event. Do not add the bars together.
Keep advertising treatment explicit. If spend continued during the stockout and could not be avoided, do not also deduct an assumed acquisition cost as though it were saved on every missed order. Record demonstrably wasted spend separately and check that it is not already counted elsewhere.
The same rule applies to freight: count the premium above the normal replenishment method, rather than adding the entire freight bill. Avoid counting future lifetime value as a certain loss; use a separate scenario if repeat purchasing is material.
Build a range instead of pretending the estimate is exact
You rarely know exactly how many people bought elsewhere, waited or chose another product. Show how the answer changes under different recovery assumptions.
Figure 3. Sensitivity analysis shows why recovered demand should be an explicit assumption.
With no recovered demand, the example costs $3,650 in lost contribution and extra freight. At 25% recovery, it costs $2,850. At 50%, it costs $2,050. The demand estimate, unit contribution and freight premium are unchanged.
Use back-in-stock conversions, substitution patterns, customer enquiries and post-restock sales to refine the assumptions. These signals overlap, so do not add each one as a separate pool of missed customers.
What data do you need to estimate lost sales?
Start at SKU level and use the same date range, channel and location throughout. A warehouse total can hide an unavailable size or inventory reserved for wholesale.
Data | What it helps establish |
|---|---|
Daily units sold, price and discounts by SKU | Normal sales velocity and net selling price |
Sellable inventory history by location and channel | When customers could actually purchase |
Returns, cancellations and backorders | Whether recorded sales convert into retained demand |
Marketing, launch and promotion calendar | Whether the comparison periods reflect similar demand |
Open orders, supplier lead times and receipt dates | Whether purchasing or delivery timing caused the gap |
Variable costs and emergency charges | Contribution at risk and the cost of recovery |
Shopify's inventory reports include sell-through and estimated days of inventory remaining. Use them alongside purchase orders and actual lead times. A historical sales-rate calculation does not, by itself, explain a future promotion or a delayed production order.
How to reduce stockouts without buying too much inventory
More stock everywhere is an expensive response. Identify the cause first, then put cash behind the products where availability has the strongest commercial value.
Correct the demand baseline. Review stockout periods before rolling historical sales into the next forecast. Adjust for seasonality and planned marketing activity.
Review the variant split. A successful product can still have the wrong size or colour mix. Analyse availability and demand below the style level.
Set purchasing triggers around real lead times. Include production, freight, customs and receiving time, with a buffer appropriate to demand and supply variability.
Check allocation before ordering more. Stock may be available in another warehouse or committed to a lower-priority channel. Account for transfer costs and service requirements.
Assign an owner to the decision. Review stock at risk, confirmed inbound dates and purchasing commitments weekly. Give each exception an action, owner and deadline.
A simple continuous-review starting point is: reorder point = expected demand during replenishment lead time + safety stock. Monitor inventory position—sellable stock plus usable confirmed inbound, less commitments—against that trigger. Time-phase inbound orders: a delivery arriving after the projected stockout cannot prevent it.
Balance the benefit of extra availability against cash tied up, storage, expiry and markdown risk. A seasonal product near the end of its selling window may not justify the same buffer as an evergreen bestseller.
When is paying for faster freight worthwhile?
Compare the extra freight cost with the contribution it can realistically protect. If faster shipping gets 100 incremental sales to customers before they would otherwise be lost, at $16 contribution each, the maximum contribution protected is $1,600.
A $450 premium may make commercial sense. But check when the shipment will become sellable, whether demand will still exist and whether the faster route introduces handling or reliability problems. An earlier port arrival does not necessarily mean earlier customer availability.
When operational support can help
If the same products keep selling out while other stock accumulates, the issue may span demand planning, supplier commitments, warehouse allocation and buying ownership. Fixing one spreadsheet will not resolve conflicting decisions across those functions.
Onflair helps consumer brands connect those decisions through supply chain reviews, practical implementation and fractional operational leadership. The aim is a buying process your team can run, with clearer priorities for availability, margin and cash.
Explore Onflair's operations services or discuss your inventory challenges.
Frequently asked questions
How do you calculate lost sales from a stockout?
Estimate demand during the unavailable period using comparable in-stock sales rates. Subtract demand recovered through substitutes or later purchases, then multiply net lost units by the net selling price. Treat the result as an estimate and test different assumptions.
Is a stockout's cost the same as lost revenue?
No. Lost revenue measures missed sales. The economic cost is better assessed using lost contribution plus incremental recovery expenses, with care to avoid double counting.
Why can I have excess inventory and stockouts at the same time?
Inventory may be concentrated in the wrong products, variants, locations or channels. Analyse sellable availability and purchasing commitments at the level where customers make their choices.
Will increasing safety stock solve the problem?
It can reduce some shortages, but it also uses cash and increases exposure to slow stock. Review forecast quality, lead-time variability, supplier reliability and allocation before increasing buffers.
Sources and methodology
The worked examples, calculations and charts are Onflair illustrations. They do not use client data. Shopify documentation supports the descriptions of its inventory reports and availability fields; it is not the source of the example assumptions.