Inventory level Indicator Report for Shopify
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.
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 Level Indicator Report matters
Raw inventory numbers don't tell you what's healthy. Is 47 units of an item "fine" or "running low"? It depends entirely on how fast that item sells. A bestseller with 47 units might have 2 days of stock; a slow-mover with 47 units might have 6 months.
The Inventory Level Indicator solves this by letting you set thresholds - by product, product type, or globally - and then classifies every variant against them. The output: a quick visual of your catalog's inventory health that anyone on the team can read in 30 seconds. Understock surfaces immediately. Overstock too.
This is the report Report Pundit was designed around. Most other reports tell you what - Level Indicator tells you what to act on first.
What's included in the report
Identification - Product Title · Variant Title · SKU · Collections
Product Status - Active / Draft / Archived
Inventory Quantity - Live units in stock
Inventory Value - Selling-price value of remaining stock
Inventory Level - The headline column. Values: High · Optimal/Medium · Low · Out of Stock. Based on thresholds you set.
Vendor · Product Type · Sales Velocity (last 30 days) · Inventory Days Remaining · Reorder Point · Location
Who uses this report - 4 scenarios
1. Weekly inventory health review
2. Merchandisers running a clearance plan
3. Buyers planning the next PO
4. Founders building the weekly leadership update
How to read the Inventory Level Indicator Report
• Aim for the bell curve. Healthy stores have ~60-70% of SKUs in Optimal, with thin tails on either side. Skewed left (lots of Low) = understock; skewed right (lots of High) = overstock.
• High + low velocity is the worst combination. That's capital trapped without a sales engine to free it.
• Low + high velocity is the second-worst. Lost sales waiting to happen - reorder immediately.
• Thresholds need quarterly tuning. Set once, revisit each quarter as sales velocity shifts.
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 Level Indicator Report from the Inventory category.
- Apply filters (location, vendor, collection, product tag, product type, status - whatever fits).
- Set your thresholds. Define what counts as High, Medium, and Low - globally or per product type. You only do this once.
- 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
.webp)
Customization & filters
• Threshold setup - set High/Medium/Low cutoffs globally, per product type, per vendor, or per SKU
• Filter by Indicator level - focus on Low only, or High only
• Filter by Product Type - apparel thresholds differ from accessories
• Add Sales Velocity - combine indicator with movement speed
• Group by indicator level for distribution view
• Add Reorder Point column to act faster on Low items
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 classification of each product or variant's stock level against thresholds you define - typically High, Optimal/Medium, Low, and Out of Stock. It turns raw inventory numbers into a quick health view.
You set them. Globally, by product type, by vendor, or per SKU. Most stores start with a global rule (e.g., Low = under 10 units) and refine by product type over time.
Low Stock is just the "Low" subset. The Level Indicator Report shows the whole catalog across all four states - useful for weekly health reviews and overstock identification.
Benefits
Prevent Overstocking
Effective Stock Adjustments
Align Stock Levels
Related Reports
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 On Specific Day
A point-in-time snapshot of exactly what you had in stock on any past date — by product, variant, SKU, and location — for month-end accounting, audits, and cross-date comparison.
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 Status
A comprehensive overview of product inventory, detailing the quantity available for products that are live, in draft, or have been archived.
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.
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.
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 by Location
A report organized by inventory locations, detailing products and variants on hand, with a breakdown of the value for each product.
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 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.
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.
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 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 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.
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.