Export orders to a CSV file

You can export a CSV spreadsheet of your orders from the Orders page of your Shopify admin to see a broad overview of your complete order information.

Export orders by search or selection

To export a selection of orders as a CSV file:

  1. If needed, sort and filter your orders.

  2. From the Orders page, click Export:

    Export order button

  3. In the Export orders dialog, select the option for the orders that you want to export:

    Export modal search filter

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

    Export modal search excel

  5. Click Export transaction histories or Export orders to download the CSV file:

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

Did you know?

Your transaction history report is for captured payments only. Authorizations are not included in your transaction history CSV file.

Export orders by date

To export a CSV of your orders by a specific date range:

  1. From the Orders page, click Export:

    Export order button

  2. In the dialog, click Export orders by date.

  3. Set the Start Date and End Date for the orders you want to export:

    Export modal date select

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

    Export modal date csv

  5. Click Export transaction histories or Export orders to download the CSV file:

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

Did you know?

Exporting by date will export all the orders from that period.

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
Fulfilled at When fulfillment was completed for an order
Accepts Marketing Whether this customer accepts marketing from your store
Currency The currency the order was paid in
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 The discount code that was applied to the order
Discount Amount The amount of the discount applied to an order
Shipping Method The shipping method 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 from the customer's billing address, if entered. Otherwise, the first and last name from the customer's account.
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 the 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 canceled 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
Outstanding Balance The amount owing on the order if it was not paid in full
Employee The name of the employee that sold the order
Location The location of the POS that sold the order
Device ID The device ID of the POS used to sell the order
Id The line item variant ID
Tags The 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
Tax # Name The name of a line tax. Up to five line taxes are available.
Tax # Value The monetary amount of tax charged on a line tax.

Did you know?

In your order CSV file, orders with multiple line items show their additional line items on separate lines. Many of the fields are left blank to indicate that multiple items were purchased on the same order.

Transaction History CSV Structure

Header Definition
Order The checkout ID of a transaction. This number might be used by your payment gateway, but does not generally appear in your store admin
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 an authorization
Gateway The payment gateway that processed the transaction
Created At 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 a failure
Amount How much the transaction was for
Currency The currency the transaction was processed in
Card Type The brand of credit card used, if applicable.

Want to discuss this page?

Visit the Shopify Community

Ready to start selling online with Shopify?

Try it free