Export Orders and Transactions

AdminOrders

Exporting orders

You can export a CSV spreadsheet of your orders to see a broad overview of your complete order information.

Export currently shown orders

To export a CSV of orders you're currently viewing in your Admin:

1. Click Export in the header of the Orders page

#

2. From the pop-up, click to select Export currently shown orders

#

3. Select to export your orders for Excel, Numbers, or another spreadsheet program for editing, or as a plain CSV file

#

4. You can choose to Export orders or Export transaction history.

  • If you want to download your complete order information, click Export orders.
#
  • If you want to download your transaction information, click Export transaction history.
#

5. Your CSV will download directly to your computer from the Shopify admin.

Information

You can sort and filter your orders to show a specific set of orders to export.

Export orders by month or quarter

To export a CSV of your orders by a specific month or quarter:

1. Click Export in the header of the Orders page

#

2. From the pop-up, click Export orders by month or quarter.

#

3. Use the drop-down menus to select which month or quarter you want to export

#

4. Select to export your orders for Excel, Numbers, or another spreadsheet program for editing, or as a plain CSV file

#

5. You can choose to Export orders or Export transaction history.

  • If you want to download your complete order information, click Export orders
#
  • If you want to download your transaction information, click Export transaction history
#

6. You will receive an email with a link to download your CSV report.

Information

Exporting by month or by quarter will export all orders from those periods.

Order Export CSV Structure

Header Definition
Name The order number as it appears in your store Admin
Email The customer's email address
Financial Status Whether the order has been paid, authorized, refunded, etc.
Paid at When payment was captured for an order
Fulfillment Status Whether the order has been fulfilled, or is still pending fulfilment
Fulfilled at When fulfillment was completed for an order
Accepts Marketing Whether this customer accepts marketing from your store
Currency What currency the order was paid with
Subtotal The order's subtotal, before shipping and taxes
Shipping The total cost of shipping for the order
Taxes The amount of taxes charged on an order
Total The total cost of the order
Discount Code Which discount code was applied to the order
Discount Amount The amount of the discount applied to an order
Shipping Method Which shipping method was used to ship the order
Created at When the order was completed by the customer
Lineitem quantity The quantity of a line item (or product/variant from your products menu)
Lineitem name The name of a line item
Lineitem price The price of the line item
Lineitem compare at price The compare at price of the line item
Lineitem SKU The line item SKU
Lineitem requires shipping Whether the line item in the order requires shipping
Lineitem taxable Whether the line item was taxable
Lineitem fulfillment status Whether the item was fulfilled
Billing Name The first and last name of the customer
Billing Street The name of the street entered for billing address
Billing Address1 The full first line of the billing address -- e.g. "150 Elgin St."
Billing Address2 The full second line of the billing address -- e.g. "Suite 800". This is often empty
Billing Company The customer's company name. This is often empty
Billing City The customer's billing address city
Billing Zip The customer's billing address ZIP or Postal Code
Billing Province The customer's billing state or province
Billing Country The customer's billing country
Billing Phone The customer's billing phone number
Shipping Name The first and last name of the customer
Shipping Street The name of the street entered for shipping address
Shipping Address1 The full first line of the shipping address -- e.g. "150 Elgin St.
Shipping Address2 The full second line of the shipping address -- e.g. "Suite 800". This is often empty
Shipping Company The customer's company name. This is often empty
Shipping City The customer's shipping address city
Shipping Zip The customer's shipping address ZIP or Postal Code
Shipping Province The customer's shipping state or province
Shipping Country The customer's shipping country
Shipping Phone The customer's shipping phone number
Notes The notes included on the order
Note Attributes Any additional note attributes will be displayed here
Cancelled at The date and time the order was cancelled at
Payment Method How the order was paid for
Payment Reference The transaction's checkout ID. This number is not displayed in your store Admin
Refunded Amount The amount of any refund applied to the order
Vendor The line item product vendor
Id The line item variant ID
Tags Tags associated with the order
Risk Level The order's risk level
Source The order's source -- e.g. web, mobile, POS
Lineitem discount The total discount applied to a line item

Information

Orders with multiple line items will show on your order CSV with their additional line items on separate lines, with many of the fields left blank to indicate that mutliple items were purchased on the same order.

Transaction History CSV Structure

Header Definition
Order ID The checkout ID of a transaction. This number may be used by your payment gateway, but does not generally appear in your Shopify Admin
Order Name The order number associated with the transaction. This is the number shown on your Orders page
Kind The type of transaction, whether it was a sale, refund, or authorization
Gateway Which payment gateway processed the transaction
Date The date of the transaction, presented Y-M-D, time, and time zone difference from UTC/GMT
Status States whether the transaction was a success or failure
Amount How much the transaction was for
Currency What currency the transaction was processed in
Card Type What brand of credit card was used, if applicable

Ready to put what you've learned into action?

Build an online store with Shopify. Try it free.

Experience the future of retail now.

Shopify Point of Sale. Try it free.