Inventory turnover

On this page 7

Inventory turnover is the ratio that shows how many times a business sells and replaces its average inventory during a given period, usually a year. In e-commerce inventory management, it is a core indicator of how efficiently capital tied up in stock is converted into sales, and it directly affects cash flow, storage costs and the risk of dead stock.

A higher turnover generally means stock moves quickly and less money sits on shelves. A turnover that is too high, however, can signal frequent stockouts and lost sales, so the metric is always interpreted together with service levels, margins and the product category.

How inventory turnover is calculated

The standard formula divides cost of goods sold (COGS) for the period by the average inventory value at cost. Using cost on both sides keeps the ratio consistent, because inventory is recorded at purchase cost while sales revenue includes the margin.

Average inventory is commonly calculated as opening plus closing inventory divided by two. For seasonal businesses, an average of monthly or weekly balances gives a far more accurate figure, because a single year-end snapshot may capture an unusually low or high stock level.

MeasureFormulaInterpretation
Inventory turnover (cost basis)COGS ÷ average inventory at costNumber of stock cycles per period
Inventory turnover (units)Units sold ÷ average units on handUseful per SKU when costs vary
Days inventory outstanding365 ÷ inventory turnoverAverage days stock is held
Sell-through rateUnits sold ÷ units receivedShare of a delivery sold in a period
GMROIGross margin ÷ average inventory at costMargin earned per unit of stock investment
Inventory turnover formulas and related measures

For example, a store with annual COGS of 600,000 and average inventory of 100,000 at cost has a turnover of 6. Its days inventory outstanding is about 61 days, meaning an average item waits roughly two months before being sold.

Some reports divide revenue by inventory instead of COGS. That version inflates the ratio by the margin and should not be compared with cost-based figures from other sources.

What a good turnover looks like

There is no universal target value. Healthy turnover depends on product perishability, margin, replenishment lead time and the business model. Fast-moving consumables naturally cycle many times a year, while specialty or high-value goods turn slowly.

Product typeTypical turnover patternReason
Groceries and perishablesVery high, often dozens of cyclesShort shelf life, frequent replenishment
Beauty and household consumablesHighRepeat purchases, steady demand
Fashion and apparelModerateSeasonal collections, size curves
Consumer electronicsModerate to highRapid model obsolescence
Furniture and jewelryLowHigh value, slow and irregular demand
Indicative turnover patterns by product type

The most meaningful benchmark is usually the business’s own trend over time and comparison across its own categories. A ratio that declines quarter after quarter is an early warning of overbuying or weakening demand.

Turnover summarizes speed, but it does not show whether stock is sufficient or profitable. Inventory teams therefore read it alongside several neighboring metrics.

MetricQuestion it answersRelationship to turnover
Stockout rateHow often is an item unavailable?Very high turnover can raise stockouts
Safety stockHow much buffer protects against variability?More buffer lowers turnover
Dead stock shareHow much stock has stopped selling?Dead stock drags turnover down
Fill rateWhat share of demand is met from stock?Balances turnover against service
Carrying costWhat does holding stock cost?Low turnover increases carrying cost
How turnover relates to other inventory measures

The key trade-off is between capital efficiency and availability. Raising turnover by cutting stock helps cash flow, but if fill rate falls, lost sales and frustrated customers can outweigh the savings.

How e-commerce businesses improve turnover

Improving turnover means aligning purchases more closely with actual demand. The most effective measures work on forecasting, replenishment and assortment rather than on discounts alone.

  • Analyze turnover per SKU: a healthy store-wide average can hide many slow items behind a few bestsellers.
  • Use ABC classification: give fast-moving A items frequent replenishment and review C items for removal.
  • Improve demand forecasting: base orders on sales velocity, seasonality and promotions.
  • Shorten lead times: smaller, more frequent orders reduce average stock.
  • Clear slow stock early: bundles and targeted promotions recover cash before items become dead stock.
  • Consider dropshipping or just-in-time supply: for long-tail items, avoid holding inventory at all.

Accurate data matters as much as tactics. Cycle counting and synchronized stock levels across channels prevent phantom inventory that makes turnover look worse or better than reality.

Pitfalls in measuring and managing turnover

Turnover is easy to compute and easy to misread. Most errors come from inconsistent inputs or from optimizing the ratio for its own sake.

  • Mixing revenue and cost: dividing sales at retail by inventory at cost overstates performance.
  • Ignoring seasonality: year-end averages distort results for businesses with peak seasons.
  • Chasing a high number: aggressive stock reduction can cause stockouts and lost marketplace ranking.
  • Excluding stock at third parties: inventory held at a 3PL or marketplace warehouse still counts.
  • Comparing across categories blindly: a low ratio may be normal for high-margin, slow-moving goods.

The ratio becomes most useful when paired with margin. A slow-turning product with a high margin may produce more profit per unit of capital than a fast-turning, low-margin one, which is exactly what GMROI captures.

The simple explanation

Inventory turnover tells how quickly a shop sells what it buys. A turnover of 4 means the shop sells through its typical stock about four times a year.

Think of a bakery and a furniture store. The bakery sells its bread every day, so its turnover is very high. The furniture store keeps sofas for months, so its turnover is low. Neither is wrong in itself. The useful question is whether stock moves as fast as it should for that kind of product.

How it is used in practice

An online pet supply store reviews its annual figures and finds an overall inventory turnover of 5. Looking per category, dog food turns about 12 times a year, while aquarium equipment turns barely twice and ties up a third of the stock value.

The team reduces the aquarium range from 180 to 70 products, switches rarely ordered items to supplier dropshipping and moves dog food to weekly replenishment based on sales velocity. Within a year, overall turnover rises to about 7, freeing cash for marketing and cutting warehouse space costs, while stockouts of top-selling items remain rare because their safety stock was kept unchanged.