Shopify shows 'inventory on hand' but not which SKUs are gathering dust. You have cash tied up in products that haven't sold in 90+ days, but Shopify doesn't tell you which to markdown, bundle, or liquidate. You need an action plan, not just a count.
Your first run is free - no card.
Get a ready-to-use file with everything you need
SKUs by days since last sale and $ tied up
Cash recovery at 25%, 50%, 75% markdown levels
Pair dead SKUs with hot sellers based on order data
Which items to markdown on-site vs. liquidate on eBay
Real outcomes for your Shopify business
Free cash fast: Unlock $5,000-$25,000 tied up in slow movers and dead inventory
Action plan ready: Bundle suggestions, markdown scenarios, and channel picks per SKU
Track progress: Weekly updates show dead stock $ decreasing - celebrate wins
What this Excel Decision Kit tracks from your Shopify data
$ tied up in SKUs with less than 1 sale per 90 days, sorted by COGS investment
SKUs ranked by days since last sale - see what's actually moving vs. stuck
Cash recovered at 25%, 50%, 75% markdown vs. keeping on shelf
Which dead SKUs to bundle with hot sellers (suggested pairings from order data)
Which slow movers to push to eBay/Poshmark vs. markdown on Shopify
From sales velocity to action plan
Definition: Sum of (Inventory × COGS) for SKUs with less than 1 sale per 90 days
Source: Inventory levels + sales velocity + cost data
Granularity: Total $ tied up, by SKU
Definition: SKUs with sales velocity less than 10% of category average
Source: Sales history by category
Granularity: Per-SKU, compared to category benchmark
Definition: (Cash recovered from markdown/bundle) ÷ COGS tied up × 100
Source: Projected recovery at discount levels
Granularity: Scenario analysis: 25%, 50%, 75% off
What makes Shopify different and how we handle it
product.published_at: filter out items listed less than 90 days
product.product_type / vendor: for category velocity comparison
inventory_item.cost: for cash-tied-up calculation
Shopify-specific setup in 7 steps
Authorize access to inventory, sales history, and product costs
Set your definition: <1 sale per 90 days (default) or customize by category
Upload variant costs to calculate true cash tied up (optional but recommended)
Excel lists every slow mover ranked by $ tied up and days since last sale
See markdown scenarios, bundle suggestions, and channel recommendations per SKU
Get CSVs: items to markdown on Shopify, items to list on eBay, bundle combinations
Monitor dead stock $ decreasing - celebrate as slow movers clear out
Start automating your Shopify reporting today and save hours every week.
Our report recipes are designed by e-commerce experts who understand what metrics matter most for your business decisions.
Connect your platforms in minutes, not hours. Our OAuth2 integration makes setup secure and simple.
Reports are delivered in perfectly formatted Excel files that work seamlessly with your existing workflow.
Our report recipes are designed to provide actionable insights and recommendations for your business.
Common questions for Shopify users
We compare to same period last year. Winter coats with no summer sales aren't flagged if they sold well last winter.
Items listed less than 90 days are excluded from dead stock analysis - they haven't had time to prove velocity yet.
We analyze which products are frequently bought together, then suggest pairing dead SKUs with hot sellers in bundles.
Yes - multi-location stores get dead stock analysis per warehouse, plus transfer recommendations to consolidate slow inventory.
We recommend eBay for truly dead items (>6 months no sale) and Shopify markdown for slower movers you want to clear at lower loss.
"We had $47K in dead inventory we didn't even know about. The liquidation playbook helped us clear $31K through bundles and markdowns in 8 weeks. Game changer."
Robert Chen
Inventory Manager, Tech Accessories Plus
$31K cash recovered in 8 weeks
47 slow SKUs cleared via bundles
Other decision kits for your Shopify data
Connect your Shopify account and generate your first reconciliation in under 5 minutes. First report free.
No card • Keep the file forever • Cancel anytime