Summary: Inventory turnover ratio measures how many times you sell through your average inventory in a period: cost of goods sold divided by average inventory at cost. For ecommerce brands, the useful version is calculated per SKU and per channel, paired with stockout rate and margin, so you raise turnover by buying smarter instead of simply holding less stock.
Most guides stop at the formula. That is the easy part. The hard part is knowing which number to trust, which SKUs are dragging the average down, and what to change in purchasing, merchandising, and marketing without creating stockouts on your best sellers. This guide covers all of it, with worked examples, a comparison of related metrics, and a weekly operating routine your team can run.
What is the inventory turnover ratio?
The inventory turnover ratio tells you how many times a business sells and replaces its inventory during a set period, usually a year or a trailing twelve months. A higher ratio means stock is converting into sales faster; a lower ratio means cash is sitting on shelves, in a 3PL, or in an Amazon fulfillment center longer than it needs to.
For an ecommerce brand, turnover is really a cash metric. Every unit you hold was paid for before it was sold, so slow turnover quietly funds storage fees, markdowns, and obsolescence instead of ads, new products, or payroll.
How do you calculate inventory turnover?
The standard formula uses cost on both sides so the ratio is not inflated by your markup:
Inventory turnover = Cost of goods sold (COGS) ÷ Average inventory at cost
Average inventory = (Beginning inventory + Ending inventory) ÷ 2
Once you have turnover, convert it into days, which is easier for most teams to act on:
Days inventory outstanding (DIO) = 365 ÷ Inventory turnover
A worked example
Here is an illustrative example (not a benchmark). A Shopify brand reports $900,000 in COGS for the trailing twelve months. It held $250,000 of inventory at cost at the start of the period and $200,000 at the end.
- Average inventory = ($250,000 + $200,000) ÷ 2 = $225,000
- Inventory turnover = $900,000 ÷ $225,000 = 4.0
- Days inventory outstanding = 365 ÷ 4.0 ≈ 91 days
In plain terms, the average unit sits for about three months before it sells. Whether that is good depends on the category, margin, lead time, and how much of that inventory is concentrated in a handful of slow SKUs.
Use more than two inventory snapshots
Two snapshots can mislead you badly in ecommerce, because inventory swings hard around Q4, product launches, and container arrivals. If you can, average twelve month-end inventory values (or 52 weekly values) instead of only the first and last day of the year. Your inventory system, ERP, or a simple monthly export into a spreadsheet is enough to do this.
Get COGS right first
Turnover is only as accurate as the COGS behind it. For imported goods, COGS should include the product cost plus freight, duties, and other inbound costs that bring the item to sellable condition. If you are not sure your unit costs are complete, start with our guide to calculating landed cost and true COGS for imported products. Using supplier price alone understates COGS and makes turnover look worse than it is.
What is a good inventory turnover ratio for ecommerce?
There is no single good number. A ratio that is healthy for a fast-moving consumable brand would be alarming for a furniture seller, and a fashion brand with seasonal drops behaves differently from a brand selling replenishable basics. Be careful with any universal benchmark you read online; most are not sourced to a specific dataset.
A more reliable way to judge your ratio is to compare it against three things you control:
- Your own history. Is turnover improving year over year for the same season?
- Your supplier lead time. If replenishment takes 60 days, holding 200 days of stock on a steady seller is hard to justify.
- Your margin structure. High-margin products can tolerate slower turns; thin-margin products cannot, because storage and capital costs eat the profit.
A quotable rule of thumb: the right turnover is the highest one you can reach without raising your stockout rate on the SKUs that drive revenue.
Inventory turnover vs. related metrics: which one should you track?
Turnover rarely tells the whole story alone. These companion metrics answer different questions:
| Metric | Formula | Question it answers | Best used for |
|---|---|---|---|
| Inventory turnover | COGS ÷ average inventory at cost | How often does stock turn over? | Company and category health |
| Days inventory outstanding (DIO) | 365 ÷ turnover | How long does a unit sit before selling? | Cash planning and reorder timing |
| Sell-through rate | Units sold ÷ units received, for a period | How much of what we bought actually sold? | Seasonal drops, launches, buy decisions |
| Weeks of supply | Units on hand ÷ average weekly units sold | How long will current stock last? | Weekly SKU-level purchasing |
| GMROI | Gross margin ÷ average inventory at cost | How much gross profit does each inventory dollar earn? | Comparing SKUs with different margins |
| Stockout rate | Days out of stock ÷ days in period, per SKU | Are we losing sales to empty shelves? | Guardrail against over-cutting stock |
If you only add one companion metric, add GMROI. Two SKUs can have the same turnover while one earns twice the gross profit per inventory dollar, and that difference should shape where you put your next purchase order.
Why company-level turnover hides the real problem
A blended ratio averages your best sellers with your worst. In most catalogs a small group of SKUs drives most of the revenue, while a long tail of variants, discontinued colors, and failed launches holds a surprising share of inventory value. The blended number looks mediocre, but the fix is not to cut everything evenly.
Calculate turnover, or weeks of supply, at the SKU level and sort the catalog into groups:
| SKU group | Typical signal | Action |
|---|---|---|
| Fast movers (A items) | High turnover, frequent stockouts | Protect with safety stock, shorten reorder cycles, never let them run out |
| Steady sellers (B items) | Moderate turnover, predictable demand | Right-size order quantities, move to smaller, more frequent POs |
| Slow movers (C items) | Low turnover, months of supply on hand | Pause reorders, bundle, reprice, or limit to fewer channels |
| Dead stock | No sales over a set window you define, such as 90 or 180 days | Liquidate, return to supplier, donate, or write off |
Clean SKU data makes this possible. If your variants, bundles, and marketplace listings do not map to one master SKU, the analysis falls apart; our guide to SKU management best practices for multi-channel sellers covers how to fix that first.
What causes low inventory turnover?
Low turnover is a symptom. The usual root causes in ecommerce are:
- Buying to minimum order quantities instead of demand. Suppliers set MOQs for their economics, not yours.
- Forecasting from gut feel or last year only. Promotions, stockouts, and channel changes distort raw history.
- Too many variants. Every extra size and color splits demand and adds safety stock.
- Long or unreliable lead times. Uncertainty pushes teams to over-order “just in case.”
- Weak demand on specific SKUs. Poor listings, thin content, or no ad support on products you already paid for.
- No owner for aged inventory. Without a weekly review, slow stock simply ages.
How can ecommerce brands improve inventory turnover?
The goal is to sell through faster or buy less of what does not sell, without starving your winners. These levers are ordered roughly from fastest impact to longest-term.
1. Clear dead and aged stock on a schedule
Set an aging rule (for example, no sales in 90 days) and decide in advance what happens at each threshold: markdown, bundle, outlet channel, liquidation, or write-off. Pre-agreed rules remove the emotional “it might still sell” debate. Clearing aged stock also frees storage space and, on Amazon, can reduce long-term storage fees.
2. Bundle slow movers with fast movers
Pairing a slow SKU with a best seller can move units without a visible discount on the hero product. Our guide to Shopify product bundles walks through bundle types and setup.
3. Forecast by SKU and set reorder points from lead time
Replace flat rules like “keep two months on hand” with reorder points built from average daily demand, lead time, and a calculated buffer. Our walkthrough on demand forecasting and safety stock for ecommerce shows the formulas. Done well, this usually raises turnover on steady sellers and lowers stockouts on fast movers at the same time.
4. Order smaller, more often
Smaller, more frequent purchase orders lower average inventory directly. The trade-off is higher per-order cost and freight, so model the total landed cost before you switch. Negotiating split shipments against a single larger commitment is often a middle path.
5. Shorten and stabilize supplier lead times
Every week of lead time and every week of lead-time variability adds stock you must hold. Track on-time delivery and lead-time consistency per supplier, and reward reliable vendors with more volume. A structured supplier scorecard for ecommerce makes those conversations data-driven.
6. Rationalize the catalog
Cut variants that consistently sit in the slow and dead groups, and set launch criteria for new SKUs: a sell-through target for the first order and a review date. Fewer, better SKUs turn faster.
7. Push demand where you already have stock
Turnover is a two-sided ratio. Improve listings, imagery, and ad allocation for overstocked SKUs that still have healthy margins, instead of spending ad budget only on items that are about to run out.
8. Balance inventory across channels and locations
Stock can be overstocked in one warehouse or channel and short in another. Review inventory by location, including Amazon FBA, your 3PL, and any retail partners, and rebalance before reordering.
Turn this into a weekly inventory review
The brands that keep turnover healthy do not run a one-time project; they run a short weekly meeting with a standard report. A practical agenda:
- Review weeks of supply for the top revenue SKUs and flag anything below lead time plus buffer.
- List SKUs that crossed an aging threshold this week and assign the pre-agreed action.
- Check open purchase orders against the latest forecast and adjust quantities or dates.
- Review stockout days from the past week and their estimated lost sales.
- Update supplier lead-time performance and note any delays.
- Agree on which overstocked SKUs get extra merchandising or ad support.
This routine takes discipline more than software. Many brands start with a spreadsheet fed by Shopify, marketplace, and 3PL exports before moving to a dedicated tool; see our roundup of Shopify inventory management tools when you are ready to automate.
Need a team to run inventory planning for you?
Improving turnover is a weekly operating job: reconciling SKU data, updating forecasts, chasing suppliers, and acting on aged stock. Many growing brands do not have the in-house bandwidth to do it consistently. AcquireX provides dedicated offshore operations specialists who run this work as part of your team. Our ecommerce supply chain management services cover demand planning, purchase order management, inventory reporting, and supplier coordination, and our procurement and sourcing team can help renegotiate MOQs and lead times.
Want a second opinion on your inventory numbers? Book a call with AcquireX and we will walk through your turnover by SKU and where the cash is tied up.
Key takeaways
- Inventory turnover equals COGS divided by average inventory at cost; convert it to days to make it actionable.
- Use complete landed COGS and more than two inventory snapshots, or the ratio will mislead you.
- Judge turnover against your own history, lead times, and margins rather than generic benchmarks.
- Calculate it per SKU; the blended number hides dead stock and starving best sellers.
- Pair turnover with GMROI and stockout rate so you raise it without losing sales.
- Run a weekly inventory review with pre-agreed actions for aged stock.
Frequently asked questions about inventory turnover
What is the inventory turnover ratio formula?
Inventory turnover equals cost of goods sold divided by average inventory, both measured at cost for the same period. Average inventory is usually beginning plus ending inventory divided by two, though averaging monthly snapshots is more accurate for seasonal ecommerce brands.
Is a higher inventory turnover always better?
No. Turnover that is too high often means you are running out of stock and losing sales. The goal is the highest turnover you can sustain while keeping stockouts low on the SKUs that drive most of your revenue.
Should I use revenue or COGS to calculate inventory turnover?
Use COGS. Inventory is recorded at cost, so dividing revenue by inventory at cost mixes retail and cost values and inflates the ratio. If you only have revenue, estimate COGS from your gross margin, but switch to actual COGS as soon as you can.
How do I convert inventory turnover into days?
Divide 365 by your annual turnover ratio. A turnover of 4 equals roughly 91 days of inventory. This figure is called days inventory outstanding or days sales of inventory.
How often should an ecommerce brand calculate inventory turnover?
Calculate company-level turnover monthly on a trailing twelve-month basis, and review SKU-level weeks of supply weekly. Weekly SKU reviews are where purchasing and clearance decisions actually get made.
What is the difference between inventory turnover and sell-through rate?
Inventory turnover measures how often average inventory value cycles over a period. Sell-through rate measures the share of units received that sold within a period. Sell-through is better for judging a specific buy or seasonal drop; turnover is better for overall inventory efficiency.
How does Amazon FBA affect inventory turnover?
Stock in Amazon fulfillment centers counts toward your inventory, and slow-moving FBA stock can trigger storage fees and capacity limits. Track FBA inventory separately by SKU, send smaller, more frequent shipments for steady sellers, and remove or liquidate aged units before fees climb.
Can outsourcing help improve inventory turnover?
Yes, when the bottleneck is consistent execution. A dedicated operations team can maintain SKU data, update forecasts, manage purchase orders, and run weekly aged-stock reviews, which is the routine work that actually moves turnover over time.
