Inventory Replenishment Report for Shopify
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.
5 from 1,800+ merchants
2,000+ data fields
Trusted by 40,000+ Shopify stores
Updated June 2026
.png)
.png)
.svg)
.svg)
.svg)
Why this report matters
Reordering is where inventory management succeeds or fails. Order too late and you stock out during peak demand; order too early or too much and you trap cash in stock that sits. The hard part is that the right reorder moment is different for every product — it depends on how fast each one sells and how long the supplier takes.
The Inventory Replenishment Report turns that judgment into a list. It compares each product’s current stock against its reorder point, weighs how quickly it’s selling, and — crucially — subtracts stock that’s already inbound so you don’t double-order. The result is a clean, prioritized "reorder now" list you can hand straight to procurement.
Because it’s per-location, a product can flag for replenishment at your busy store while staying healthy at the warehouse — exactly the granularity multi-location retailers need to avoid both stockouts and overstock.
What’s included in the report
Product Title
Name of the product.
Variant Title
The variant — replenishment is almost always a variant-level decision.
SKU
Unique identifier for the purchase order.
Location
The location the replenishment need applies to.
Example: A variant can flag "reorder" at flagship_store while warehouse stock is fine.
Demand & stock
Inventory Quantity
Current units on hand at that location.
Total Units Sold
Units sold over the monitored period — the basis for velocity.
Sales Velocity
Formula: Total Units Sold ÷ Days in period
Average units sold per day — how fast this item moves.
Incoming Stock
Units already on a purchase order or transfer and due to arrive.
Heads up: This is what separates a replenishment report from a plain low-stock list. An item below its reorder point with enough stock already inbound should not be reordered again — the report accounts for that.
The replenishment trigger
Reorder Point
The merchant-defined stock level at which an item should be reordered. You set this per product, type, or globally.
Example: Reorder Point = 40 means "when on-hand minus incoming drops to 40, reorder."
Days to Replenish
Formula: Inventory Quantity ÷ Total Units Sold × Day difference + 1
Estimated days until current stock runs out at the present pace.
Replenishment Date
Formula: Current Date + Days to Replenish
The date by which a reorder should be placed to avoid a stockout.
Replenishment Status
Whether the item needs reordering now, soon, or not yet — your sort-and-act column.
Example: Reorder Now · Reorder Soon · OK
Vendor · Lead Days · Safety Stock · Suggested Reorder Quantity · Product Type · Inventory Cost
Who uses this report
01. Buyers building the daily/weekly PO
02. Multi-location retailers replenishing per store
03. Procurement teams timing orders to lead time
04. Founders running set-and-forget replenishment
How to read the report
Patterns to look for first:
- Reorder Now + fast velocity. Top priority — these run out soonest. Reorder or transfer immediately.
- Below reorder point but high incoming. Do not reorder. Stock is already on the way; the report flags this so you don’t over-buy.
- Replenishment Date inside vendor lead time. You’re already late — the order won’t arrive before you run out. Expedite or accept a short gap.
- Per-location splits. A "reorder" flag at one store with healthy warehouse stock is a transfer, not a PO.
How to build the report in Report Pundit
A one-time setup of your reorder points, then under 5 minutes per run.
- Install Report Pundit. from the Shopify App Store — 14-day free trial, no card required.
- Open Pre-built Reports. and select Inventory Replenishment from the Inventory category.
- Set your reorder points. define the trigger level globally, per product type, per vendor, or per SKU. Optionally add lead days and safety stock for sharper timing.
- Choose the velocity window. pick the period used to calculate sales velocity — 30 days is typical; use longer for seasonal smoothing.
- Apply filters. narrow by location, vendor, or product type to focus the list.
- Customize columns. add Suggested Reorder Quantity, Lead Days, or Inventory Cost to make the list PO-ready.
- Run the report. replenishment needs are calculated per variant and per location, net of incoming stock.
- Export or schedule. push Reorder Now items to Google Sheets daily, or email each vendor their list automatically
Customization & filters
- Set reorder points — globally, per type, per vendor, or per SKU.
- Add lead days and safety stock — for lead-time-aware timing.
- Filter by vendor — build supplier-ready reorder lists.
- Filter by location — replenish per store or warehouse.
- Add Suggested Reorder Quantity — turn the flag into an order quantity.
- Schedule daily — auto-deliver the Reorder Now list to ops.
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 flags which products need reordering now, based on sell-through velocity and your reorder point, while accounting for stock already inbound and showing needs per location.
A low-stock report just lists items below a threshold. Replenishment adds velocity and — importantly — subtracts incoming stock, so you don’t reorder items that already have a PO on the way.
Inventory Quantity ÷ Total Units Sold × Day difference + 1, which estimates how many days current stock lasts at the present pace. The Replenishment Date is today plus that figure.
Benefits
.svg)
Granular Product-Level Insights
.png)
Discount Analysis
.svg)
Order Tracking
Related Reports
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 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 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.
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 by Location
A report organized by inventory locations, detailing products and variants on hand, with a breakdown of the value for each product.
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 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
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.
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 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 Status
A comprehensive overview of product inventory, detailing the quantity available for products that are live, in draft, or have been archived.
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.
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.