Ecommerce Inventory Turnover Ratio: Calculate It by SKU

Thierry

November 14, 2026

A laptop and packages sit beside full and nearly empty product bins.

Calculate the inventory turnover ratio for each SKU by dividing its cost of goods sold by its average inventory value over the same period. This shows how often that product’s average stock investment cycles through sales.

A store-wide average can hide excess stock in one size while another repeatedly sells out. SKU-level analysis makes those differences visible, but availability and margin determine what action makes sense.

Start with consistent cost records, then convert each result into days in inventory.

Key Takeaways

  • Match COGS and inventory value to the same SKU, reporting period, currency, and costing method.
  • Average regular inventory snapshots when seasonal buying makes opening and closing balances unrepresentative.
  • Use turnover alongside stockouts, margin, and supplier lead times before changing orders or removing products.

Gather Consistent Data for Each SKU

Match costs to the product

Company-level COGS comes from the income statement. However, SKU analysis needs the supporting product-cost records behind that total.

Export each SKU’s COGS, beginning inventory value, ending inventory value, and dated inventory snapshots. Use your accounting system, inventory platform, or reconciled spreadsheet.

Both sides of the calculation must use inventory at cost, not retail selling prices. Apply the same costing method throughout, and handle returns consistently in COGS and stock records.

Before interpreting results, reconcile physical and recorded inventory. Missing receipts, duplicate transactions, and incorrect variant assignments distort the denominator.

Choose a comparable reporting window

Trailing 12 months works well for established products because it includes a full seasonal cycle. Shorter windows help with launches and replenishment reviews, but compare equivalent selling stages.

For seasonal stock, average regularly spaced balances, such as monthly closing values. BDC’s average inventory guidance supports averaging balances across multiple periods.

Separate SKU-location records when inventory can’t move quickly enough between warehouses to serve demand. Also record launch dates, promotions, and unavailable periods, because those conditions affect comparisons.

Calculate the Inventory Turnover Ratio by SKU

Apply the cost-based formula

The standard inventory turnover formula is:

Inventory turnover ratio = COGS / Average inventory value

For relatively stable stock:

Mean stock value = (Beginning inventory + Ending inventory) / 2

Repeat the calculation for every SKU. In Excel or Google Sheets, keep one row per SKU and columns for period, COGS, mean stock value, turnover, and days in inventory.

A business with $500,000 in annual COGS and a mean stock value of $125,000 has four turns. Its average inventory investment sold and was replaced four times during the year.

Work through a SKU calculation

For a SKU with annual COGS of $245,000, opening inventory of $30,000, and closing inventory of $35,000:

Mean stock value = ($30,000 + $35,000) / 2 = $32,500

Annual turnover = $245,000 / $32,500 = 7.5385 turns

That rounds to 7.54 turns. Keep the unrounded result for subsequent calculations.

If the mean stock value is zero, leave turnover undefined and investigate the records. Also calculate category turnover using total category COGS divided by total mean stock value. Don’t simply average individual SKU ratios, because that gives small and large inventory investments equal weight.

Convert Turnover Into Days in Inventory

For an annual calculation:

Days inventory outstanding = 365 / Inventory turnover ratio

This is also called days sales of inventory (DSI) or days in inventory. Converting turnover into inventory days makes the result easier to discuss with buyers and finance teams.

The four-turn example equals 91.25 days. Using full precision, the SKU example equals 48.42 days.

For a shorter period, replace 365 with that period’s actual day count. Don’t divide 365 by an unannualized quarterly ratio.

These are historical average inventory days, not a forecast of how long today’s stock will last. For forward-looking stock cover, divide current sellable units by forecast daily unit demand.

Interpret Differences Between Products

High turnover needs an availability check

High turnover can indicate strong demand and efficient purchasing. However, a small inventory balance can also produce a high ratio while shoppers encounter stockouts.

Review unavailable periods, oversell cancellations, and incoming delivery dates before reducing buffers. Sales history understates demand when customers couldn’t buy.

Compare similar variants as well. A popular size may need deeper replenishment even when its parent product looks adequately stocked.

A SKU’s turnover can rise because average inventory fell, even when sales didn’t improve. Read the numerator and denominator separately.

Low turnover needs a commercial diagnosis

Low turnover can indicate overstocking, slow-moving inventory, weak demand, or obsolete inventory. It can also reflect a deliberate pre-season purchase or protection against unreliable supply.

Before discounting, examine product-page visibility, conversion, pricing, and return rates. Weak exposure doesn’t establish weak customer demand.

Use SKU sell-through and stock cover alongside turnover. Sell-through measures how much of a defined inventory pool sold, while turnover measures sales activity relative to average inventory investment.

For supporting accessories, also consider whether the product helps customers complete higher-margin purchases.

Treat Industry Benchmarks as Directional

Published benchmarks conflict, so use them as context rather than automatic purchasing targets.

These commonly cited ranges illustrate that variation.

Product group or channelReported annual turns
Grocery and FMCGAbout 12 to 15
ApparelAbout 4 to 6
Consumer electronics6 to 8, or 8 to 15
PharmaceuticalsRoughly 2 to 4
Ecommerce, broadly definedRoughly 2 to 4
Automotive partsAbout 15 to 20 in one estimate

The wide electronics range shows why a benchmark needs comparable products and inventory definitions. Ecommerce is also a sales channel, not a single product category.

Food and perishables generally need fewer days in inventory because expiry limits their selling window. Slower-moving, non-perishable goods can support longer holding periods.

Your strongest comparison is often the same SKU at the same seasonal stage, followed by products with similar margins, replenishment constraints, and commercial roles.

Set Targets Around Supply Needs and Margin

Translate supply requirements into target turns

A practical coverage-based starting point is:

Target days of supply = Lead time + Review period + Safety stock days

Then:

Target turns = 365 / Target days of supply

Treat this as a planning proxy, not an exact accounting forecast. Order cycles and delivery timing change average inventory.

Set inputs separately for each SKU. Dependable core products may justify more protection than limited seasonal items with high leftover risk.

Also match time units. Daily demand requires lead times and buffers expressed in days.

Pair speed with inventory profitability

Gross Margin Return on Inventory Investment measures the gross profit generated by inventory investment:

GMROI = Gross margin dollars / Average inventory at cost

An annual result above 1 is a common starting rule of thumb. It means gross margin exceeded average inventory investment, but it doesn’t prove net profitability after operating expenses.

Our GMROI calculator for ecommerce inventory helps evaluate that relationship alongside turnover.

Holding costs add another reason to investigate excess stock. ShipBob’s holding-cost guide cites a broad estimate of 20% to 30% of total inventory cost. Use your actual storage, capital, and inventory-risk expenses for purchasing decisions.

Turn SKU Results Into Purchasing Decisions

Turnover identifies products worth investigating. The next decision depends on forecast demand, availability, and remaining selling time.

  1. Use SKU-level sales history and seasonality for demand forecasting. Flag stockout periods rather than treating every zero-sale day as zero demand. Inventory management can start in Excel or Google Sheets. Move to inventory management software when update frequency or catalog complexity exceeds spreadsheet capacity.
  2. Reduce oversized purchases where demand doesn’t justify them. Smaller, more frequent orders can improve turnover and cash flow, although freight charges and supplier minimums may offset the benefit. Use just-in-time ordering only where replenishment is dependable.
  3. Negotiate shorter, more reliable lead times or staged deliveries. Then update reorder inputs after sustained supplier changes. Compare inventory position with the reorder point, including incoming stock and unfulfilled commitments without double-counting either.
  4. Address weak visibility before applying markdowns. Improve collection placement, clarify product information, or transfer stock toward demand where practical. Discount slow movers when the expected cash recovery outweighs continued holding and margin risk.
  5. Reduce future depth in persistently weak variants. Our approach to seasonal assortment planning connects buying depth with product roles and replenishment deadlines. Stop automatic orders when another delivery would arrive too late to sell.

Review active replenishment SKUs weekly, with daily exception monitoring during fast campaigns. Slower, low-volume products need longer comparison windows. Record the decision and its reason so the next review distinguishes genuine demand changes from promotions or markdowns.

Frequently Asked Questions

What does an inventory turn of 1.5 mean?

An annual turnover of 1.5 means COGS equals 1.5 times average inventory value. That translates to about 243.3 days in inventory.

Whether it warrants action depends on the product’s selling cycle, margin, supply risk, and planned inventory role.

Is an inventory turnover ratio of 12 good?

Twelve annual turns equals about 30.4 days in inventory. That may suit a fast-moving product with dependable replenishment.

However, the number alone doesn’t establish healthy performance. Frequent stockouts can accompany high turnover, while discounts may accelerate movement at the expense of margin.

Make Every SKU Review Lead to a Decision

The most useful inventory turnover ratio connects consistent cost records with a specific product decision. Calculate it by SKU, preserve comparable reporting windows, and translate the result into inventory days.

Then use availability, margin, and supply constraints to decide whether to replenish, improve visibility, reduce buying depth, or clear stock. Faster turnover is useful when it supports profitable sales without leaving customers unable to buy.

Spread the love

Leave a Comment