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 orders by search or selection

To export a selection of orders as a CSV file:

1. Sort and filter your orders if needed.

2. Click Export in the header of the Orders page.

#

3. From the pop-up, click to select which orders 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 histories.
#

Information

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

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

Information

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

Export orders by date

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

1. Click Export in the header of the Orders page

#

2. From the pop-up, click Export orders by date.

#

3. Set the Start Date and End Date for the orders 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 file.

Information

Exporting by date 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 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 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
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 POS location that sold the order
Device ID The device ID of the POS used to sell the order
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
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.

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 might be used by your payment gateway, but does not generally appear in your store 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.