How to Find Slow-Moving Inventory on Shopify (Before It Becomes Dead Stock)
How to Find Slow-Moving Inventory on Shopify (Before It Becomes Dead Stock)
You bought 500 units. Six months later, 400 are still in your warehouse. Sound familiar?
Slow-moving inventory is one of the biggest cash flow killers in e-commerce. The problem is, most store owners don't see it until it's too late.
Here's how to identify slow movers early and what to do about them.
What Counts as "Slow-Moving" Inventory?
There's no universal definition, but here are useful benchmarks:
By time:
- Fast moving: Sells out within 30 days
- Normal: Sells out within 90 days
- Slow moving: Still in stock after 90 days
- Dead stock: No sales in 180+ days
By sell-through rate:
- Healthy: 80%+ of inventory sold within expected timeframe
- Concerning: 50-80% sold
- Slow: 20-50% sold
- Dead: Under 20% sold
Your specific thresholds depend on your industry. Fashion moves faster than furniture.
Why Shopify's Built-In Reports Don't Show This
Shopify's analytics tell you what's selling. They don't highlight what's NOT selling.
There's no native report for:
- "Products with less than 10% sell-through in 90 days"
- "Items that haven't sold in 60 days but have 50+ units in stock"
- "SKUs where current stock exceeds 6 months of sales velocity"
You can technically figure this out by exporting inventory and sales reports, matching them in Excel, and calculating ratios. But by the time you do that monthly, you've lost weeks of potential action.
How to Find Slow Movers: The Quick Method
If you need to find slow-moving inventory today, here's the manual approach:
Step 1: Export Your Inventory
Go to Products > Export and get your current inventory levels.
Step 2: Export Sales by Product
Go to Analytics > Reports > Sales by Product and set a 90-day window.
Step 3: Calculate Sell-Through
For each SKU: (Units Sold ÷ Starting Inventory) × 100 = Sell-through %
Step 4: Flag the Problems
Anything below your threshold (say, 30% in 90 days) needs attention.
The problem: This takes hours. And you need to do it regularly to catch emerging slow movers.
How to Find Slow Movers: The Smart Method
AI-powered analytics tools like Sightly let you ask questions in plain English:
"Show me products with more than 30 days of inventory that haven't sold in the last 14 days"
Result: Instant list of at-risk inventory.
"Which products have sell-through rate below 25% for this quarter?"
Result: Your slow movers, ranked by severity.
"Compare sell-through by category this quarter vs last quarter"
Result: See which categories are slowing down.
No spreadsheets. No formulas. Answers in seconds.
Why Inventory Becomes Slow-Moving
Before you fix it, understand why it's happening:
1. Over-ordering on Initial Purchase
You projected 1,000 sales. Reality: 200. Common with new products or optimistic forecasts.
2. Seasonal Mismatch
Summer products ordered in June are slow movers by August. Timing matters.
3. Trend Shifts
Fashion and style products have short relevance windows. What was hot in January might be dead by March.
4. Poor Product-Market Fit
Sometimes products just don't resonate. No amount of marketing fixes fundamental fit issues.
5. Pricing Problems
Priced too high for perceived value. Competitors undercut you. Market shifted.
6. Visibility Issues
Great product, but buried on page 5 of collections. Customers can't buy what they can't find.
7. Bad Photography or Descriptions
The product is fine, but the presentation undersells it.
What to Do With Slow-Moving Inventory
Once you've identified slow movers, you have options:
Option 1: Increase Visibility
Before discounting, try featuring slow movers:
- Move to top of collection pages (Sightly can automate this)
- Add to homepage featured section
- Create dedicated "hidden gems" collection
- Feature in email marketing
Sometimes products just need eyeballs.
Option 2: Bundle Strategically
Pair slow movers with bestsellers:
- "Complete the look" bundles
- "Starter kit" combinations
- Volume discounts on slow + fast items
Customers get value. You move inventory.
Option 3: Discount Progressively
Don't jump to 50% off. Start smaller:
- Week 1-2: 15% off
- Week 3-4: 25% off
- Week 5-6: 40% off
- Week 7+: Liquidation pricing
This captures customers with different price sensitivities.
Option 4: Move Channels
Slow on your website doesn't mean slow everywhere:
- List on Amazon marketplace
- Sell through wholesale to retailers
- Offer to liquidation buyers
- Donate for tax write-off
Option 5: Learn and Discontinue
Some inventory is a loss. Accept it. But document:
- Why did we buy this?
- What signals did we miss?
- How do we avoid this next time?
Expensive lessons are only valuable if you learn from them.
Setting Up Slow-Moving Inventory Alerts
Don't wait until quarterly reviews. Set up automated monitoring:
Weekly Check
"Which products have over 100 units with no sales this week?"
Monthly Check
"Show me products below 30% sell-through for the month"
Quarterly Check
"Full inventory aging report: categorize all products by days since last sale"
Using Sightly, you can save these questions and get automated reports on schedule.
Real Numbers: The Cost of Slow Inventory
Let's calculate what slow movers actually cost:
Example:
- 500 units purchased at $10 = $5,000 inventory cost
- Sell-through after 6 months: 20% (100 units sold at $25 = $2,500 revenue)
- Remaining 400 units liquidated at $5 = $2,000
P&L:
- Revenue: $4,500
- Cost: $5,000
- Loss: $500
But that's not the full picture. That $5,000 tied up for 6 months could have purchased fast-moving inventory that turned 3 times.
Opportunity cost: If that $5,000 had gone into products with 90-day turns and 40% margins, you'd have made $2,000 profit instead of a $500 loss.
Real cost of slow inventory: $2,500 in lost opportunity.
FAQ: Shopify Inventory Management
How often should I check for slow movers?
Weekly for fast-moving categories (fashion, trending items). Monthly for stable categories. Always check before reordering anything.
Should I avoid buying inventory altogether and dropship?
Dropshipping solves inventory risk but creates other problems (lower margins, shipping times, quality control). The better answer: get better at forecasting and monitoring.
What sell-through rate should I target?
Industry-dependent, but 80%+ within your expected selling window is healthy. Below 50% needs investigation. Below 30% is a problem.
Can I prevent slow-moving inventory?
Reduce it through:
- Conservative initial orders (start small, reorder fast movers)
- Better demand forecasting
- Regular inventory monitoring
- Quick action when sell-through slips
What's the difference between slow-moving and seasonal inventory?
Seasonal inventory has a planned slow period. Holiday decorations in January are expected to be slow. That's different from year-round products that simply aren't selling.
The Bottom Line
Slow-moving inventory is inevitable. Dead stock isn't.
The stores that manage inventory well aren't the ones that never have slow movers—they're the ones that identify slow movers early and take action while there's still time.
Check your inventory this week. Find your slow movers. Do something about them.
Sightly brings AI-powered analytics to Shopify. Ask questions about inventory, sales, and customers in plain English. Try it free.
Michael Thomson
Software Developer specializing in Shopify apps and e-commerce solutions.
Get in touchRelated Articles
Stop Guessing What's Selling: How AI Analytics Is Replacing Shopify Spreadsheets
You export a CSV, open a spreadsheet, build a pivot table, squint at columns for twenty minutes, and still aren't sure which products are actually trending. There's a faster way now.
Shopify Speed Optimization: 12 Proven Ways to Make Your Store Faster in 2026
A slow Shopify store costs you money on every visit. Google penalizes it in rankings, customers bounce before the page loads, and conversion rates drop with every extra second. Here's how to fix it.
How to Reduce Shopify Cart Abandonment: 9 Strategies That Actually Work in 2026
The average Shopify cart abandonment rate is around 70%. That means for every 10 customers who add a product to their cart, 7 leave without buying. Here are nine things you can do about it that don't involve guesswork.