Shopify
Sightly
Inventory
Analytics

How to Find Slow-Moving Inventory on Shopify (Before It Becomes Dead Stock)

Michael ThomsonJanuary 24, 202510 min read

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.

M

Michael Thomson

Software Developer specializing in Shopify apps and e-commerce solutions.

Get in touch

Related Articles