November 17, 2026 · 5 min read

Shopify Dead Stock Reports: Find Stalled Variants by Location

Shopify dead stock reports can miss unsold variants and stranded inventory. Learn how to find both, verify the cause, and choose the right fix.

Shopify Dead Stock Reports: Find Stalled Variants by Location

Dead stock is inventory you hold but can no longer expect to sell through normal demand. To detect it on Shopify, compare stock on hand with variant-level sales, then check where the units sit; to clear it, first decide whether they should be transferred, promoted, returned, or written off. A storewide sell-through figure alone can hide the answer.

Key takeaways

  • Define a review window, such as 90 days without a sale, rather than treating every slow week as dead stock.
  • Check variants with zero sales separately; they may be absent from Shopify's sell-through report.
  • Compare quantities by location before discounting a product that still sells elsewhere.
  • Separate sellable units from committed, damaged, or otherwise unavailable stock.

What counts as dead stock when a product has multiple variants?

Judge the variant, not just the product page. A black medium shirt can sell every day while its yellow extra-small variant sits untouched. Combining their sales makes the slow size look healthier than it is.

For an initial screen, flag a variant when it has positive stock on hand and no units sold in your chosen window. Ninety days is a useful review rule, not a universal definition. A newly launched item, an intentionally seasonal product, and a discontinued color need different decisions. Record the date it first became available, the last sale date, current quantity, unit cost, and next planned selling season before labeling it dead.

Capital at risk = units you may need to clear × unit cost. If 40 units cost $18 each, $720 of purchase cost is tied to that variant. That is an illustrative exposure, not a promise that a promotion will recover $720. For more on terms such as on hand and available, see the inventory glossary.

How do you find variants a Shopify sell-through report might miss?

Start in Analytics > Reports, filter to Inventory reports, and inspect sales and remaining quantities at the variant SKU level. Shopify's inventory report definitions reveal two traps: its Products by sell-through rate report includes only variants sold at least once before or during the selected period, and its Inventory remaining per product report shows N/A for days remaining when recent daily sales average zero. Neither result means that an unsold variant has no stock.

Build the candidate list in this order:

  1. Export or list tracked variants with positive on-hand quantities, including variants that have never sold. Shopify's inventory CSV guidance describes exports by location.
  2. Match those variant SKUs to units sold over a period appropriate to the product, such as the past 90 days. Keep variants with zero sales in the list instead of dropping blank matches.
  3. Review the 28-day inventory-remaining report for recent stalls, but treat N/A plus stock on hand as a prompt to investigate, not as a clearance order.
  4. Exclude stock received too recently for a fair test and check whether the variant was actually available to customers.

As of November 17, 2026, there is another reason to check your definitions: Shopify says inventory reports switched from Available to On hand quantities on October 1, 2026. Earlier report data still uses Available. On hand can include committed and unavailable units, so a before-and-after comparison may show a quantity change without a matching change in sellable stock. Verify the inventory state before assigning a clearance value.

How can location data change the dead-stock decision?

Shopify tracks inventory independently by location. A variant with 40 units in one warehouse and none in a store where it sells has a distribution problem, not necessarily a demand problem. Conversely, stock recorded at a location that does not fulfill new orders can appear in your totals while its Available quantity shows a dash. Check the variant's location assignment and fulfillment setup before declaring demand dead; Shopify explains this distinction in its multi-location inventory guidance.

What you findLikely diagnosisFirst action
No sales anywhere, stock held for a full review windowPossible dead stockCheck launch date and season, then test recovery options
Sales elsewhere, stock idle at one locationStranded inventoryCompare transfer cost with likely sales at the destination
On-hand units but no Available quantityStock-state or location-assignment issueCheck committed, unavailable, and location settings
Recent launch with positive stock and no salesToo early to classifySet a review date and monitor exposure

Do not infer local customer demand solely from where an online order was fulfilled. Shopify's order routing can assign online orders based on inventory and routing rules, so fulfillment location is not the same thing as customer preference. Use POS sales where relevant, plus your order and routing context, to decide whether a transfer makes sense.

How should you clear stock after identifying the cause?

Choose the least destructive remedy that fits the evidence:

  • Transfer sellable stock if another location has demonstrated demand and the expected margin covers shipping and handling. Shopify supports tracked transfers between locations.
  • Improve discoverability if shoppers could not find or buy the variant. Check its product status, channel availability, variant options, and location assignment before cutting its price.
  • Test a targeted offer for genuinely slow stock. Set a minimum acceptable recovery per unit using landed cost, fulfillment costs, and the discount, then measure units cleared rather than clicks.
  • Ask about a supplier return or exchange when terms allow it. For damaged or expired goods, document the reason and use the appropriate inventory adjustment instead of presenting them as sellable.

The order matters. Discounting stranded units before checking another location can give away margin to solve the wrong problem. Likewise, leaving a dead variant in the reorder queue can turn a $720 exposure into a larger one. After each action, record units moved or sold and cash recovered, then revisit the buying decision.

For a catalog with hundreds of variants, repeating this screen by hand is where the spreadsheet starts to fray. Stockcast: Inventory Forecast offers dead-stock detection and tied-up-capital reporting on its Pro tier, alongside explainable reorder recommendations. The useful question is still the same one you can answer manually: Which units are genuinely stalled, and what evidence supports the next move?

FAQ

Is a variant dead stock if it has not sold in 30 days?

Not automatically. Thirty days may be meaningful for a fast-moving staple but too short for a new or seasonal item. Set a review window by product type, then check how long the variant has actually been available for sale.

Why does Shopify show N/A for days of inventory remaining?

Shopify shows N/A when a variant has no sales in the report's recent measurement period, so it cannot calculate a daily sales rate. If you still hold units, investigate the variant rather than interpreting N/A as zero inventory.

Should I discount stock that is idle at one location?

First check whether it sells at another location and whether a transfer would preserve more margin after transport costs. Also verify that the idle location can sell or fulfill that variant; a location-setting problem will not be fixed by a discount.

If you want to make that evidence check part of your inventory routine, try Stockcast: Inventory Forecast on the Shopify App Store.

shopify inventorydead stockinventory reportsmulti-location inventoryinventory analytics

Frequently asked questions

Is a variant dead stock if it has not sold in 30 days?

Not automatically. Thirty days may be meaningful for a fast-moving staple but too short for a new or seasonal item. Set a review window by product type, then check how long the variant has actually been available for sale.

Why does Shopify show N/A for days of inventory remaining?

Shopify shows N/A when a variant has no sales in the report's recent measurement period, so it cannot calculate a daily sales rate. If you still hold units, investigate the variant rather than interpreting N/A as zero inventory.

Should I discount stock that is idle at one location?

First check whether it sells at another location and whether a transfer would preserve more margin after transport costs. Also verify that the idle location can sell or fulfill that variant; a location-setting problem will not be fixed by a discount.

Seven years of Shopify, on one page.

Roles, projects, stack and certifications are on the resume.

Resume Download PDF LinkedIn