Inventory turnover ratio for ecommerce brands: formula, benchmarks and how to raise it

Measure how fast your stock sells with the inventory turnover ratio: cost of goods sold (COGS) divided by average inventory, both at cost. Then run the same formula per SKU, because a healthy store-wide number can hide the dead stock that ties up your working capital.
Most brands check turnover once a year, if at all. By then, slow SKUs have sat in bins for months.
This guide gives you a calculator to copy into a spreadsheet and an official US retail benchmark to compare against. It ends with a routine to find and clear dead stock.
What is the inventory turnover ratio?
The inventory turnover ratio is the number of times a business sells and replaces its average stock in a period, usually a year. A ratio of 4 means the average inventory sold through four times.
Pair the ratio with days sales of inventory (DSI), which converts turns into days: 365 divided by turnover. Four turns a year equals about 91 days of stock on hand.
Turnover matters for cash flow because every unit on the shelf is cash you already paid a supplier. Slow turnover means that cash waits longer before it comes back as a sale. Faster turnover frees cash for reorders on products that sell or for a new channel.
How do you calculate inventory turnover?
Inventory turnover is calculated by dividing COGS by average inventory, with both values at cost and for the same period.
The inventory turnover formula, step by step
The inventory turnover formula takes four inputs and gives two outputs: turns per period and days of stock. The table uses an example brand with $1,200,000 in annual COGS. All figures are examples, not Prim.io customer data.
| Input | Formula | Example result |
|---|---|---|
| COGS for the year | Taken from your profit and loss statement | $1,200,000 (example) |
| Beginning inventory | Stock value at cost on the first day | $260,000 (example) |
| Ending inventory | Stock value at cost on the last day | $340,000 (example) |
| Average inventory | (Beginning + ending) / 2 | $300,000 (example) |
| Inventory turnover | COGS / average inventory | 4.0 turns (example) |
| Days sales of inventory | 365 / inventory turnover | 91 days (example) |
To build the calculator, put COGS in cell B1, beginning inventory in B2 and ending inventory in B3. Enter =B1/((B2+B3)/2) in B4 for turnover and =365/B4 in B5 for days of stock.
If your stock swings with the seasons, average 13 month-end values instead of two.
Why the store-wide number lies: run it per SKU
A store-wide inventory turnover ratio blends fast and dead SKUs into one number, so a healthy result can hide products that barely sell. Running the formula per SKU shows where the cash actually sits.
Take the same example brand and split its COGS and average inventory across three SKUs.
| SKU (example) | Annual COGS | Average inventory | Turnover | Days of stock | Share of average inventory |
|---|---|---|---|---|---|
| SKU A | $600,000 | $60,000 | 10.0 | 37 | 20% |
| SKU B | $450,000 | $90,000 | 5.0 | 73 | 30% |
| SKU C | $150,000 | $150,000 | 1.0 | 365 | 50% |
| Blended total | $1,200,000 | $300,000 | 4.0 | 91 | 100% |
The blended 4.0 looks fine. SKU C holds 50% of average inventory but produces only 12.5% of COGS. That is $150,000 of working capital with a full year of stock on hand.
High total sales volume hides the problem. Revenue keeps growing because SKU A sells, so nobody checks SKU C until a stock count or a cash crunch forces the question. Tracking revenue without per-product turnover also hides the purchasing habit behind it, such as reordering SKU C on the same schedule as SKU A.
Common mistakes when calculating inventory turnover
Inventory turnover mistakes usually come from mismatched inputs, and four of them show up most often.
- Using revenue instead of COGS in the numerator inflates turns, because revenue includes your margin.
- Using a single inventory snapshot instead of an average skews the result toward that one day.
- Comparing one quarter of COGS with an annual target, without annualizing, makes turnover look about four times slower.
- Pulling stock from separate tools for each channel or warehouse leads to double-counted or missing units.
The last mistake is the hardest to fix in a spreadsheet. A Shopify or WooCommerce store, a marketplace and a 3PL may each report stock separately. Someone then merges them by hand. One system for multichannel inventory management removes that step.
What is a good inventory turnover for ecommerce?
A good inventory turnover for ecommerce has no universal number, so compare your ratio with your product category and your own trend over time.
According to US Census Bureau data published by FRED, the US retail inventories-to-sales ratio was 1.36 in August 2026, seasonally adjusted. FRED notes that these ratios indicate months of inventory on hand relative to a month's sales.
So the average US retailer held about 1.4 months of stock, measured at sales value. Dividing 12 by 1.36 gives about 8.8 turns a year. That 8.8 is derived arithmetic and sales-based, so it runs higher than a COGS-based ratio like the one in the calculator above.
For your own category, the US Census Bureau publishes ratios by kind of business. Pick the line closest to your products and track it next to your own number each quarter.
The thresholds below are working rules for triage, so adjust them to your category before acting on them.
| Turns per year (working rule) | Days of cover | What to check |
|---|---|---|
| Under 2 | Over 183 | Dead stock candidate; stop reorders and plan a clearance |
| 2 to 4 | 91 to 183 | Slow mover; cut order quantities |
| 4 to 8 | 46 to 91 | Usually healthy; watch the trend each quarter |
| Over 8 | Under 46 | Fast mover; check for stockouts and lost sales |
How do you identify and clear dead stock?
Dead stock is easiest to identify by flagging SKUs that turn under 2 times a year or have not sold in a set window. Then rank them by cash tied up.
- Rank every SKU by average inventory value, highest first.
- Set a cut-off, such as under 2 turns or no sale in 90 days, and flag every SKU below it.
- Stop automatic reorders on flagged SKUs.
- Clear the stock with bundles, targeted promotions, or a wholesale or outlet channel.
- Fix the purchasing habit that created the dead stock.
In the example, SKU C goes first. Bundling it with SKU A puts slow stock next to a product that already sells. In Prim.io, a bundle can be set up as a kit that sells as one item, with stock calculated from its components. A promotion aimed at past SKU C buyers also avoids discounting SKU A, which sells at full price.
The last step matters most. Dead stock usually starts as a purchase order, so check reorder quantities against turnover before the next buy. Reliable live perpetual inventory counts also keep the average inventory input accurate.
How does business intelligence improve inventory control?
Business intelligence improves inventory control by recalculating turnover per SKU, channel and warehouse from the same records. Dead stock then shows up before the quarter closes.
In a spreadsheet, the SKU table above is a monthly project. Someone exports sales from each channel, stock from each warehouse and costs from accounting, then hopes the SKU codes match.
A BI layer connected to the ERP reads orders, stock and purchase costs directly. You can filter turnover by channel to see whether a SKU sells on a marketplace but sits in your webshop. Read more on ERP inventory management across warehouses.
How Prim.io handles inventory turnover
Prim.io handles inventory turnover with an AI assistant and BI powered by Qlik, both working from the same sales, stock and finance records. Prim.io is a cloud ERP with built-in AI for ecommerce and multi-channel brands, running orders, stock, finance, CRM, production and BI in one system.
The AI assistant answers from the company's own sales, stock and finance data. Ask which SKUs turned under 2 times last year, and the answer comes from your records, without an export. The assistant also reads invoices and matches payments, which keeps the cost side of the ledger up to date.
As an all-in-one ERP, BI and CRM built for ecommerce, Prim.io tracks inventory with bins, batches, serial numbers, expiry dates and barcodes. Purchasing with landed cost gives the formula an accurate cost basis. Built-in stock reports show average stock and turnover per SKU (in units) for any period, by warehouse or shop, and list items with stock but no sales in the period, so a product like SKU C stands out. BI powered by Qlik for sales and finance dashboards, plus built-in stock and margin reports.
See how the Prim.io cloud ERP connects these modules.
Free demo account, no credit card needed, cancel anytime.
Why ecommerce brands choose Prim.io
Ecommerce brands choose Prim.io to get stock, sales and purchasing data into one system, with a known go-live timeline and published costs.
- Prim.io processes 3.1M+ orders monthly for the brands that run on it.
- Prim.io offers 50+ native integrations for stores, marketplaces, couriers and finance tools.
- Store, marketplace and courier connectors are priced per connector (€20 to €50 per month); finance connectors are free.
- Go-live takes about 6 weeks on average, 5 to 8 weeks depending on complexity.
- Prim.io lists its published pricing online. Plans from €180 per month, billed annually, excluding VAT.
Comparing systems? Use this inventory software buying checklist before you book demos.
Inventory turnover ratio FAQ
What is the inventory turnover ratio formula?
The inventory turnover ratio formula is COGS divided by average inventory, with both measured at cost over the same period. Average inventory is beginning plus ending inventory, divided by 2. The example earlier in this guide gives 4.0 turns a year, or about 91 days of stock on hand.
How do I find inventory turnover?
You find inventory turnover by pulling annual COGS from your profit and loss statement. Then take stock values at cost from the start and end of the year. Average the two stock values, then divide COGS by that average. Repeat the calculation per SKU, because the per-SKU view is what exposes dead stock.
What is a good inventory turnover ratio for ecommerce?
A good inventory turnover ratio for ecommerce depends on your category and your own trend, so no single target fits every brand. As an official reference, the US retail inventories-to-sales ratio of 1.36 in August 2026 works out to about 8.8 sales-based turns a year. COGS-based ratios run lower.
Why is inventory turnover important for cash flow?
Inventory turnover is important for cash flow because stock is cash already paid to suppliers. Low turnover keeps that cash on shelves longer, leaving less for reorders on products that sell. In the SKU example, SKU C ties up half of average inventory at just 1.0 turns a year.
Can Prim.io track dead stock?
Yes, Prim.io can track dead stock by pairing inventory records with BI powered by Qlik, so turnover shows per SKU. The AI assistant answers from the company's own sales, stock and finance data, so you can ask which SKUs turned under 2 times. Inventory covers bins, batches, serial numbers and expiry dates.
Inventory turnover checklist
An inventory turnover checklist keeps the routine short enough to run every quarter. Start with these four steps.
- Calculate COGS divided by average inventory, store-wide and per SKU.
- Compare the result with your category benchmark and your own trend.
- Identify slow movers and clear them with targeted promotions.
- Integrate sales channels and purchasing so the inputs stay current.
Free demo account, no credit card needed, cancel anytime.
Table of content
Table of content
Meet an expert
Prefer to talk? Call our team directly.
Ready to see it for yourself?
The best way to understand Prim.io is to try it. Start with a free demo account and explore at your own pace.

