Your cash is either moving or it's sitting on a shelf.
Inventory turnover ratio tells you exactly how fast your stock converts into revenue — and whether you have too much capital locked up in products that aren't selling fast enough to justify their shelf space.
Most Shopify merchants either ignore this metric entirely or calculate it once, get a number, and have no idea what to do with it. This guide fixes both problems.
What Is Inventory Turnover Ratio?
Inventory turnover ratio measures how many times you sell through and replace your entire inventory over a given period — typically a year.
Formula:
Inventory Turnover = Cost of Goods Sold ÷ Average Inventory Value
Average Inventory Value = (Beginning Inventory + Ending Inventory) ÷ 2
So if you sold £240,000 worth of goods (at cost) last year, and your average inventory value was £60,000, your inventory turnover ratio is:
240,000 ÷ 60,000 = 4.0
You turned over your entire inventory 4 times in 12 months — roughly once every 3 months.
Always use cost of goods sold, not revenue. Using revenue inflates the ratio by your gross margin percentage and makes cross-SKU comparison meaningless.
Days Inventory Outstanding (DIO): The More Useful Version
Inventory turnover ratio is easier to understand when converted to days:
Days Inventory Outstanding (DIO) = 365 ÷ Inventory Turnover
A turnover of 4.0 = DIO of 91 days. Your average unit spends 91 days in your warehouse before it sells.
A turnover of 12.0 = DIO of 30 days. Each unit sits for 30 days before selling.
DIO is more intuitive because it connects directly to cash flow: DIO tells you how long your money is locked up in stock before it comes back as revenue.
What Is a Good Inventory Turnover Ratio?
There is no universal "good" number. It depends entirely on your category:
| Category | Typical Turnover | Typical DIO |
|---|---|---|
| Fresh food / perishables | 50–200× | 2–7 days |
| Fast-moving consumer goods | 6–15× | 24–60 days |
| Apparel / fashion | 4–8× | 45–90 days |
| Home goods / furniture | 2–4× | 90–180 days |
| Jewellery / luxury goods | 1–2× | 180–365 days |
The key benchmark is your own historical ratio and your category peers. A turnover of 3.0 might be excellent for a handmade ceramics store and catastrophic for a fast-fashion brand.
Chasing a high turnover blindly can be just as damaging as a low one. An extremely high turnover can indicate you are understocked — constantly running out of your best sellers and leaving revenue on the table. Balance is the goal.
The Three Most Common Calculation Mistakes
Mistake 1: Using Revenue Instead of COGS
If your gross margin is 50% and you use revenue instead of COGS, your turnover ratio will appear twice as high as it really is. This makes your inventory performance look better than it is and makes comparison to benchmarks meaningless.
Always use cost of goods sold.
Mistake 2: Using Ending Inventory Instead of Average Inventory
If you check your inventory on December 31st and it happens to be low (post-Christmas clearance), your ratio will look artificially high. If you check it in November at peak pre-Christmas stock, it looks artificially low.
Always average your beginning and ending inventory for the period, or better yet, average monthly snapshots across the year for maximum accuracy.
Mistake 3: Calculating at Store Level Only
Store-level turnover hides SKU-level problems. Your overall ratio might be a respectable 5.0 while 30% of your SKUs are turning at 1.2 — meaning nearly a year of cash tied up per unit. The aggregate number masks the dead weight dragging down your working capital.
Calculate turnover at SKU level, not just store level.
How to Interpret Turnover by SKU
Once you have per-SKU turnover data, three categories emerge:
High Turnover SKUs (Your Stars) These are selling fast relative to the stock you hold. The risk here is stockouts — if demand spikes or a restock is delayed, you run out. Monitor reorder points carefully and consider holding slightly more safety stock.
Normal Turnover SKUs (Your Core) These are moving at a predictable, healthy rate. Your reorder logic and stock levels are well-calibrated. Maintain current approach; refine based on seasonal variation.
Low Turnover SKUs (Your Drag) These products are consuming working capital without generating proportionate revenue. DIO of 200+ days means you placed that order 6+ months ago and the money still hasn't come back. These SKUs need active intervention.
For any SKU with DIO above 180 days, ask: would you buy this product today, at the same quantity, knowing what you know now? If the honest answer is no, that inventory is a liability to be liquidated, not an asset to be protected.
Five Ways to Improve Inventory Turnover
1. Tighten Your Reorder Quantities
The simplest lever: order less per purchase order. Smaller, more frequent orders reduce average inventory value directly. Yes, you may pay slightly more per unit (losing volume discounts), but the carrying cost savings and cash flow improvement often more than compensate.
Test: Reduce your order quantity for your 5 slowest-turning SKUs by 30%. Run for 2 months. Compare turns and stockout frequency.
2. Apply ABC Analysis Before Every Buying Decision
Before any purchase order, classify your SKUs into A (top 80% of revenue), B (next 15%), and C (bottom 5%). Apply different stocking logic to each:
- Class A: Prioritise availability. Higher safety stock is justified by revenue contribution.
- Class B: Normal stocking logic. Standard reorder points.
- Class C: Minimum viable stock only. Consider discontinuing the slowest performers entirely.
3. Run Promotions on Slow-Moving Stock Proactively
If a SKU's DIO is climbing above 120 days, do not wait until it becomes dead stock at 300+ days. Run a targeted promotion — bundle it with a fast-mover, offer a 15–20% discount, or create a clearance collection — while it is still early enough that the markdown is modest.
Dead stock is always more expensive to liquidate than slow stock. Catch it early.
4. Negotiate Shorter Lead Times With Key Suppliers
Long supplier lead times force you to hold more safety stock — which increases average inventory value and suppresses turnover ratio. Reducing a supplier's lead time from 45 to 21 days can allow you to cut safety stock by 30–40% for that SKU, directly improving its DIO.
Even partial improvements compound: a 10-day lead time reduction across your top 10 suppliers can free up a meaningful amount of working capital that was previously sitting idle as buffer stock.
5. Introduce Demand-Based Forecasting
Most inventory decisions are made on intuition or simple rules: "I always order 200 units." Demand-based forecasting — using your actual sales history, seasonality patterns, and trend data — produces order quantities calibrated to what you will actually sell in the next 30, 60, or 90 days.
Better forecasting directly improves turnover by reducing both over-ordering (which inflates average inventory) and under-ordering (which creates stockouts and revenue gaps).
Tracking Turnover Over Time
A single turnover calculation is a snapshot. Its value multiplies when you track it monthly across:
- Store level: Is your overall capital efficiency improving?
- Category level: Which product types are turning well vs. dragging?
- SKU level: Which specific products need intervention?
Set a monthly reminder to run your turnover calculation. Build a simple trend line. You do not need to be improving every month — but you should be improving quarter over quarter and year over year.
If your overall DIO was 95 days last year and is 78 days this year, you have freed up roughly 17 days of COGS worth of working capital. For a store doing £500k in COGS annually, that is approximately £23,000 in freed-up cash — cash that was previously sitting in a warehouse doing nothing.
What InsightCore Shows You
InsightCore calculates inventory turnover and days inventory outstanding at both the store level and per-SKU level, updated in real time as sales come in through Shopify. The ABC analysis view shows your turnover distribution across A, B, and C classes so you can immediately see where the drag is concentrated.
Rather than running a quarterly spreadsheet exercise, you get a live view of which products are working and which are consuming working capital without justification — so you can make faster, better buying decisions.
Summary
Inventory turnover ratio is the foundational metric for working capital efficiency. High turnover means your cash cycles quickly; low turnover means it sits idle in warehouse space.
Calculate it correctly: COGS divided by average inventory value. Convert to DIO for intuitive interpretation. Track it at SKU level, not just store level. Benchmark against your own history first, category norms second.
Then act on it: tighten reorder quantities for slow movers, run proactive promotions before dead stock sets in, negotiate shorter lead times, and introduce demand-based forecasting to right-size every order you place.
The merchants with the strongest cash positions are rarely the ones with the highest revenue. They are the ones whose inventory turns the fastest.