Who this guide is for
Shopify merchants and operations leads who want to graduate from quantity-based inventory management to financial performance tracking - especially those suspecting that too much capital is tied up in slow-moving or dead stock.
The challenges of scale
Shopify's native analytics show stock quantities, sales volumes, and inventory value - but provide no metrics for whether that inventory is generating a return on investment.
KPIs like inventory turnover, GMROI, and carrying cost percentage are well-documented in retail literature but rarely explained in the context of how to calculate them from Shopify's actual data.
Merchants make buying decisions based on 'do we have enough?' rather than 'is this category working efficiently?' - missing the financial signal that could prevent over-buying.
Shopify's ABC analysis classifies products by revenue but not by profitability or capital efficiency, giving an incomplete picture for buying decisions.
Most content on 'inventory KPIs' explains formulas but doesn't walk through how to pull the underlying data from Shopify reports - leaving merchants unable to implement the advice.
Fundamental concepts
Inventory Turnover
How many times per year a brand sells and replaces its entire inventory. A higher turnover means faster cash recovery and lower carrying cost. The primary indicator of inventory efficiency.
Formula
Inventory Turnover = COGS / Average Inventory ValueExample: COGS $240,000, average inventory $40,000. Turnover = 6.0×/year. This means inventory is replaced every 60 days on average. Top DTC performers target 8×+.
Days of Inventory on Hand (DOH / DIO)
How many days of supply you have at your current sell rate. Lower is generally better - it means less capital tied up and lower carrying cost risk. The inverse of turnover.
Formula
DOH = (Average Inventory Value / COGS) × 365 OR 365 / Inventory TurnoverExample: Average inventory $43,780, COGS $373,400. DOH = (43,780/373,400) × 365 ≈ 43 days. At 6× turnover, DOH = 365/6 = 61 days.
Gross Margin Return on Inventory Investment (GMROI)
The gross profit generated per dollar of inventory investment. Tells you which categories are efficiently converting capital into profit. A GMROI below 1.0 means the category doesn't cover its carrying cost.
Formula
GMROI = Gross Profit / Average Inventory Cost = (Revenue – COGS) / Average InventoryExample: Revenue $200K, COGS $120K, average inventory $50K. GMROI = $80K / $50K = 1.6. A GMROI of 1.5+ is considered healthy for most ecommerce categories.
Sell-Through Rate
The percentage of available inventory sold in a given period. Used to compare performance across SKUs or categories and to identify which products are moving too slowly relative to the buy.
Formula
Sell-Through Rate = Units Sold / (Units on Hand + Units Sold) × 100%Example: Bought 200 units, sold 140 in the period. Sell-through = 140/200 = 70%. Target varies by category: fashion typically aims for 80%+ per season.
Inventory Carrying Cost Percentage
The annual cost of holding inventory expressed as a percentage of average inventory value. Used to calculate the ongoing cost of dead stock and over-ordering. Industry benchmark: 20–30% per year.
Formula
Carrying Cost % = (Capital Cost + Storage + Insurance + Obsolescence + Shrinkage) / Average Inventory Value × 100Example: At 25% carrying rate, a $100K inventory investment costs $25K/year to hold - $2,083/month - regardless of whether it sells.
Inventory Aging Buckets
Classification of inventory by how long units have been on hand (0–30, 31–60, 61–90, 90+ days). Enables rapid identification of capital locked in slow-moving stock before it becomes dead stock.
Formula
Aging % = $ Value in Bucket / Total Inventory Value × 100Example: If 30%+ of inventory value is in the 90+ day bucket, your buying process is creating structural overstock - not just occasional slow movers.
ABC Analysis
Product classification by contribution to total revenue: A-class (top ~20% of SKUs driving ~80% of revenue), B-class (middle performers), C-class (tail SKUs). Used to prioritize attention and differentiate replenishment rules.
Formula
Class A: top 80% of revenue. Class B: next 15%. Class C: bottom 5%.Example: A-class items should rarely stockout - they need tighter reorder points and lower ROP breach risk. C-class items need scrutiny to avoid dead stock, not just standard safety stock rules.
Why native Shopify isn't enough
While Shopify is a strong commerce engine, its native inventory tooling often reaches a limit once brands need better forecasting, replenishment logic, supplier workflows, and purchasing discipline.
- Shopify's inventory reports show quantities, sell-through rates, and COGS-based inventory value, but do not compute financial KPIs like GMROI, carrying cost %, or inventory turnover ratio.
- The 'Days of Inventory Remaining' metric in Shopify uses a 28-day trailing average and is only shown for products with recent sales - making it an incomplete signal for dead-stock detection.
- Shopify's ABC analysis (revenue-weighted) does not cross-reference with inventory cost or weeks-of-supply, limiting its usefulness for buying and liquidation decisions.
- There is no native aging-bucket report in Shopify showing the financial value of inventory by how long it has been on hand.
- Shopify provides no carrying cost calculation, GMROI metric, or cash-tied-up analysis - merchants must export data and build these in spreadsheets or BI tools.
Key stats and benchmarks
E-commerce brands targeting operational efficiency aim for inventory turnover of 4–6× per year; top performers achieve 8× or more, meaning an average hold time of 45 days or less.
Annual carrying costs for ecommerce merchants typically run 20–30% of average inventory value - meaning $1,000,000 in inventory generates $200,000–$300,000 per year in holding costs.
15–25% of the average ecommerce brand's inventory is dead or very slow-moving - representing a significant portion of capital generating zero revenue.
Poor inventory management (combining stockout losses and overstock costs) can erode up to 11% of annual sales for ecommerce merchants.
US retailers collectively lose approximately $362 billion per year to excess inventory carrying costs and write-downs.
Merchants who implement formal GMROI and turnover tracking by category make measurably better buying decisions within two buying cycles, on average reducing dead stock by 15–25%.
Practical angles to explore
- The Shopify inventory KPI dashboard: how to calculate each metric using data you can pull from Shopify Analytics today
- Benchmarks by ecommerce category: what a good inventory turnover rate looks like for fashion vs. electronics vs. consumables
- GMROI in practice: how to use it to decide which categories deserve more buying budget and which should be wound down
- The dead-stock early warning system: how to combine DOH, aging buckets, and sell-through rate to catch problems 60–90 days earlier
- ABC inventory analysis on Shopify: going beyond revenue classification to capital efficiency
How Synplex helps
Synplex dashboards automate the calculation of these KPIs from your live Shopify data - surfacing inventory turnover, DOH, GMROI, and carrying cost estimates per SKU and category without manual spreadsheet work. When a SKU's turnover drops or DOH spikes, Synplex flags it and surfaces it alongside a Smart Replenishment suppression - so you stop buying more of what's already over-weighted.
- Automated inventory turnover and DOH calculations updated from Shopify sales and inventory data
- GMROI per product and category - updated as sales and inventory shift
- Inventory aging buckets showing financial value by time on hand
- Sell-through rate tracking with customizable target benchmarks per category
- Carrying cost estimation per SKU based on configurable annual holding rate
Suggested guide outline
- 1Intro: Why quantity-based Shopify reports are not enough for growing brands
- 2Section 1: Inventory Turnover - definition, formula, benchmarks, and how to calculate from Shopify
- 3Section 2: Days of Inventory on Hand - definition, formula, and reading the early-warning signals
- 4Section 3: GMROI - definition, formula, benchmarks, and why it's the best buying ROI metric
- 5Section 4: Sell-Through Rate - definition, formula, and target-setting by category
- 6Section 5: Carrying Cost % - what it is, how to estimate it, and what it reveals about dead stock
- 7Section 6: Inventory Aging Buckets - the fastest way to find capital trapped in slow movers
- 8Section 7: Putting it together - how to build a monthly KPI review process for your Shopify brand
- 9Section 8: How Synplex automates these KPIs so you don't need to rebuild the spreadsheet every month
Frequently asked questions
Common questions about essential inventory kpis for shopify merchants: the complete metrics guide.