Orders Report: Exporting Sales Order and Shipment Data
Use the Orders Report to export all Sales Order and Shipment data, including tracking numbers and shipment status. This article explains how to generate the report and correctly handle multi-line item orders in your exported data to avoid calculation errors.
How to Export Orders
1In the top navigation, click Reports → Orders Report.
2Specify the Date Range.
3Optional: Use the dropdowns to filter by Channel and Order Status, or leave these blank to export all orders in the date range.
4Click Download to generate and save the file.
How Multi-Line Orders Appear in Your Export
The Orders Report creates one row per line item, not one row per order. If an order contains multiple products, the same Order ID will appear on multiple rows — once for each item. Importantly, the Order Subtotal shown on each row reflects the full order total, not just that item's value.
Export Structure:
- Single-item orders: One row per order
- Multi-item orders: Multiple rows with the same Order ID — one row per item
- Order Subtotal column: Shows the full order total on every row, not the individual item amount
Example: Multi-Line Order in the Export
Order ID 12345 containing 2 items appears as:
Row 2: Order ID 12345 | Item B | Order Subtotal: $50.00
Correct Order Subtotal: $50.00 — not $100.00. Summing both rows would double-count this order.
Data Analysis Best Practices
Use the methods below to correctly analyze multi-line order data and avoid inflated metrics.
For Order Count Analysis
- Count unique Order IDs only — not total row count
- Use COUNTUNIQUE or remove duplicate Order IDs before counting
- Use a pivot table grouped by Order ID in Excel or Google Sheets
For Revenue Analysis
- Sum order totals by unique Order ID only
- Use SUMIF or a pivot table to group by Order ID before totaling
- Filter for distinct Order IDs before calculating averages or totals
For Item-Level Analysis
- Use all rows as-is — each row represents one item/SKU sold
- No deduplication needed for product performance or inventory analysis
Common Mistakes to Avoid:
- Summing the Order Subtotal column directly — this inflates revenue for multi-line orders
- Counting total rows as individual orders — this inflates order count
- Calculating average order value without removing duplicate Order IDs first
- Using total row count for order volume metrics
Frequently Asked Questions
Why do I see the same Order ID multiple times in my export?
This is expected behavior for multi-line orders. Each row represents one item within that order. The Order ID repeats so all items from the same purchase are linked together.
My revenue totals seem too high — what's wrong?
You're likely counting multi-line orders multiple times. Use SUMIF or a pivot table to sum the Order Subtotal by unique Order ID only.
How do I count my actual number of orders?
Count unique Order IDs, not total rows. Use the COUNTUNIQUE function or create a pivot table grouped by Order ID.
Can I get one row per order instead of one row per item?
The Orders Report always exports at the item level. Use the analysis methods above to consolidate by Order ID for order-level reporting.