← Shopify Reporting Community
Order Reports

How do I export Shopify orders with line items?

✓ Report Pundit Answer
2430
8
August 24, 2026
QUICK ANSWER

Export orders at line-item level when you need one row per product or variant instead of one row per order.

Official answer

Yes. For line-item reporting, each product or variant in an order should be returned as its own row rather than collapsing the whole order into one record.

Useful fields include Order Name, Order Date, Product Title, Variant Title, SKU, Quantity, Gross Sales, Discounts, Net Sales, Fulfillment Status, Customer Email, and Shipping Country. Shopify's standard CSV can be enough for basic exports, but custom reporting is useful when you need a specific row structure, additional fields, calculations, or scheduled delivery.

Before exporting, decide whether order-level values such as shipping and tax should repeat on every line or appear only once. That choice prevents totals from being overstated when the file is analyzed later.

Follow-up questions

Can I include SKU and barcode in the same line-item export?

Yes. SKU and barcode are variant-level fields and can sit beside product, variant, quantity, price, and other line-item fields in the same export.

How do I avoid duplicated shipping and tax when exporting line items?

Order-level values can repeat when one order becomes several line-item rows. Use a rule that places the order-level amount on one row only, or aggregate carefully after export.