Exporting a List of My Orders
- Go to your store's admin area.
- Click "Sales" in the dashboard navigation.
- Click the checkbox to the left of each Order you wish to export. You can search and page through Orders while continuing to select them. The Orders you select will be remembered. Or, don't select any Orders to include all Orders in the current search across all pages.
- After selecting the Orders you'd like to export, click the "Export" button at the top left.
In a moment, your browser will begin downloading a CSV file of the selected Orders.
One Row for Each Order (CSV)
Every row in the in the default "One Row for Each Order (CSV)" export file will have the following columns (see below for different export options):
- Number
- Gateway
- Transaction
- State
- Pending Reason
- Seller Email
- Customer Email
- Customer First Name
- Customer Last Name
- Shipping Address Attention
- Shipping Street Address 1
- Shipping Street Address 2
- Shipping City
- Shipping State
- Shipping Postal Code
- Shipping Country
- Total Item Count
- Digital Only
- Item(s) Summary
- Subtotal
- Shipping Amount
- Service Fee
- Tax
- Tax Amount
- Discount
- Discount Code
- Discount Amount
- Total Price
- Currency Code
- Order Date
- Shipping Date
- Shipping Method
- Shipping Tracking Number (How To Add Tracking Number)
- IP Address
- IP Address Country (As of January 5th, 2015)
- Customer Declared Country (As of January 5th, 2015; For taxable, digital only orders, with mismatched country evidence collected for VAT purpose.)
One Row for Each Order Item (CSV)
An optional export format called "One Row for Each Order Item (CSV)" is also available. To enable this optional export, click the down arrow attached to the export button in the "Sales" area of your dashboard, click "Export Preferences", enable the export format, and click save.
If an order has multiple line items, each line item will get its own row in the "One Row for Each Order Item (CSV)" export. The first row will have all of the order details, while subsequent rows will have limited details. Here is a list of all columns available in this export option:
- Number
- Gateway
- Transaction
- State
- Pending Reason
- Item Quantity
- Item Catalog Number
- Item Name
- Item Type (One of Shipping Profile Name, Digital, Bundle, Ticket, VIP Package)
- Item Unit Price
- Item Total Price
- Seller Email
- Customer Email
- Customer First Name
- Customer Last Name
- Shipping Address Attention
- Shipping Street Address 1
- Shipping Street Address 2
- Shipping City
- Shipping State
- Shipping Postal Code
- Shipping Country
- Total Item Count
- Digital Only
- Order Subtotal
- Shipping Amount
- Service Fee
- Tax
- Tax Amount
- Discount
- Discount Code
- Discount Amount
- Total Price
- Currency Code
- Order Date
- Shipping Date
- Shipping Method
- Shipping Tracking Number
- IP Address
- IP Address Country (As of January 5th, 2015)
- Customer Declared Country (As of January 5th, 2015; For taxable, digital only orders, with mismatched country evidence collected for VAT purpose.)
"Custom CSV Exporter"
- Sales
- Export
- Manage Templates (if this is your first time)
The Custom Exporter allows you to pick and choose exactly what columns you want in the export. You can also choose between a single row for an entire order, or each line item in it's own row. You can also easily remove digital items from this list if you're using the export for a Shipping Service Integration that we currently don't have an App for.
The template section allows you create and save multiple templates for future use. No need to create the export each time you want it.
Please Note: Unit vs Total. For example Item Unit Price is the price of a single version of the Item. The Item Total Price is the quantity multiplied by the Item Unit Price. All other Unit and Total options follow this same logic.
