What Is the Shipping Report?
The Shipping Report brings order details, products, shipping addresses, and shipment status into one view. Use it to review where orders are going and follow up on fulfillment progress without gathering those details separately.
Choose a reporting period to review the records you need. Product Name and Variant SKU provide item detail alongside Order Name, so an order with multiple products may appear on more than one row. Check the row structure before counting orders or totaling shipping amounts.
Report Overview
- Report type and period
- Fulfillment Reports; review the date range you select.
- Data included
- 19 fields covering orders, products, shipping amounts, recipient details, and shipment status.
- Best for
- Dispatch reviews, destination checks, and customer service follow-ups.
- Export formats
- Excel, CSV, TXT, or PDF.
- Automation
- Schedule email delivery daily, weekly, or monthly.
What Can You Learn from Your Shipping Details?
1. Which orders need a fulfillment review
Review Shipping Fulfillment and Shipment Status alongside Order Name to identify records that need investigation. Use the recorded status as the starting point for a check.
Example: A hypothetical order still shows a pending shipment status during your morning review.
What you can do: Open the order and confirm the next fulfillment step.
2. Where your orders are being sent
Shipping City, Shipping State, and Shipping Country help you organize a destination review. Count distinct order names when comparing order volumes.
Example: A hypothetical weekly export contains several orders going to the same state.
What you can do: Filter that destination and share the relevant orders with your dispatch team.
3. Which products are part of a shipping query
Product Name, Variant SKU, and Net Quantity give customer service teams item context when checking an order. This helps distinguish products within the same purchase.
Example: A hypothetical customer asks about one SKU in a three-product order.
What you can do: Find the order and match the SKU before responding.
What Should You Check First in This Report?
Start with the fields that help you decide which records need attention.
- Shipment Status and Shipping Fulfillment: Review the values recorded and investigate entries that need follow-up.
- Date: Confirm the report’s date basis and selected period before treating a record as old or overdue.
- Shipping address: Check for blank destination details or missing apartment information that may need confirmation.
- Order Name and Variant SKU: Match the right order and product before counting records or answering a shipping query.
When Should You Use This Report?
| When to Use It | How It Helps |
|---|---|
| Reviewing dispatch and shipment status | Review fulfillment details and shipment status together with order references. |
| Responding to a shipping inquiry | Find recipient, destination, and product details for a specific order. |
| Reviewing shipping destinations | Group orders by city, state, or country to understand shipping destinations. |
| Scheduling shipping follow-up handoffs | Send a recurring shipping export to the people handling order follow-ups. |
How to Create This Report in Data Export
Start with the premade Shipping Report so the shipping fields are already selected.
- Open Data Export and find the premade Shipping Report.
- Open the report and review the order, product, address, and status columns.
- Set your date range, confirm what Date represents, and apply available filters for the records you need.
- Save the report and download it in Excel, CSV, TXT, or PDF as needed.
- For recurring reviews, schedule daily, weekly, or monthly email delivery to the team members who need it.
Make the Most of This Report
Use these checks to make each shipping export easier to review and share.
01 / ORDER COUNTS
Count distinct orders: One order may have several product rows. Use unique Order Name values when counting orders.
02 / SHIPPING TOTALS
Check repeated amounts: Confirm how Shipping appears across product rows before adding it up.
03 / ADDRESS FORMATTING
Preserve postal codes: Import Shipping Zip and Shipping Phone as text in spreadsheets to retain leading zeros and formatting.
04 / TEAM ACCESS
Share selectively: Remove recipient phone and address fields when the receiving team only needs order references and status.
Frequently Asked Questions
Can I export Shopify shipping addresses?
Yes. The report includes recipient names, two address lines, city, state, country, postal code, and phone number where those details are recorded.
Can I review orders that still need to ship?
Use Shipping Fulfillment and Shipment Status to find records that need review. Apply the relevant available status filter and confirm the order’s current details before taking action.
Does the Shipping field show my carrier costs?
Do not treat Shipping as a carrier invoice or label cost. Confirm the field’s definition and how amounts are displayed across product rows before using it in a cost calculation.
Can I schedule the Shipping Report for my team?
Yes. Save the report and set daily, weekly, or monthly email delivery. Choose recipients who need access to the shipping information included.
Does each row represent a separate shipment?
Do not assume so. The report combines order and product fields; check its grouping before counting rows as orders, packages, or shipments.
