Inventory KPIs Every Shopify Merchant Should Track (and Which to Ignore)

Most Shopify merchants track too many inventory numbers and act on too few. The metrics that matter are the ones that change a decision: when to reorder, how much to buy, and which SKUs to cut loose. Everything else is noise that fills dashboards without improving outcomes.

Key Takeaways

• Four KPIs do 90% of the work: inventory turnover, days on hand, sell-through rate, and stockout rate.
• Carrying cost runs 20-30% of inventory value per year, making dead stock far more expensive than most merchants realize.
• Benchmarks are category-specific: fashion turns 4-7x annually, supplements 8-12x, electronics 4-6x.
• GMROI (gross margin return on inventory investment) is the single best metric for deciding where to put your next buying dollar.
• Metrics like SKU count growth and "inventory accuracy" are useful for operations teams but rarely drive a reorder decision.

The Four KPIs That Actually Drive Decisions

Start here. If you track nothing else, these four give you a complete picture of inventory health.

1. Inventory Turnover Ratio

Formula: Cost of Goods Sold / Average Inventory Value.

This tells you how many times you sold through your entire stock in a given period. A ratio of 5.0 means you cycled through your inventory five times in a year, or roughly every 73 days. According to 2026 benchmark data synthesized from SEC 10-K filings and industry reports, target ranges vary significantly by vertical: fashion runs 4-7x, beauty 4-9x, supplements 8-12x, food and beverage 12-15x, and electronics 4-6x. Benchmark against your own category, not a blended average.

The US Census Bureau's Manufacturing and Trade Inventories and Sales report (released August 14, 2026) puts the retail trade inventory-to-sales ratio at 1.25 for June 2026, roughly 9.6 sales-basis turns per year for the sector overall. That macro signal is worth tracking: it dropped from 1.30 a year earlier, meaning retailers as a whole are holding leaner stock going into late 2026.

2. Days on Hand (DOH)

Formula: 365 / Inventory Turnover Ratio (or: Average Inventory / Daily COGS).

DOH answers the question your supplier lead time actually cares about: how many days until you run out? A SKU with 12 days on hand and a 14-day supplier lead time is already late to reorder. This metric is more operational than turnover because it is SKU-level and forward-looking. Pull it weekly at minimum, daily for your top 20% by revenue.

3. Sell-Through Rate

Formula: Units Sold / (Units Sold + Units Remaining) x 100.

Sell-through rate is turnover's faster, more granular sibling. It works on a fixed time window (30, 60, or 90 days) and is particularly useful for seasonal items or new product launches where you need to judge velocity before you have a full year of data. A sell-through rate below 40% at 60 days is a reliable early signal of a dead-stock problem forming.

4. Stockout Rate

Formula: (Number of SKUs that hit zero stock / Total active SKUs) x 100, measured over a rolling 30-day window.

This is the bluntest instrument in the set, but also the most unforgiving. Every percentage point here represents real lost revenue. Carry this metric into your weekly ops review and treat any best-seller that hits zero as an incident, not just a data point.

The One Advanced KPI Worth Adding: GMROI

Once you have the four basics humming, add Gross Margin Return on Inventory Investment (GMROI).

Formula: Gross Profit / Average Inventory Cost.

GMROI tells you how many dollars of gross profit you generate for every dollar of inventory you hold. A GMROI of 2.0 means every $1 of stock produces $2 of gross profit. It is the single best metric for comparing categories or suppliers against each other, because it accounts for both margin and velocity. A high-turnover SKU with a thin margin can score worse than a slower-moving, high-margin SKU.

Use GMROI during buying reviews to answer: "Should I buy more of Category A or Category B?" The answer is rarely the same as top-line revenue would suggest. For a deeper look at how to apply ABC logic to this kind of prioritization, see our guide to ABC analysis for Shopify SKU prioritization.

KPI Comparison: Track vs. Skip

The KPIs Most Merchants Track That Do Not Help

This list is shorter than you expect.

• Total inventory value in isolation. A number with no denominator is meaningless. Inventory value only matters relative to your sales velocity (turnover) or your gross margin (GMROI).
• SKU count. Growing SKU count signals expansion, not health. Many stores damage their turnover ratio by adding SKUs without retiring slow movers.
• Average inventory accuracy percentage. This is a warehouse ops metric. Unless you are running a 3PL or have a fulfilment team doing daily cycle counts, it is not a reorder metric.
• Reorder point without safety stock. A reorder point calculated on average lead time alone ignores demand variability, the component that actually causes late-cycle stockouts. For the full treatment of this, see our post on lead time and demand variability.

The Real Cost of Getting This Wrong: Carrying Costs vs. Stockout Costs

Here is the math most merchants have never run.

Inventory carrying cost runs 20-30% of inventory value per year, covering storage, insurance, capital cost, and obsolescence risk. That means $50,000 of slow-moving stock costs you $10,000 to $15,000 per year just to exist in your warehouse.

On the other side: a single stockout on a best-seller generating $500 per day in revenue, with a 10-day reorder cycle gap, is $5,000 in direct lost sales. It also risks losing the customer permanently. A 2026 IHL Group report cited $1.73 trillion in global inventory distortion costs from a combination of stockouts and overstock, both problems trace back to the same root cause: decisions made without the right KPIs.

The goal is not to minimize inventory. It is to find the level where carrying costs and stockout costs balance, and then use DOH and sell-through rate as the early-warning system that keeps you in that zone.

How to Put This Into Practice on Shopify

Shopify's native analytics give you month-end inventory snapshots and inventory value, which is enough to calculate turnover manually. The gap is at the SKU level, in real time, with reorder urgency ranked so you know which of your 300 SKUs to act on today.

That is the specific problem Stockcast: Inventory Forecast is built to solve. It monitors your Shopify stock levels daily, calculates days on hand per SKU with transparent math you can verify, ranks stockout risk by urgency, and flags dead stock before it becomes a carrying-cost problem. It sends a daily digest so the KPIs surface to you rather than requiring you to go hunting. You get the four core metrics above applied automatically, without a spreadsheet.

If you are also navigating the Stocky shutdown, its CSV import rebuilds your supplier data in minutes so none of your reorder history is lost.

Try Stockcast: Inventory Forecast on the Shopify App Store

FAQ

What is a good inventory turnover ratio for a Shopify store? It depends entirely on your category. Fashion and apparel typically targets 4-7 turns per year, electronics 4-6x, supplements and consumables 8-12x, and food and beverage 12-15x. Benchmarking against a blended retail average is misleading; use your vertical's band.

How do I calculate days on hand for a Shopify product? Divide your current stock level by your average daily units sold. For example, 90 units with an average of 6 sold per day gives you 15 days on hand. If your supplier lead time is 14 days, you are at the edge of a stockout and should reorder immediately.

What is GMROI and why does it matter more than revenue rank? GMROI is Gross Profit divided by Average Inventory Cost. It tells you the gross profit return on every dollar of stock you hold. A SKU ranked #3 by revenue but #9 by GMROI is costing you capital that would be better deployed elsewhere. It is the most useful metric for deciding which categories to grow and which to wind down.