Export orders to a CSV file

You can export a comma-separated values (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

You can export orders along with their transaction histories or you can export only the transaction histories of your orders. The transaction histories that are included in your CSV file include the captured payments data only. Authorization data is not included in your exported transaction histories.

To export your orders as a CSV file:

  1. Sort and filter your orders.

  2. From the Orders page, click Export.

  3. In the Export orders window:

    1. Select the option for the orders that you want to export. For example, if you want to export your orders by date, then click Export orders by date and set the start and end dates for the orders that you want to export.
    2. Choose the format that you want to export your orders to:
  4. Click Export orders to download your orders including their order histories to the CSV file:

    • If you want to download your transaction information only, then click Export transaction histories.

Order export CSV structure

The following table describes the format of the CSV file that will be created when you export orders.

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.

Header Definition
Name The order number as it appears in your store admin
Phone The customer's phone number
Email The customer's email address
Financial Status Whether the order has been paid, authorized, refunded, and so on.
Paid at The date when the payment was captured for an order.
Fulfillment Status Whether the order has been fulfilled or is still pending.
Fulfilled at The date when the fulfillment was completed for an order.
Accepts Marketing Whether this customer has agreed to accept marketing from your store.
Currency The currency that 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 (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 -- for example, 150 Elgin St.
Billing Address2 The full second line of the billing address -- for example, Suite 800. This column is often empty.
Billing Company The customer's company name. This column 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 -- for example, 150 Elgin St.
Shipping Address2 The full second line of the shipping address -- for example, Suite 800. This column is often empty.
Shipping Company The customer's company name. This column 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 order note attribute values.
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 -- for example, 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.
Phone The customer's phone number.

Transaction history CSV structure

The following table describes the format of the CSV file that will be created when you export transaction histories of your orders.

Header Definition
Order The checkout ID of a transaction. This number might be used by your payment provider, but does not generally appear in your store admin.
Name The order number associated with the transaction. This column the number shown on your Orders page.
Kind The type of transaction. Whether it was a sale, refund, or an authorization.
Gateway The payment provider 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.

Use a text editor to edit your orders CSV file

If you don't have a spreadsheet program, then you can edit CSV files using a text editor.

Most computers have text editors that can open CSV files. You can also use a program like Atom or Sublime Text to edit and debug your CSV file.

To format your CSV file in a text editor:

  • Column headers must be separated by commas (for example, First Name,Last Name,Email,Company,Address1).
  • The list of tags must be wrapped in quotation marks (for example, "tag1,tag2,tag3").
  • Different records must be separated by line breaks.

Ready to start selling with Shopify?

Try it free