← Blog

July 15, 2026 · 5 min read

How to Find Dead Stock in Magento 2: A Practical Guide

Dead stock — inventory sitting with zero sales over a meaningful window — ties up warehouse space and cash without anyone noticing, because Magento has no built-in report that surfaces it directly. Here's how to actually find it, and what to do once you have.

Why this is harder to spot than low stock

Low stock shows up the moment a quantity column hits zero — it's visible. Dead stock is the opposite: nothing draws attention to a product that's simply not moving. It sits in Catalog > Products looking identical to everything else, and the only way Magento's own reports surface it is indirectly — a product that never appears in a "Products Ordered" report over your chosen date range.

The manual approach

Run Reports > Products > Ordered for the last 90 days, export the list of SKUs that sold, then cross-reference against your full catalog to find what's missing from it. It works, but it's a two-report, manual-diff process most stores only do occasionally rather than as a habit — which is exactly how dead stock accumulates unnoticed for months.

Asking instead

Asked directly, AI Copilot can identify products with zero sales over a window you specify — "which products haven't sold in 90 days" returns the actual list, not just a count, since it has live access to both your sales history and current catalog in the same query.

Turning the list into action

Finding dead stock is only useful if something happens next. Asked to create a discount for the slow-moving products it just found, AI Copilot will point out that Magento's cart price rules apply to the whole cart rather than specific SKUs, then offer the real options: an automatic site-wide discount, or a coupon code you can target to a specific promotion or channel. Whichever you pick, it stages the rule — name, discount, code, scope, dates — and waits for your explicit Confirm before anything is created.