Who this guide is for
Shopify merchants with variant-heavy catalogs - fashion, footwear, electronics, home goods - who sense that cash is locked up in slow movers but can't easily quantify the damage or prioritize which items to liquidate.
The challenges of scale
Overstock is harder to spot early than stockouts; it tends to be discovered only when cash is already tight or warehouse fees become undeniable. As merchants describe it: 'pull a report on everything that's been sitting 90+ days - that's not inventory anymore, that's a storage fee you're charging yourself.'
Native Shopify reports can show slow movers and inventory valuations, but they do not calculate carrying costs, flag overstock explicitly, or model the financial impact of inaction.
15–25% of the average ecommerce brand's inventory is dead or very slow-moving stock - representing a significant fraction of total capital tied up generating zero revenue.
Merchants rarely connect the root causes - forecasting errors, minimum order quantities, excessive lead-time buffers - to dead-stock creation in a systematic way, so the same problem repeats each buying cycle.
Without a clear view of where cash is trapped (by SKU, by category, by supplier), it is impossible to make confident decisions about what to liquidate, what to mark down, and what to stop reordering.
Slow-moving stock depresses overall inventory turnover, makes GMROI look poor, and consumes warehouse space that could be used for faster-moving products.
Fundamental concepts
Dead Stock
Inventory that has had no sales for a defined threshold period (typically 6–12 months) and has little realistic prospect of selling at full price. Caused by over-ordering, trend misreads, poor forecasting, or excessive MOQ-driven purchases.
Formula
Dead Stock Units = Units with zero sales in trailing 180–365 daysExample: A fashion brand bought 500 units of a jacket in March. By September, only 80 have sold. With no reorder and declining sell-through, the remaining 420 units are approaching dead-stock status - carrying cost is accumulating daily.
Inventory Aging
The classification of inventory by how long units have been on hand - typically bucketed as 0–30, 31–60, 61–90, and 90+ days. High concentrations in the 90+ bucket signal dead-stock risk and excessive capital lock-up.
Formula
Aging % = Units (or $) in Bucket / Total Inventory Units (or $) × 100Example: If 35% of your inventory value falls in the 90+ day bucket, you likely have a structural dead-stock problem driven by buying decisions, not just a few one-off SKUs.
Inventory Carrying Cost
All costs associated with holding unsold inventory, including warehouse/storage fees, insurance, capital cost (opportunity cost of cash tied up), product obsolescence/shrinkage risk. Industry benchmark: 20–30% of average inventory value per year.
Formula
Annual Carrying Cost = Average Inventory Value × Carrying Cost Rate (20–30%)Example: A brand holding $200,000 in dead/slow-moving stock at a 25% carrying rate incurs $50,000 per year in holding costs - $4,167 per month - before any markdown or write-off.
Gross Margin Return on Inventory (GMROI)
Measures how much gross profit a brand earns for every dollar invested in inventory. A GMROI below 1.0 means the inventory is not covering its own carrying cost. Dead stock dramatically suppresses this ratio.
Formula
GMROI = Gross Profit / Average Inventory CostExample: Revenue $200K, COGS $120K (gross profit $80K), average inventory $50K. GMROI = $80K / $50K = 1.6. Adding $40K of dead stock into the denominator drops GMROI to 1.1 - a warning level for most categories.
Weeks of Supply (WOS)
Current inventory on hand divided by average weekly demand. A WOS well above your desired safety stock buffer indicates over-buying risk. Often the clearest signal that a SKU is heading toward dead stock.
Formula
WOS = Units on Hand / Average Weekly SalesExample: 150 units on hand, average weekly sales of 5 units = 30 weeks of supply. If your target is 8 weeks of supply plus 2 weeks safety, this SKU is nearly 4x overstocked.
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 analytics can highlight slow-moving SKUs and show inventory valuation (COGS-based), but do not compute carrying-cost percentages, overstock flags, or the cash impact of holding each SKU.
- There is no native 'weeks of supply versus forecast' metric in Shopify, making it hard to identify which SKUs are sitting at 3x or 5x their expected inventory level.
- Shopify's ABC analysis classifies products by revenue contribution but does not cross-reference with inventory days-on-hand or carrying cost, so a C-class product might be either a reasonable tail item or a dead-stock disaster.
- Merchants must export data to spreadsheets or BI tools to model carrying cost, rank dead-stock candidates, and simulate the P&L impact of different liquidation strategies.
- There is no aging-bucket report in native Shopify - showing how much inventory value falls in the 0–30, 31–60, 61–90, and 90+ day buckets - which is the primary tool for dead-stock triage.
Key stats and benchmarks
Industry estimates suggest 15–25% of the average ecommerce brand's total inventory is dead or very slow-moving stock - representing a significant fraction of total invested capital generating zero revenue.
US retailers lose an estimated $362.1 billion per year through excess inventory - representing tied-up capital, carrying costs, and eventual markdowns or write-offs.
Annual carrying cost benchmarks run 20–30% of inventory value; a brand with $500,000 in dead stock is effectively paying $100,000–$150,000 per year to store goods it cannot sell.
A Shopify merchant in the electronics segment described having 90% of their capital tied in inventory despite $1M annual revenue - leaving no cash for marketing, hiring, or growth.
Excess inventory and overstock combined with stockouts cost retailers globally an estimated $1.1 trillion per year in inefficiencies.
Poor inventory management - combining both stockout losses and overstock carrying costs - can erode up to 11% of annual sales for ecommerce merchants.
Practical angles to explore
- How to run a dead-stock audit in Shopify in 30 minutes - which reports to pull and how to read them
- The real cost calculator: how to quantify exactly how much your dead stock is costing you per month (template included)
- Root-cause analysis: the 5 buying decisions that create most dead stock - and how to prevent each one
- Dead-stock liquidation playbook: markdowns, bundles, outlet channels, donation, and write-off - when to use each strategy
- The dead-stock prevention checklist: how to change your buying process so the same SKUs don't repeat next season
How Synplex helps
Synplex surfaces dead-stock risk before it becomes entrenched: it computes weeks-of-supply versus forecast for every SKU, highlights items where inventory is well ahead of projected demand, and estimates the carrying cost of inaction. When reordering, Smart Replenishment automatically suppresses buy suggestions for overweight SKUs, preventing you from compounding the problem.
- Weeks-of-supply versus forecast dashboard highlighting over-stocked SKUs at a glance
- Carrying cost estimation per SKU based on inventory value and configurable holding rate
- Inventory aging buckets (0–30, 31–60, 61–90, 90+ days) with financial value summaries
- Smart Replenishment that suppresses auto-PO suggestions for SKUs already above target WOS
- GMROI calculation per product and category to identify where inventory investment is working
Suggested guide outline
- 1Intro: Dead stock defined - why it is more dangerous than it looks (and harder to see than a stockout)
- 2Section 1: How to identify dead stock using Shopify's existing reports - a step-by-step walkthrough
- 3Section 2: Quantifying the real cost - carrying cost, markdown losses, write-offs, and opportunity cost
- 4Section 3: Root causes of dead stock - the buying and forecasting decisions that create it
- 5Section 4: Liquidation strategies - markdowns, bundles, outlet channels, and when to write off
- 6Section 5: Prevention - how to change your buying process to stop dead stock from forming
- 7Section 6: How Synplex helps you see and prevent dead stock proactively
- 8Closing checklist: monthly dead-stock review process for Shopify brands
Frequently asked questions
Common questions about dead stock reduction for shopify brands: turn shelf sitters into cash.