Days inventory on hand dashboard for multichannel ecommerce stock

Days Inventory on Hand for Ecommerce Sellers

In 2026, days inventory on hand is no longer a quiet finance metric. Amazon's low-inventory-level fee uses historical days of supply and applies when both the 30-day and 90-day measures fall below 28 days for eligible products. At the same time, Shopify's enterprise inventory guidance points to stockout frequency, days on hand and order cancellations as workflow KPIs for teams trying to reduce manual inventory work.

That matters because multichannel sellers rarely have one clean stock pool. A single SKU can sit in your own warehouse, be inbound to FBA, be reserved by pending bol.com orders, be returned from Zalando, and still appear as available in a webshop feed if the integration is delayed. A blended days-on-hand number can look healthy while the channel that drives the highest margin is already close to a stockout.

28
Amazon fee threshold
Low-inventory-level fee risk starts below 28 historical days of supply.
30–60
Healthy ecommerce range
Common benchmark for many non-seasonal ecommerce categories.
7–10
Retail systems in play
Shopify cites this range as typical operational complexity.

The better question is not: how many days of stock do we own? It is: how many days of sellable stock do we have in the right place, for the right channel, before lead time and marketplace rules punish us? This article explains how ecommerce sellers should use days inventory on hand as an operating system for replenishment, allocation and cash control.

What days inventory on hand really measures

Days inventory on hand, also called DOH, DIH or days of supply, estimates how long stock will last at the current sales pace. The finance formula is simple: average inventory divided by cost of goods sold, multiplied by the number of days in the period. A unit-based operating version is even more direct: sellable units on hand divided by average daily units sold.

For a single-channel store, that may be enough. For a seller active on Amazon, bol.com, Shopify, WooCommerce and TikTok Shop, it is only the starting point. Marketplace operations introduce allocation limits, reservation timing, inbound delays, product-ranking risk and channel-specific fulfillment rules. The same SKU can have one total inventory value but five different commercial realities.

The hidden trap

A low days-on-hand number is not automatically good. If Amazon, bol.com or Shopify is selling through faster because you keep under-allocating stock, the KPI is celebrating lost availability. The useful version is calculated per SKU, per warehouse and per channel buffer.

The multichannel version of the formula

Start with the classic DOH formula for board-level reporting. Then build an operational layer underneath it. The operational layer should calculate days of supply per SKU, per stock status and per location. At minimum, split stock into sellable, reserved, inbound, returned, quarantined and unsellable. If your system cannot separate these states, your DOH will be inflated by units that cannot actually save an order.

A practical multichannel formula is: sellable units available to a channel divided by the channel's average daily units sold. Then adjust the result with supplier lead time, receiving time, marketplace replenishment cutoffs and safety stock. If a SKU sells 12 units a day on Amazon and only 60 FBA-available units remain, the Amazon DOH is 5 days even if 500 units exist elsewhere. If those 500 units are in your Dutch warehouse and take 10 days to inbound, the operating risk is immediate.

Finance-only DOH
  • Uses one blended inventory value
  • Looks healthy while one marketplace stocks out
  • Misses sellable vs reserved stock
  • Creates a monthly report after the problem
Useful for cash reporting, weak for daily marketplace control.
Operational DOHRecommended
  • Splits available, reserved, inbound and unsellable stock
  • Compares Amazon, bol.com, Shopify and warehouse velocity
  • Adds supplier lead time and channel buffer rules
  • Triggers action before rank, fee or cash damage
Best for multichannel sellers with shared stock pools.
Why 28 days became a meaningful floor

Amazon's current low-inventory-level fee documentation states that the fee applies only when historical days of supply are below 28 days in both the short-term and long-term measures. The documented fee tiers rise as the days-of-supply band gets lower, and Amazon has expanded the calculation details for 2026. Even sellers outside the US should pay attention, because this is how marketplaces increasingly think: availability is not just your problem; it affects their delivery promise and customer experience.

That does not mean every SKU should sit at 60 days. Fast-moving, reliable-supply items may run lean. Seasonal items may intentionally carry more stock before a campaign. Slow-moving accessories may need a lower ceiling because cash and shelf space are more valuable than theoretical availability. The point is to make the floor explicit, not emotional.

The most useful days-on-hand target is a band, not a number: a lower floor that protects availability and an upper ceiling that protects cash.

Set different bands by product and channel

Generic benchmarks often cite 30 to 60 days as healthy for many ecommerce categories, with shorter windows for fast-obsolescence categories like electronics and longer windows for beauty, supplements or home goods. Those ranges are useful as a sanity check, but they become dangerous when applied equally across every SKU.

ChannelDock customers typically need at least four bands. Hero SKUs need a higher availability floor because a stockout hurts ranking and repeat sales. Seasonal SKUs need a time-phased band that rises before the peak and falls aggressively after it. Long-tail SKUs need a low ceiling because the real risk is dead stock. Marketplace-only SKUs need channel-specific floors because Amazon, bol.com, Zalando, OTTO and Kaufland do not all treat replenishment, reservations and seller performance the same way.

A practical banding model
  • 0–14 days: emergency zone for fast sellers unless replenishment is already physically close.
  • 14–28 days: watch zone; useful for lean stock, risky for delayed suppliers or Amazon FBA.
  • 28–60 days: common operating range for many stable ecommerce products.
  • 60+ days: investigate demand, margin, storage cost and whether stock should move to another channel.
Turn days on hand into replenishment actions

The biggest gap in competitor guides is that they stop at the formula. Sellers do not need another explanation of COGS divided by average inventory; they need an action model that says what to do on Monday morning. Days on hand should drive purchasing, transfers, channel allocation, promotions and marketplace throttling from the same stock truth.

  1. 1
    Calculate DOH from cost, not retail price
    Use average inventory value divided by cost of goods sold, multiplied by the measurement period. For daily operations, also calculate unit-based days of supply per SKU.
  2. 2
    Separate sellable, reserved and blocked stock
    Marketplace reservations, pending orders, returns and damaged units should not inflate the quantity you believe is available to sell.
  3. 3
    Run the number per channel and warehouse
    A SKU can have 52 days of stock in total and still have 9 days available in the warehouse that feeds Amazon FBA replenishment.
  4. 4
    Layer in lead time and marketplace rules
    Compare days on hand with supplier lead time, inbound processing time, minimum order quantity and any channel-specific fee or availability threshold.
  5. 5
    Turn bands into actions
    Below floor: reorder, transfer or throttle allocation. Inside range: maintain. Above ceiling: reduce purchasing, bundle, markdown or move stock to a faster channel.

This is where a connected inventory setup matters. With ChannelDock's inventory workflows, sellers can keep stock sync, reservations, purchase advice and warehouse availability in one operational view. The integrations layer then keeps marketplace, webshop, carrier and ERP data moving without another spreadsheet becoming the source of truth.

What ranking articles miss

Most pages ranking for days inventory on hand are correct, but incomplete. They explain a finance ratio, list a few category benchmarks and suggest carrying less slow-moving stock. That is helpful for a single warehouse. It is not enough for a multichannel seller whose stock promise changes every time an order is imported, a return is approved, an inbound shipment is delayed or a marketplace feed accepts a new quantity.

The missing layer is latency. Stock does not move from supplier to sellable marketplace availability instantly. It passes through purchase approval, production, freight, customs, receiving, quality control, barcode booking, putaway, allocation and feed updates. Each step consumes days. A SKU with 35 days on hand can still be unsafe if lead time is 42 days and the next inbound has not shipped.

There is also a cash-flow layer. High days on hand may be perfectly fine before Black Friday, but expensive in February when storage costs and supplier invoices are due. Low days on hand may look efficient, but if it repeatedly causes marketplace stockouts, it is damaging revenue that never appears in the inventory report. The KPI only becomes useful when it is interpreted with stockout rate, sell-through, fill rate, purchase order cycle time and inventory carrying cost.

How ChannelDock sellers should operationalise it

Build a weekly inventory meeting around exceptions, not rows. Sort SKUs by days on hand outside their assigned band, then separate them into four queues: reorder, transfer, throttle and liquidate. Reorder is for SKUs below the floor where supplier lead time is longer than the remaining stock cover. Transfer is for stock that exists, but sits in the wrong warehouse or fulfillment program. Throttle is for products where one channel is consuming shared stock too quickly. Liquidate is for products above the ceiling with weak sell-through.

The practical goal is fewer manual corrections. If a seller exports Shopify stock, Amazon FBA stock and warehouse stock into a sheet every Friday, the decision is already late. A better setup connects live stock, orders, returns and channel buffers so that availability is adjusted before the feed oversells or a replenishment deadline passes. For teams combining marketplace selling with their own warehouse, barcode-driven pick and pack makes the same data more reliable on the warehouse floor.

What this means for multichannel sellers
  • Days inventory on hand should be a live operating signal, not a month-end finance ratio.
  • The same SKU needs different DOH bands on Amazon FBA, bol.com LVB, your webshop and your own warehouse.
  • Low DOH can mean efficiency, but it can also mean you are one delayed inbound shipment away from losing sales velocity.
  • High DOH is not always overstock before peak season, but it is dangerous when sell-through is flat and cash is tight.
FAQ
What is days inventory on hand in ecommerce?
Days inventory on hand shows how many days your current stock can support sales at the current cost or unit sell-through rate. Ecommerce teams use it to decide when to reorder, transfer, throttle or discount stock.
What is a good days inventory on hand range for online sellers?
Many ecommerce benchmarks use roughly 30 to 60 days for non-seasonal products, but the right range depends on category, supplier lead time, marketplace fee rules and demand volatility.
How is days inventory on hand different from inventory turnover?
Inventory turnover counts how many times stock is sold and replaced during a period. Days inventory on hand translates the same movement into days of cover, which is easier to use for replenishment and channel allocation decisions.
Should Amazon FBA sellers target more than 28 days of supply?
Amazon says its low-inventory-level fee applies when both short-term and long-term historical days of supply are below 28 days for eligible products. Sellers should treat 28 days as a risk floor, then add their own lead-time and cash-flow rules.
Can ChannelDock help manage days of supply across marketplaces?
Yes. ChannelDock centralises stock sync, marketplace orders, reservations and warehouse availability so sellers can manage sellable inventory across channels instead of reconciling separate exports.
Conclusion

Days inventory on hand is useful only when it reflects sellable, channel-ready stock. For multichannel sellers, the metric should not live in a finance spreadsheet once a month. It should guide daily decisions about replenishment, allocation, inbound timing and marketplace risk.

If your current process cannot explain which SKUs are below their floor, which channels are consuming shared stock too fast, and which products are tying up cash above their ceiling, the problem is not the formula. The problem is fragmented inventory control. ChannelDock helps sellers bring those signals together, keep stock synced across channels, and turn days of supply into decisions before stockouts or overstock become expensive.

Want to see how this works across your own channels? Start a free ChannelDock trial and connect your inventory, marketplace and warehouse workflows in one place.