Inventory turnover ratio is the single most important metric for understanding whether your stock is working for you or against you — but most merchants calculate it incorrectly and misread what the number means.
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.
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.
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.
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.
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.
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.
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.
Once you have per-SKU turnover data, three categories emerge:
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.
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.
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:
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.
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.
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).
A single turnover calculation is a snapshot. Its value multiplies when you track it monthly across:
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.
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.
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.
CoreCaptain detects phantom stock, sync errors, and inventory discrepancies automatically. 14-day free trial, no credit card required.
Start Free Trial