What Is the Low Stock Product Report?
The Low Stock Product report identifies Shopify products and variants whose inventory quantity falls below a defined threshold. It brings product names, SKUs, status, quantity, price, and inventory value and cost into one view so you can prepare a replenishment review.
Review each listed variant separately to see which size, color, or version needs attention. Use the quantity and product status together to decide which items to investigate before placing a reorder. The inventory figures describe the stock shown when the report is generated; they do not establish historical stock levels or how many days the stock will last.
Report Overview
- Report type
- Inventory Reports, focused on products below a defined stock threshold.
- Reporting basis
- Inventory quantities shown when generated, rather than sales over a selected period.
- Data included
- Nine fields covering product identity, status, quantity, selling price, and inventory value and cost.
- Best for
- Routine replenishment checks and sharing a low-stock list with operations or purchasing teams.
- Export and delivery
- Excel, CSV, TXT, or PDF; scheduled email delivery daily, weekly, or monthly.
What Can You Learn from Your Low Stock List?
1. Which variants need a stock check
Use Inventory Quantity alongside Product Title, Variant Title, and SKU to identify the exact item that needs attention. Other variants of the same product may have different stock levels.
Example: Hypothetical: A blue shirt in medium shows two units while the small variant is absent from the low-stock list.
What you can do: Verify the medium variant’s physical stock before preparing a reorder.
2. Which low-stock items still need replenishment
Product Status helps separate active products from items that may no longer be part of your range. A low quantity alone does not mean you should buy more.
Example: Hypothetical: A discontinued mug has one unit left and an archived product status.
What you can do: Confirm your assortment plans before including the mug in a purchasing request.
3. Which cost records need a review
Review Product cost and Inventory Cost alongside quantity to spot missing cost information in your low-stock list. These fields describe recorded stock cost, not the total cost of a future purchase.
Example: Hypothetical: A low-stock accessory has a selling price but no recorded product cost.
What you can do: Update the cost record before using the export in a purchasing budget.
What Should You Check First in This Report?
Start with the settings and fields that determine whether the list is useful for your next stock review.
- Threshold and filter rule: Confirm the quantity limit and whether the rule includes or excludes items exactly at that limit.
- Inventory Quantity and SKU: Sort by quantity, then check the identifiers so similar variants are not confused.
- Product Status: Review active products separately from archived or discontinued items before deciding what to replenish.
- Product cost and Inventory Cost: Check blank or unexpected values before sharing cost information with purchasing.
When Should You Use This Report?
| When to Use It | How It Helps |
|---|---|
| Checking products nearing stock depletion | Review products nearing stock depletion during a regular inventory check. |
| Preparing a physical check of low-stock SKUs | Match low quantities to specific SKUs for a physical stock check. |
| Assessing variants for replenishment | Prepare a list of variants to assess for replenishment alongside supplier information held separately. |
| Reviewing low-stock products in the assortment | Review low-stock items by product status before deciding which products should remain in the range. |
How to Create This Report in Data Export
Start with the premade Low Stock Product report so the supplied columns are already available.
- Open Data Export and find the Low Stock Product premade report.
- Open the template and review its nine fields, including Inventory Quantity, SKU, and Product Status.
- Check the quantity threshold and filter rule. Adjust the supported filters and columns to match your stock review.
- Save and generate the report, then download it in the format your team needs.
- For repeat checks, schedule email delivery daily, weekly, or monthly and select the intended recipients.
Make the Most of This Report
Use these checks to keep each low-stock export practical and easy to interpret.
01 / THRESHOLD
Record the rule: Include the quantity threshold in your review notes so your team understands why each item appears.
02 / VARIANT MATCHING
Check the SKU: Use SKU with the variant title when matching the export to physical stock or purchasing records.
03 / REVIEW FREQUENCY
Generate a fresh list: Recheck stock before ordering; an earlier export may no longer reflect the quantities you need.
04 / SHARING
Share the right columns: Remove cost fields from team copies when recipients only need product identifiers and quantities.
Frequently Asked Questions
What quantity counts as low stock?
Low stock means the quantity falls below the threshold defined in the report. Check the saved filter for the exact limit and boundary rule; the supplied specification does not state a default number.
Can I identify low stock for a specific size or color?
Yes. Variant Title and SKU help you identify the specific version associated with the listed quantity.
Does this report tell me how much to reorder?
The supplied fields do not calculate a reorder quantity or days of stock remaining. Combine the low-stock list with demand, supplier lead times, and stock already on order before deciding how much to buy.
Can I export and email the report automatically?
Yes. The supplied setup supports Excel, CSV, TXT, and PDF exports, with daily, weekly, or monthly scheduled email delivery.
Does it show stock by warehouse or store location?
Location is not one of the nine supplied columns. Ask Data Export support about a location-specific view if you need to decide where stock should be replenished.
