Low Stock Product Report for Shopify
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
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 Low Stock Product Report matters
Out-of-stock is too late. By the time a product hits zero, you've already lost sales - possibly for the entire lead time of your next reorder. The low-stock list is where you catch it earlier, while there's still time to act.
For a typical Shopify merchant with a 14-day vendor lead time, that means triggering reorders when an item drops below 14 days of forward sales. Without a dedicated low-stock report, you're either checking manually every day or finding out about stock-outs from customer service tickets - neither scales.
The Low Stock Product Report turns reorder timing into a system: set the threshold once, schedule the report daily, and your inbox tells you what to reorder before stock-outs happen. Pair with the Inventory Reorder Point Report for a velocity-aware version of the same logic.
What's included in the report
Identification - Product Title · Variant Title · SKU
Stock & status - Inventory Quantity - Current units in stock (≤ your threshold).
Product Status - Active / Draft / Archived. Active is the urgent case.
Pricing & valuation - Product Price - For lost-sales math.
Inventory Value - Remaining stock at retail.
Inventory Cost - Remaining stock at cost.
Categorization - Product Type - Often used to set different thresholds per category.
Vendor · Location · Sales Velocity (last 30 days) · Inventory Days Remaining · Reorder Point · Suggested Reorder Quantity
Who uses this report - 4 scenarios
1. Daily replenishment teams
2. Buyers prioritizing reorders by velocity
3. Multi-location retailers planning location-specific transfers
4. Founders setting up "set-and-forget" reorder workflow
How to read the Low Stock Product Report
• Low + fast-mover = top priority. These will be out in days. Reorder immediately or transfer.
• Low + slow-mover = think first. Don't reflexively reorder. Maybe let it run out and reassess if the product is worth keeping.
• Low + Draft/Archived status = clean it up. Why is a Draft product low? Either re-activate or delete.
• Vendor cluster. Multiple top-velocity SKUs from one vendor running low simultaneously = vendor reliability issue, not a stocking issue.
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 Low Stock Product Report from the Inventory category.
- Set your threshold. Define what counts as Low - globally, per product type, per vendor, or per SKU. Most merchants start at 10-20 units globally and refine.
- 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
• Threshold setup - globally, per type, per vendor, or per SKU
• Filter by Vendor - group reorder lists for procurement
• Filter by Status = Active - focus on the urgent subset
• Filter by Product Type - different thresholds for different categories
• Add Sales Velocity - prioritize by movement speed
• Add Suggested Reorder Quantity - turn the alert into action
• Conditional alert: email Slack/team when a flagged SKU crosses threshold
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 listing every product and variant at or below your defined low-stock threshold, with SKU, vendor, status, and quantity - so you can act before items hit zero.
You define it during setup. Globally (e.g., "Low = under 10 units") or per product type, vendor, or SKU.
Daily for most stores; hourly for high-velocity DTC or marketplace operations. Schedule it to email automatically so you don't have to remember.
Benefits
Product Availability
Inventory Management
Ensure Stock Availability
Related Reports
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 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 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 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 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 by Location
A report organized by inventory locations, detailing products and variants on hand, with a breakdown of the value for each product.
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 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 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 Status
A comprehensive overview of product inventory, detailing the quantity available for products that are live, in draft, or have been archived.
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.
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.
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.