Field Notes/Operations Technical

Stockout math for e-commerce sellers

A stockout is not one cost; it is five compounding costs. Lost contribution profit on the missed unit, plus wasted ad spend during the stockout window, plus algorithmic ranking demotion, plus repeat-buyer trust erosion, plus distorted forecasting that increases the likelihood of the next stockout. A research note on the multi-line stockout cost function, the per-SKU reorder-point math that accounts for it, and the campaign-aware adjustment that survives Pay Day and 11.11.

January 18, 202612 min readBhum Soonjun · DataGlass Research

Operations

A stockout looks like an inventory problem. In marketplace commerce, it is also an advertising problem, a ranking problem, a customer experience problem, and a profit problem at the same time. When a product runs out of stock, the seller does not only lose today's order — they often lose campaign momentum, ad efficiency, future visibility, repeat buyers, and cashflow predictability all in the same week.

Basic stockout cost

The simplest accounting is the one most sellers stop at:

Lost revenue = missed units × selling price

If a seller misses 200 units at 300 THB each:
Lost revenue = 200 × 300 = 60,000 THB

But revenue is not the real loss — the seller would have spent money to produce that revenue. A more honest formula uses contribution margin:

Lost contribution profit
Lost contribution profit = missed units × contribution margin per unit

If each unit contributes 80 THB after variable costs:
Lost contribution profit = 200 × 80 = 16,000 THB

Sixteen thousand baht is closer to the real damage. And in marketplace commerce, even that number is conservative once the second-order effects are included.

Five compounding cost lines of a 7-day Shopee stockout (THB, indexed to lost contribution profit = 100)
Lost contribution profit (visible — what most accounts count)Reference baseline
100
Wasted ad spend during stockout window (~7 days)Clicks land on empty page; platform charges anyway
65
Ranking demotion impact (post-stockout 30–60 days)Algorithm penalises out-of-stock during peak windows
110
Repeat-buyer trust erosionHardest to quantify; lifetime-value loss
35
Distorted future forecasting (next-cycle reorder error)Feedback loop — stockout-period sales censored as demand drop
45
Total full stockout cost (5-line stack)~3.5× the lost-contribution-profit-only estimate
355

Each row indexed to the lost-contribution-profit-only estimate (= 100). Most account-level stockout reports stop at the top bar; the bottom bar (~3.5–5× the visible cost) is what actually accrues over the 30–60 days following the stockout. The ranking-demotion line is the largest single compounding term because Shopee's algorithm tends to remember the underperformance long after the stock is back.

The hidden costs of stockouts

The visible cost of a stockout is missed units. The hidden costs do most of the actual damage, and they compound through the rest of the operation.

Wasted ad spend

Ads do not stop the moment inventory runs low. Clicks keep landing on a product page that cannot fulfill, conversion deteriorates, and the platform charges for the traffic anyway.

Lost campaign momentum

A product that stocks out during campaign week misses the single highest-demand window of the month — and the algorithm tends to remember the underperformance long after the stock is back.

Lower buyer trust

A repeat buyer who finds an empty product page once may forgive it. Twice is a different story. Stockouts erode the kind of buyer relationship that took months of fulfillment to build.

Operational stress

Urgent reordering, supplier pressure, and manual firefighting consume time the seller did not budget for — usually at the expense of decisions on healthier SKUs.

Poor future forecasting

Stockouts distort historical sales data, which makes future demand harder to estimate accurately, which makes the next stockout more likely. The cycle is self-reinforcing.

Reorder point formula

A basic reorder rule keeps the math tractable:

Reorder point
Reorder point = expected demand during lead time + safety stock

Where:
expected demand during lead time = average daily demand × supplier lead time

Example
─────────
Average daily demand: 40 units
Supplier lead time: 10 days
Expected demand during lead time: 400 units
Safety stock: 150 units
Reorder point: 550 units

When inventory falls to 550 units, the order goes in. The catch is that "average daily demand" is doing a lot of quiet work in that formula — and on a marketplace, average is rarely a useful description of the next two weeks.

Why marketplace sellers need smarter stockout logic

Classical reorder formulas were not designed for the marketplace environment. A Shopee or TikTok Shop seller is dealing with campaign spikes, ad-driven demand, sudden viral content, competitor stockouts, live-commerce bursts, supplier delays, and cross-channel inventory pressure — sometimes all in the same month. A product can move 30 units per day in a normal week and 200 units per day during campaign week. Reorder logic that uses an unconditional average will stock out exactly when demand is most valuable, and the only way to avoid that is to make the formula campaign-aware.

Stockout risk and ad decisions

One of the most expensive mistakes a seller can make is scaling ads on a product that cannot support the additional demand. The simple version of the rule is easy to remember:

A more advanced version makes the inputs explicit and treats the decision as a function of all four together:

Ad scaling decision = margin health
                    + conversion strength
                    + inventory depth
                    + replenishment confidence

Stockout risk and pricing decisions

Inventory shapes the pricing decision more than most sellers realize. If inventory is low and demand is strong, lowering price is usually unnecessary — the right move can be to maintain price or even pull back on discounts to protect margin while supply is constrained. If inventory is high and demand is weak, a discount may make sense, but only if contribution margin survives the markdown. Pricing and inventory belong on the same screen, not on different tabs of different tools.

Stockout cost compounds over the days out-of-stock

The chart above is a snapshot — the cost ledger after a 7-day stockout. The chart below is the trajectory: how the full stockout cost accumulates as the days-out-of-stock count rises. The early days are dominated by lost-sale and wasted-ad-spend (linear with time). The later compounding terms — ranking demotion, repeat-buyer churn — kick in after roughly day 3–5 and accelerate the cost curve.

Stockout cost accumulation by days out-of-stock (indexed to day-1 lost contribution profit = 100)
07751,5502,3253,100Day 135710142130
Cumulative stockout cost (indexed)Days out-of-stock

The slope is sub-linear after ~day 14 because ranking demotion saturates and the seller-side recovery (price holds, restock-week ad pulse) starts to offset some of the trust-erosion term. The early-window slope is super-linear because lost-sale + wasted-ad-spend stack with the early-onset ranking demotion. Operationally: every additional day out-of-stock past day 5 is materially more expensive than the day before.

Sensitivity — when the stockout cost shape changes

The 5-line cost decomposition assumes typical Shopee account conditions. The table below stress-tests how the full-cost multiplier shifts under different operating contexts.

Full-stockout-cost multiplier under varying operating conditions
ScenarioMultiplier vs. lost-contribution-profitNote
Baseline (Shopee account, off-campaign)~3.5×Reference: 5-line stack, 7-day stockout
Stockout during 11.11 / 12.12 / Pay Day window~6–8×Ranking-demotion term peaks during high-traffic windows
Stockout mid-live-stream session (TikTok Shop)~5–7×Velocity-loss term is steepest; session ends with empty inventory
SKU is a top-quartile organic-traffic earner~4.5×Buyer-trust and repeat-purchase terms weigh heavier
SKU is long-tail / promotion-only~2.5×Lower compounding — ads and ranking are smaller share of total demand
Ad spend paused during stockout (manual intervention)~2.8×Wasted-ad-spend term recovered; other compounding terms unchanged
Restock secured within 48 hours~1.8×Most compounding terms do not engage

The structural conclusion: speed-to-restock is the most operationally controllable lever. A stockout caught and resolved within 48 hours costs ~50% as much as one that runs 7+ days, because the compounding terms (ranking demotion, repeat-buyer churn, forecast distortion) need time to accrue.

Suboptimal decision cost: stockout version

A stockout almost never happens because someone made an obviously wrong choice. It happens because a sequence of reasonable-looking decisions stack up. Ads were increased because ROAS looked good. A discount was applied because campaign week was coming. The reorder was delayed because cash was tight that month. The inventory report was a few days behind. The demand forecast did not account for the promotion lift the campaign would create. Each decision is individually defensible. Together, they produce an empty product page on the morning of campaign day. This is why sellers benefit from a system that catches the conflict before any individual decision tips it over the edge:

High demand + high ads + low inventory = risk

Limitations and where this argument breaks

  • Account-size lower bound. The 5-line cost decomposition assumes operating capacity to track ranking-demotion and repeat-buyer impact at the SKU level. Below ~THB 200K monthly revenue, simpler heuristics (fixed reorder cadence, conservative safety stock, no per-SKU ranking-recovery tracking) outperform the operational overhead.
  • Category dynamics. The compounding multipliers vary materially by category. Beauty and apparel (high repeat-purchase, high impulse) carry larger trust-erosion and forecast-distortion terms; consumables and homeware (utility-driven, lower repeat-rate) carry smaller compounding terms. Recalibrate the per-line ratios per category.
  • Stockout duration variance. The cumulative-cost curve in the line chart reflects modal patterns; individual SKU cost trajectories vary by 30–50% around the curve depending on ranking-position before the stockout, organic vs. ad-driven traffic mix, and supplier-recovery speed.
  • Inventory-state data quality. The framework's reorder-point math assumes inventory-state data is reasonably current (within 24h). On accounts with multi-warehouse SKUs or delayed inventory updates, the safety-stock buffer needs to be scaled up to compensate for the data-staleness gap.
  • Cross-channel inventory shared. SKUs sold across Shopee, Lazada, and TikTok Shop with shared physical inventory require canonical-catalog-level reorder logic. Per-platform reorder treats the same physical SKU as three separate inventory rows and stocks out unevenly.
  • Internal-data scope. The 3.5–5× full-cost multiplier, the 40–60% stockout-incidence reduction figure, the 8–12% recovered ad spend — all aggregated across the SEA-6 Thai marketplace seller accounts we model directly. Not population claims about all e-commerce sellers; explicitly excludes single-shop operators below the size bound.

Methodology

Public-data citations are taken from the 2025 ScienceDirect systematic review of ML approaches in inventory control, the classical newsvendor model from operations research literature for the safety-stock derivation, Shopee's Help Center documentation on listing-state under stock-zero conditions, Lazada's Open Platform stock-status API documentation, TikTok Shop Seller University on live-commerce session mechanics, and the Bain e-Conomy SEA 2025 commentary on regional demand-spike timing.

Internal-data claims — the 3.5–5× full-cost multiplier across the 5-line cost decomposition, the 40–60% annual stockout-incidence reduction figure, the 8–12% recovered ad-spend share, the modal cumulative-cost curve in the line chart — are aggregated across the SEA-6 Thai marketplace seller accounts that DataGlass models directly. The current sample is approximately 400 active accounts across the DataGlass research methodology sample frame (Jan 2024 – Apr 2026, 28-month observation window).

Take the next step

See stockout risk before it becomes lost profit.

DataGlass connects sales velocity, inventory state, ad spend, contribution margin, lead time, and campaign calendar in one model — surfacing the SKUs at stockout risk before the next demand spike, ranked by lost contribution profit.

Sources & further reading

  1. 01
    ScienceDirect — Machine learning approaches in inventory control: a systematic review (2025)

    122 reviewed papers on demand forecasting, joint optimisation, and reinforcement-learning inventory policies — the structural literature for the campaign-aware reorder-point framework in this note.

    https://www.sciencedirect.com/science/article/pii/S2214716025000430

  2. 02
    Operations Research — newsvendor model and safety-stock derivation

    Classical operations-research foundation for the stockout-cost vs. holding-cost trade-off — the math the safety-stock formula in this note ultimately derives from.

    https://en.wikipedia.org/wiki/Newsvendor_model

  3. 03
    Shopee — Ranking and stockout policy documentation

    Shopee Help Center documentation referenced for the ranking-demotion mechanism — the structural reason stockouts compound forecasting errors and lose ad efficiency.

    https://help.shopee.co.th/portal/article/77792

  4. 04
    Lazada Open Platform — listing-state and stock-status API

    Lazada's seller API documentation on listing visibility under stock-zero conditions — the platform-side mechanism that makes stockout-period ad spend structurally wasted.

    https://open.lazada.com/doc/doc.htm

  5. 05
    TikTok Shop — Live-stream session economics

    TikTok Shop documentation on live-commerce session mechanics — relevant to the stockout-mid-session scenario where the velocity loss is steepest.

    https://seller-th.tiktok.com/university/category/14

  6. 06
    Google, Temasek & Bain — e-Conomy SEA 2025

    Macro context for the campaign-day demand spikes and live-commerce bursts SEA sellers have to plan reorder cadence around.

    https://www.temasek.com.sg/en/news-and-resources/news-room/news/2025/e-conomy-sea-2025-report-aseans-digital-economy-poised-to-surpass-300-billion

More from the archive

  1. February 4, 2026

    ML demand forecasting for e-commerce sellers

    Machine learning in e-commerce gets discussed in vague terms; for marketplace sellers the operating question is concrete — how many units of this SKU will sell in the next N days, with what confidence, and what decision flows from the answer? A research note on the practical model architecture, the stockout-distortion problem, sensitivity analysis, and the operating decisions forecasts feed.

  2. April 8, 2026

    How to reduce Shopee ad waste without killing sales

    On a typical Shopee account, 20–30% of ad spend runs at a structural loss the platform dashboard ranks as winning campaigns. Pausing "underperformers" misses the leak. A research note on the two structural defaults that cause hidden ad waste — and the audit that surfaces it without losing revenue.

  3. January 4, 2026

    Dynamic pricing for marketplace sellers

    Discounting is easy. Profitable pricing is hard. A 30% volume lift on a 10% price cut routinely lowers total contribution profit — the math says volume must lift by ~33% just to break even, and most SKUs underperform that bar. A research note on the price-elasticity arithmetic, the inventory × demand four-quadrant framework, and the per-SKU pricing decision that survives campaign-window pressure.

  4. December 12, 2025

    E-commerce Decision Engine: How Marketplace Sellers Turn Data Into Profit Recommendations

    A dashboard tells you what happened. A decision engine tells you what to do next, ranks the options by projected profit lift, and surfaces the math behind every recommendation. A research note on the five-layer architecture that separates the two, why marketplace commerce now requires the latter, and where the operating model breaks.

  5. March 12, 2026

    How to find low-margin SKUs on Shopee

    On a typical Shopee account, the top-10 SKUs by revenue and the top-10 by contribution profit overlap by roughly 50%. Half of every shop's bestsellers are not the most profitable products. A research note on the audit that surfaces the gap, the patterns hiding inside it, and the per-SKU operating decisions that recover margin.

  6. January 25, 2026

    Complexity is the new tax on small sellers

    A multi-shop seller in 2026 logs into seven platforms, reconciles four fee schedules, exports six CSVs, and re-enters COGS by hand. Big brands absorb the cost with a data team. Small sellers absorb it with their evenings — and it's the single biggest reason multi-shop operators stall before they reach scale.

Stop guessing. Start deploying.

Join the sellers using DataGlass to turn shop data into the next profit-maximizing action.