shopify-admin-dead-stock-identifier

Dead stock identification cross-references Shopify variant inventory quantities against order line item activity within a configurable lookback window to flag items with positive stock and zero sales. This process requires authenticated read access to products, orders, and inventory via GraphQL queries.

Shopify inventory analysis supports optional vendor filtering and minimum on-hand quantity parameters to narrow dead stock detection scope. These configurable filters help target specific merchandising audits or vendor-specific inventory reviews during reconciliation.

Shopify dead stock detection enforces strict read-only safety and requires only authenticated read access for products, orders, and inventory. It performs GraphQL queries across productVariants, orders, and inventoryItems without modifying any store data.

Dead stock value calculation uses inventory item unit cost data from Shopify to estimate the capital tied up in unsold SKUs. This estimated valuation helps prioritize clearance or merchandising decisions for flagged variants with positive stock and no sales.

The best way to report Shopify SKUs with zero sales is generating a dated CSV report from a dead stock analysis. Configuring a lookback window like 90 days produces a formatted list of stocked variants with no recorded order activity for follow-up actions.

Shopify dead stock reports flag variants with positive inventory but no recorded sales within the configured lookback window because order velocity is reconciled against current stock levels. Items appearing on the report have on-hand quantities exceeding zero with matching line item activity returning zero.