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.

Table of contents

What Is the Inventory Level Indicator Report?

The Inventory Level Indicator report lists every product and variant in your Shopify store and adds a plain High, Medium, or Low label to each line based on how much stock is left. Instead of reading raw quantities row by row, you get a signal you can act on: what to reorder, what to leave alone, and what is sitting too long.

The label is not a fixed Shopify value. It comes from thresholds you set, so the same quantity can read as Low for a fast seller and High for a slow one. That is the point of the report. A single store-wide number rarely fits every product, and this report lets the label follow how each category actually moves.

Merchants reach for this report when a plain stock list is not enough. It pairs the label with Inventory Value and Inventory Cost, so you can tell a low-stock bestseller apart from a low-stock item you can afford to let run out.

Which Fields Are Included in the Inventory Level Indicator Report?

These fields let you read stock health and the money behind it on the same line.

Field What it shows
Product Title The product the stock line belongs to.
Variant Title The specific version being counted, such as a size or colour, so labels apply at the variant level.
SKU The unique code for the variant, used to match the line to your purchasing and supplier records.
Product Status Whether the item is active, draft, or archived in Shopify, so you can separate live sellable stock from hidden items.
Custom Collections The manually built collection the product sits in, useful for reading stock health one collection at a time.
Inventory Level The High, Medium, or Low label applied to the line based on the thresholds you set.
Inventory Quantity The number of units currently in stock for that variant.
Inventory Value What that stock is worth at your selling price, calculated as quantity times price.
Inventory Cost What that stock cost you, calculated as quantity times unit cost.

You can customize the pre-made report by adding, removing, or rearranging fields, and by adjusting the High, Medium, and Low thresholds to match how each part of your catalogue sells.

Important Insights You Can Find in This Report

Which Low items are actually worth reordering first?

Filter to Inventory Level = Low, then read it against Inventory Value. A Low label on a high-value line is an urgent reorder, because every day it stays low is a bigger lost sale. A Low label on a cheap or fading product may be fine to let run down. The label tells you what is scarce; the value tells you what scarcity costs you.

Where is your cash sitting still?

Filter to Inventory Level = High and compare it with Inventory Cost. A High label on its own is not a problem. A High label on a high-cost item in a slow-selling collection is money locked on the shelf. Those are the lines to consider discounting or bundling before they tie up more of your buying budget.

Is one collection quietly carrying all your stock risk?

Group by Custom Collections and look at how the labels cluster. If one collection holds most of your Low labels while another holds most of your High, your buying is out of balance by category, not across the store as a whole. That points you to fixing purchasing rules for specific collections rather than adjusting stock everywhere.

THE ANALYST'S READ: The Signal Most Merchants Miss

The label is only as honest as your thresholds, and the item most worth watching is the one that keeps changing labels. Because the same Inventory Quantity can mean Low for a fast mover and High for a slow one, a product that flips between Medium and Low across scheduled runs is usually a fast seller sitting right on the edge of its threshold. That is the line most likely to sell out between reorders, even though no single run shows it as an emergency.

When you see that flicker, do not treat the latest label as settled. Compare the variant's Inventory Quantity against how quickly it normally sells, and consider tightening its threshold so it flags earlier. The report is at its most useful when the thresholds reflect real sell-through per category, not one number applied to the whole store.

How Can You Automate the Inventory Level Indicator Report?

The pre-made report comes with the columns already set, so you can save it as is or adjust the fields and thresholds first. Once saved, schedule it to email you daily, weekly, or monthly so you never rebuild it by hand, and set it to auto-send to your team, VA, or supplier so everyone works from the same stock picture.

You can also export it to Excel, CSV, or PDF, or push it to Google Sheets or Google Drive. Scheduled runs will only send when there is something to report, so a delivery in your inbox means there is stock that needs attention.

Frequently Asked Questions

What do High, Medium, and Low mean in this report?

They are labels applied to each line based on the quantity thresholds you set, not fixed Shopify values. High means plenty of stock, Low means it is running down, and Medium sits in between.

Can two products with the same quantity get different labels?

Yes. If you set different thresholds for different collections or categories, a fast seller can read Low while a slow mover reads High at the same unit count. The label follows how you buy and sell, not the raw number alone.

How is this different from the Low Stock Product report?

The Low Stock Product report lists only items that fall under a single threshold. This report labels your whole catalogue as High, Medium, or Low in one view, so you see overstock and understock together, not just what is running out.

Can I change the thresholds?

Yes. The Inventory Level thresholds are editable, so you can set them per category to match how each part of your store moves. The step-by-step setup is covered in the Inventory Level Indicator guide.

Does the report show value and cost as well as the label?

Yes. Inventory Value shows what stock is worth at your selling price, and Inventory Cost shows what it cost you. Reading both alongside the label is what tells you which High or Low items matter most in money terms.

Can I filter it to one collection or location?

Yes. You can filter by collection, status, or location to narrow the report before saving, which is useful when you want to read stock health for one part of the store at a time.

Report Not Found
Let's create it!
Your request is in! Check out all reports with the button below.
* Error. Please input correct email

Related Reports

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 makedata-backed decisions to grow your business.

Field What it shows
Date The date associated with the report row.