How to Export Orders from Shopify (2025 Guide)
Need to export your Shopify orders for accounting, reporting, or migration? This guide walks you through the exact steps to download your order data as CSV, with tips for preparing it for QuickBooks import.
Open Orders in Shopify Admin
Log into your Shopify admin panel and click 'Orders' in the left sidebar.
Go to admin.shopify.com and sign in with your store credentials.
In the left navigation menu, click Orders. You'll see all your orders listed with their status, customer name, and total.
Filter Orders by Date or Status
Use filters to select exactly which orders you want to export.
Click the Filter button above your order list. You can filter by:
- Date range — Select start and end dates
- Payment status — Paid, Pending, Refunded
- Fulfillment status — Fulfilled, Unfulfilled, Partial
- Sales channel — Online Store, POS, etc.
Click the Export Button
Click 'Export' in the top right corner of the Orders page.
The Export button is located in the upper right, next to the search bar. A modal will appear with export options.
Choose Export Scope
Select which orders to include in your export.
Shopify offers three export scopes:
- Current page — Only the orders visible on screen (50 per page)
- All orders matching filter — Everything that matches your current filters
- All orders — Your entire order history
- Selected X orders — Only orders you've manually selected with checkboxes
Select CSV Format
Choose 'CSV for Excel, Numbers, or other spreadsheet programs'.
Shopify offers two formats:
- CSV for Excel — Standard CSV format (choose this one)
- Plain CSV file — Same data, different encoding
Both work for QuickBooks import, but 'CSV for Excel' handles special characters better.
Download Your Export
Shopify emails you a download link when the export is ready.
For small exports (under 1,000 orders), the download starts immediately.
For larger exports, Shopify processes the file in the background and emails you when it's ready. This can take a few minutes.
Check your email for a message from Shopify with the subject "Your export is ready".
Convert for QuickBooks
Upload the CSV to SpreadsheetBroccoli for instant QuickBooks formatting.
Shopify's CSV format doesn't match what QuickBooks expects. Our converter handles:
- Date format conversion (ISO → MM/DD/YYYY)
- Multi-line order aggregation
- Currency formatting
- Customer name standardization
Understanding Shopify Export Columns
Key Columns in Shopify Orders Export
| Column Name | Description | Example | QuickBooks Use |
|---|---|---|---|
Name |
Order number with # prefix | #1001 | RefNumber |
Created at |
Order timestamp (ISO 8601) | 2025-01-15T10:30:00-05:00 | TxnDate |
Total |
Order total amount | 149.99 | TotalAmount |
Subtotal |
Amount before tax/shipping | 129.99 | ItemAmount |
Shipping |
Shipping charges | 10.00 | ShippingAmount |
Taxes |
Tax amount | 10.00 | TaxAmount |
Billing Name |
Customer name | John Smith | Customer |
Financial Status |
Payment status | paid | Filter criteria |
Lineitem name |
Product name (one per row) | Widget Pro | Description |
Multi-item orders create multiple rows. Our converter aggregates these into single transactions.
Common Export Issues
Export button is grayed out
You need Staff or Owner permissions. Ask your store admin to grant export access.
Export is taking too long
Large exports (10,000+ orders) can take 5-10 minutes. Check your email for the download link.
File won't open in Excel
Try opening Excel first, then use File → Import instead of double-clicking the CSV.
Special characters look wrong
The file uses UTF-8 encoding. In Excel, use Data → Get Data → From Text/CSV and select UTF-8.
Missing columns in export
Shopify exports all columns by default. If columns appear blank, that data doesn't exist for those orders.
What's New in 2025 Exports
Shopify updated their export format in January 2025. Key changes:
- Column renames: "Billing Name" is now "Customer Name"
- New columns: "Duty" (for international orders), "Discount Allocation"
- Date format: Now includes timezone offset in ISO format
Our converter handles both old and new formats automatically.
Have your Shopify export ready?
Convert to QuickBooks Now