Inventory Transfers Report for Shopify
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.
5 from 1,800+ merchants
2,000+ data fields
Trusted by 40,000+ Shopify stores
Updated June 2026
Why this report matters
The moment you run more than one location, stock starts moving between them — warehouse to store, store to store, warehouse to 3PL. Each of those movements is a transfer, and each is a chance for stock to go missing, arrive short, or sit in limbo as "in transit" for longer than it should.
The Inventory Transfers Report gives you a single view of every movement: what was sent, where it came from, where it’s going, its current status, and how much actually arrived versus how much was rejected. That visibility is what keeps inventory counts accurate across locations and prevents the overselling that happens when stock is assumed to be somewhere it isn’t.
It also turns transfer history into a performance metric. By tracking the gap between when a transfer ships and when it’s received, you can measure internal lead times and spot the routes or teams that consistently run slow.
What’s included in the report
Transfer Name
The name or reference number of the transfer.
Transfer Status
Where the transfer is in its lifecycle.
Example: Draft · Ready to Ship · In Transit / Shipped · Received
Heads up: Stock in a Ready-to-Ship transfer is reserved at the origin — it’s committed and shouldn’t be counted as freely available there.
Transfer Note / Reason
The note or reason attached to the transfer, useful for context and reconciliation.
Route
Origin Location
The location the stock is moving from.
Example: NY Warehouse
Destination Location
The location the stock is moving to.
Example: LA Flagship Store
Quantities & line items
Product / Variant / SKU
The items in the transfer, down to variant and SKU.
Received Quantity
Units accepted into the destination location.
Rejected Quantity
Units rejected at receiving — damaged, mismatched, or unexpected.
Heads up: A persistent gap between sent and received quantities is your early warning of loss, mis-picks, or damage in transit.
Timing
Expected Arrival Date
The planned arrival date set when the transfer was created.
Shipped / Received Dates
Formula: Internal Lead Time = Received Date − Shipped Date
When the transfer shipped and when it was received — the basis for internal lead-time measurement.
Staff member · Tracking number · Carrier · Tags · Linked purchase order · Variant cost
Who uses this report
01. Multi-location retailers balancing stock
02. Inventory controllers reconciling receipts
03. Warehouse ops measuring internal lead time
04. Finance linking transfers to POs
How to read the report
Patterns to look for first:
- Stuck in transit. Transfers sitting in Shipped status well past their expected arrival date — chase these before stock is assumed lost.
- Sent vs. received gaps. A recurring shortfall between sent and received points to loss, theft, or damage on a route.
- High rejected quantities. Frequent rejections suggest packing, picking, or handling problems at the origin.
- Lead-time outliers. Routes with consistently long ship-to-receive times need attention or more realistic planning.
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 Transfers from the Inventory category.
- Choose a date range. pick the window of transfers to review — last 30 or 90 days is typical.
- Apply filters. narrow by status (Draft, Ready, Shipped, Received), origin, destination, tag, or reason.
- Customize columns. add staff member, tracking number, carrier, or linked purchase order as needed.
- Run the report. every transfer and its line items appear with ordered, received, and rejected quantities.
- Export or schedule. export to Google Sheets or CSV, or schedule a weekly transfers summary to ops.
Customization & filters
- Filter by status — Draft, Ready, Shipped, or Received.
- Filter by origin / destination — focus on a specific route.
- Add internal lead time — measure ship-to-receive duration.
- Add staff member — attribute transfers to the team handling them.
- Link to purchase orders — reconcile against procurement.
- Group by route — spot consistently slow lanes.
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 stock moving between your Shopify locations — showing each transfer’s origin, destination, status, and the quantities sent, received, and rejected.
The full lifecycle: Draft, Ready to Ship, In Transit / Shipped, and Received. You can filter to any status.
Yes. Each transfer’s line items show received and rejected quantities, so you can reconcile what arrived against what was sent.
Benefits
Granular Product-Level Insights
.png)
Discount Analysis
Order Tracking
Related Reports
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 Status
A comprehensive overview of product inventory, detailing the quantity available for products that are live, in draft, or have been archived.
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 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 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 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 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.
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 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.
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 by Location
A report organized by inventory locations, detailing products and variants on hand, with a breakdown of the value for each product.
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.
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.
.png)
.png)