Exporting a List of My Orders

  1. Go to your store's admin area.
  2. Click "Sales" in the dashboard navigation.
  3. 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.
  4. 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.)