Inventory Status Report for Shopify
A comprehensive overview of product inventory, detailing the quantity available for products that are live, in draft, or have been archived.
5 from 1,800+ merchants
2,000+ data fields
Trusted by 40,000+ Shopify stores
Updated June 2026
.png)
.png)
.svg)
.svg)
.svg)
Why the Inventory Status Report matters
Most stores accumulate catalog cruft over time: Active products that are out of stock and shouldn't be, Draft products that should have been deleted, Archived products still showing up in old links. Each of these creates a small leak - a customer who lands on a page they can't buy from, a product page eating SEO juice without driving sales.
The Inventory Status Report surfaces all of this in one view. It crosses the two key catalog dimensions - product state (is the listing live?) and stock status (is the inventory available?) - and tells you exactly which combinations need attention.
Active + Out of Stock - fix urgently. Customers are landing here and bouncing. Draft + In Stock - why is sellable stock hidden? Re-activate or delete. Archived + In Stock - same question, with a longer tail. Active + In Stock - the healthy default.
This is the report ecommerce managers run before every catalog cleanup, every site refresh, and every audit.
What's included in the report
dentification - Product Title · Variant Title · SKU
The two dimensions - Product Status - Active / Draft / Archived (set on the Shopify product).
Inventory Status - In Stock / Low Stock / Out of Stock (calculated from inventory quantity vs. threshold).
Inventory metrics - Inventory Quantity - Current units.
Inventory Cost - Cost value of remaining stock.
Vendor · Location · Collections · Product Type · Product Price · Inventory Value · Last Sold Date · Published Date
Who uses this report - 4 scenarios
1. Catalog managers running a hygiene sweep
2. Ecommerce managers protecting conversion rate
3. SEO leads cleaning up indexable URLs
4. Founders running quarterly catalog review
How to read the Inventory Status Report
• The 2×3 matrix. Three product states, three stock states (or four counting Low). Healthy stores have ~95% in Active + In Stock or Active + Low.
• Active + Out of Stock. The fix-now bucket. Either reorder or hide.
• Draft + In Stock. A product hidden from shoppers but holding inventory. Re-activate or transfer the stock to another SKU.
• Archived + In Stock. Same question on a longer time horizon. Liquidate or delete.
• Active + In Stock + zero sales last 90 days. Hidden underperformers. Promote, re-photograph, or archive.
How to build the report in Report Pundit
- Install Report Pundit from the Shopify App Store. 14-day free trial. No card required.
- Open Report Pundit from your Shopify admin and click Pre-built Reports.
- Select Inventory Status Report from the Inventory category.
- Apply filters (location, vendor, collection, product tag, product type, status - whatever fits).
- Customize columns - add COGS, inventory days remaining, sales velocity, sell-through, or any of 2,000+ fields.
- Run the report. Results load in seconds for most stores.
Export or schedule - Google Sheets, Excel, CSV, PDF, or scheduled email delivery to your team.
Sample report
Customization & filters
• Filter by Product Status - focus on Active, or audit Drafts and Archives
• Filter by Inventory Status - focus on Out of Stock or Low
• Combine both filters - e.g., "Active + Out of Stock" as a dedicated view
• Add Last Sold Date - find dead-weight active inventory
• Add Vendor / Product Type - for category-level catalog reviews
Automate & export
- Schedules — hourly, daily, weekly, monthly, or custom cron
- Delivery formats — Excel, CSV, PDF, or push to Google Sheets in real time
- Group by month or week — trends instead of a static snapshot
- Destinations — email (multiple recipients), Google Sheets, Google Drive, FTP/SFTP, Looker Studio, BigQuery
- Conditional alerts — get notified only if a channel's net sales drop more than X% week-over-week
Report Pundit vs Shopify's native Sales by Channel report
Frequently Asked Questions
A report that classifies every variant's stock status (In Stock, Low Stock, Out of Stock) alongside its product state (Active, Draft, Archived) - giving a one-glance picture of catalog health.
Inventory Status focuses on two binary-ish dimensions (Product Status × Stock Status) for catalog hygiene. Inventory Level Indicator focuses on the gradient of stock health (High / Medium / Low / Out). Run Status for catalog reviews, Level Indicator for daily ops.
The product is live and visible to shoppers, but has zero stock. This is the urgent combination - shoppers are landing on a page that can't sell.
Benefits
Available Stock Overview
Product Status
Track Inventory
Related Reports
ABC Analysis
Every product graded A, B, or C by its share of revenue — so you can pour stock investment into the items that earn it, and stop over-buying the ones that don’t.
Inventory by Product Type
This is grouped inventory data organized by custom product types, alongside product and variant details, providing a comprehensive view to analyze overall inventory status.
Inventory Reorder Point
This report helps identify the exact point at which inventory should be restocked to prevent any interruptions in product availability, ensuring a smooth supply chain from both your inventory and your vendor's end. It informs the merchant about the sales velocity, lead time, and safety stock.
Inventory level Indicator
The report provides Shopify merchants with a real-time analysis of stock levels, highlighting products that are overstocked, optimally stocked, or understocked. This report is essential for monitoring stock health and ensuring that inventory levels align with demand.
Inventory on Hand
A real-time snapshot of every product, variant, and SKU in stock - across every warehouse, retail location, and 3PL - with vendor, cost, and inventory value in a single view.
Inventory Sell-Through
The percentage of stock that actually sold for every product and variant so you can separate the fast-movers worth reordering from the dead stock eating your shelf space and cash.
Inventory Shipments
Every inbound shipment tracked end to end — shipped, received, accepted, and rejected quantities with acceptance rate — so you can catch discrepancies, plan around arrivals, and benchmark supplier reliability.
Low Stock Product
The Low Stock Product Report highlights products that are approaching or have reached a low stock threshold, helping Shopify merchants proactively manage restocking needs. This report is crucial for preventing stockouts on popular items and ensuring seamless sales without interruption
Inventory Sale Value
A report outlining the sale value of your inventory, including details on product quantities, variants, collections, and total value based on current sale prices for analysis.
Inventory Transfers
Every stock movement between your locations in one view — origin, destination, status, and received-vs-rejected quantities — so you can balance stock, reconcile transfers, and measure internal lead times.
Inventory Replenishment
A ready-to-action list of exactly which products need reordering now — driven by real sell-through velocity, adjusted for stock already on its way, and broken down by location.
Inventory Cost
The Inventory Cost Report provides a comprehensive analysis of the costs associated with your inventory, giving you a clear view of the financial investment tied up in stock. This report calculates the cost of inventory on hand and can include both current and historical cost data
Out of Stock Product
A report listing products that are out of stock, including essential details such as product inventory and the location where the stock was depleted.
Inventory by Collections
This report provides a detailed view of inventory levels, organized by product collections, allowing businesses to track stock availability and manage inventory efficiently.
Build and automate your Shopify Reporting
Unlock the full potential of your Shopify store with Report Pundit. Gain access to over 2000 data fields, automate reports, and make data-backed decisions to grow your business.