Inventory Shipments Report for Shopify
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.
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
What you ordered and what actually lands on your shelves are rarely identical. Shipments arrive short, arrive damaged, or arrive late — and if you’re not tracking the gap, you discover it only when a customer orders something you thought you had. Every undetected discrepancy is either lost sales or money paid for goods you never received.
The Inventory Shipments Report closes that gap. It tracks each inbound shipment from dispatch to receipt, breaking quantities into shipped, received, accepted, and rejected, and calculates an acceptance rate so you can see at a glance how clean each delivery was. Expected arrival dates let you plan fulfillment around incoming stock instead of guessing.
Over time, the same data becomes a supplier scorecard. Acceptance rates and on-time performance by vendor tell you which suppliers are reliable and which keep costing you in shortfalls and rejects — hard evidence for your next contract negotiation.
What’s included in the report
Shipment Name
The shipment’s name or reference, usually tied to a transfer or purchase order.
Shipment Status
The current state of the inbound shipment.
Example: Pending · In Transit · Received · Partially Received
Transfer / PO Reference
The transfer or purchase order the shipment belongs to.
Route & destination
Origin
The supplier or origin location the shipment came from.
Destination Location
The location receiving the shipment.
Example: NY Warehouse, ShipBob East
The quantity breakdown
Shipped Quantity
Units the supplier dispatched.
Received Quantity
Units that physically arrived.
Heads up: Received less than shipped is your first discrepancy flag — either a short-ship or loss in transit.
Accepted Quantity
Units accepted into sellable stock after inspection.
Rejected Quantity
Units rejected at receiving — damaged, defective, or not matching the order.
Example: Of 100 received, 8 arrive damaged → 92 accepted, 8 rejected.
Acceptance Rate
Formula: Accepted Quantity ÷ Received Quantity × 100
The share of received stock that made it into sellable inventory — your single best per-shipment quality signal.
Example: 92 accepted of 100 received = 92% acceptance rate.
Timing
Expected Arrival Date
The planned arrival date — drives fulfillment and reorder planning.
Shipped / Received Dates
When the shipment left and when it was received; the basis for on-time and lead-time analysis.
Supplier / vendor · Staff member · Tracking number · Carrier · Variant SKU & title · Variant cost · On-time flag
Who uses this report
01. Receiving teams catching discrepancies
02. Procurement benchmarking suppliers
03. Ops planning around incoming stock
04. Finance reconciling goods received
How to read the report
Patterns to look for first:
- Acceptance rate below ~95%. A consistent quality problem with that supplier or route. Track it and raise it in your next review.
- Received well below shipped. Short-ships or transit loss. File claims promptly — the window to dispute is limited.
- Repeatedly late arrivals. A supplier missing expected dates forces you to carry more safety stock. Quantify the cost.
- Rejections clustered by supplier. When rejects concentrate with one vendor, it’s a sourcing problem, not bad luck.
How to build the report in Report Pundit
Under 5 minutes from install to insight. No code, no SQL.
- Install Report Pundit. from the Shopify App Store — 14-day free trial, no card required.
- Open Pre-built Reports. and select Inventory Shipments from the Inventory category.
- Choose a date range. pick the window of shipments to review — last 30 or 90 days for supplier benchmarking.
- Apply filters. narrow by supplier, destination location, shipment status, or transfer/PO reference.
- Customize columns. add acceptance rate, on-time flag, carrier, tracking number, or variant cost.
- Run the report. every shipment appears with shipped, received, accepted, and rejected quantities.
- Export or schedule. export to Google Sheets or CSV, or schedule a weekly shipments summary and a monthly supplier scorecard.
Customization & filters
- Filter by supplier — build a per-supplier performance view.
- Filter by destination — see receiving by location.
- Add acceptance rate — the headline quality metric.
- Add on-time flag — expected vs. actual arrival.
- Group by supplier — turn shipments into a supplier scorecard.
- Add variant cost — value the discrepancies in dollars.
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 tracks inbound shipments into your locations — shipped, received, accepted, and rejected quantities, plus acceptance rate — for each shipment and supplier.
Accepted Quantity ÷ Received Quantity × 100. It tells you what share of what arrived actually made it into sellable stock — the cleanest per-shipment quality signal.
Received is everything that physically arrived. Accepted is what passed inspection into sellable stock. Rejected is what was turned away as damaged, defective, or wrong. Received = accepted + rejected.
Benefits
.svg)
Granular Product-Level Insights
.png)
Discount Analysis
.svg)
Order Tracking
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.
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 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 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 Status
A comprehensive overview of product inventory, detailing the quantity available for products that are live, in draft, or have been archived.
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 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 level Indicator
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.
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 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 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 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
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
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.