What Is the Shopify Inventory Transfers Report?
The Shopify Inventory Transfers report brings transfers between your Shopify locations into one file. It shows where stock is coming from, where it is going, when the transfer was created, and the shipment status alongside total and shipped quantities.
In Data Export, the premade report shows one row per transfer and its shipment. Use it to prepare receiving teams, review outgoing stock movements, or share a dated transfer list with finance. A transfer with multiple shipments may appear across several rows, so check the row structure before adding quantities together.
Report Overview
- Reporting basis
- Transfer and shipment records as they stand when the report runs; Transfer Created identifies when the transfer began.
- Data included
- ID, Ship Name, Origin Name, Destination Name, Transfer Created, Ship Status, Total Quantity, and Shipped Quantity.
- Best for
- Receiving preparation, outgoing transfer reviews, and dated operational handoffs.
- Export formats
- Excel, CSV, TXT, JSON, PDF, or Google Sheets.
- Automation
- Hourly, daily, weekly, or monthly delivery to email, Google Sheets, Google Drive, FTP, or SFTP.
What Can You Learn from Inventory Transfer Data?
1. Which destinations need receiving preparation
Destination Name and Shipped Quantity help receiving teams review stock movements heading to their location. Check Ship Status to decide which shipment rows need attention.
Example: In a hypothetical export, the downtown store has two shipment rows with 80 units shipped between them.
What you can do: Send that store a filtered list before its receiving shift.
2. Which outgoing transfers need follow up
Review Origin Name, Transfer Created, and shipped quantities to find older records that need a shipping update. A creation date helps prioritize follow up but does not establish how long stock has been in transit.
Example: A hypothetical transfer created last week still shows zero units shipped.
What you can do: Ask the origin team to check the transfer and confirm the next shipping step.
3. What transfer records looked like at month end
A dated export preserves the transfer list available when the report ran. Finance can use it as a supporting record when checking stock movements, with receipt details checked separately.
Example: A hypothetical month-end file contains six transfer records that need receipt confirmation.
What you can do: Save the export with its generation date and send it for reconciliation.
What Should You Check First in This Report?
Review these four details before sharing the file or summarizing quantities.
- Ship Status: Use the shipment values shown in the report. Confirm their meaning before treating a row as dispatched, complete, or still awaiting action.
- Origin Name and Destination Name: Confirm each recipient receives the correct location rows.
- Transfer Created: Keep the date window broad enough to include older transfers that still need attention.
- Total Quantity and Shipped Quantity: Check how quantities repeat across shipments before summing them. Shipped units alone cannot establish units still in transit.
When Should You Use This Report?
| When to Use It | How It Helps |
|---|---|
| Preparing a location to receive stock | Shows shipment references, origins, and shipped quantities for that destination. |
| Reviewing outgoing transfers | Groups the relevant records by origin so the sending team can follow up. |
| Following up on older transfer records | Uses Transfer Created to identify records worth checking with the location team. |
| Preparing a month-end handoff | Provides a dated transfer list to review alongside receiving records. |
| Maintaining a shared transfer tracker | Delivers a scheduled file or Google Sheets export for routine operations reviews. |
How to Create This Report in Data Export
Start with the premade Inventory Transfers report and tailor the delivery to the team using it.
- Open Data Export in your Shopify admin and find the premade Inventory Transfers report.
- Review the eight columns and check a transfer with multiple shipments to understand the row structure.
- Choose the creation-date range and apply relevant origin, destination, and shipment-status filters.
- Save the report, then export it in the required format or send it to Google Sheets.
- Set an hourly, daily, weekly, or monthly schedule and choose the destination. Use a saved version for each team when its filters differ.
Make the Most of This Report
Set up a recurring export that is easy for each team to use.
01 / FOCUS THE FILE
Send each location its own rows so staff can quickly find relevant shipments.
02 / TIME THE DELIVERY
Schedule delivery before receiving or warehouse reviews, when the team can act on it.
03 / KEEP DATED COPIES
Keep dated month-end exports; rerunning later shows the records available at that later time.
04 / CHECK BEFORE IMPORTING
For automated warehouse imports, agree on the format and column order, then test a sample file first.
Frequently Asked Questions
Can I send each store only its incoming transfers?
Yes. Filter by Destination Name, save a version for the location, and schedule delivery to the relevant recipient.
Does the report show each product or SKU on a transfer?
No. These eight premade columns summarize transfer and shipment records. Ask Data Export support about a custom version if you need product or SKU details.
Does Shipped Quantity tell me how much stock is still in transit?
No. It shows units recorded as shipped, without a received-quantity field. Check receiving records before using the file to establish an in-transit balance.
Can I schedule a transfer file for a warehouse system?
Yes. The report can be delivered by FTP or SFTP in formats such as CSV, TXT, or JSON. Confirm the receiving system can import the agreed file structure.
Can I use an older creation-date range to recreate month end?
A creation-date filter alone does not recreate earlier shipment status or receipt activity. Save a dated export at the time of each close and check it against receiving records.