Export orders to a CSV file

You can export a comma-separated values (CSV) spreadsheet of your orders from theOrderspage 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 thecaptured paymentsdata only. Authorization data is not included in your exported transaction histories.

Steps:

Sort and filter your orders．
From theOrderspage, clickExport．
In theExport orderswindow:
Select the option for the orders that you want to export. For example, if you want to export your orders by date, then clickExport orders by dateand set the start and end dates for the orders that you want to export.
UnderExport as, select a file format.
If you want to download all information about your orders, then clickExport orders．If you want to download your transaction information only, then clickExport transaction histories．

You'll have one of the following scenarios when you're trying to export orders:

When you export up to one full page of orders (up to 50 orders), the CSV file is downloaded by your browser.
When you export more than one page of orders (51 or more orders), the CSV file is emailed to you and the Shopify store owner.
If the export fails, then you'll receive an email with this information.

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.

Description of each header in an order export csv file
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 the order.
Fulfillment Status	Whether the order has been fulfilled or is still pending.
Fulfilled at	The date when the fulfillment was completed for the order.
Accepts Marketing	Whether the customer has agreed to accept marketing from your store.
Currency	Your store's base currency at the time of the order.
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 the order.
Total	The total cost of the order.
Discount Code	The discount code that was applied to the order. Only discounts and discounts applied manually to draft orders will be displayed in this column. This does not include automatic discounts.
Discount Amount	The amount of the discount applied to the 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 the line item (product/variant from your products menu).
Lineitem name	The name of the 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 line 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 the billing address.
Billing Address1	The full first line of the billing address -- for example,151 O’Connor Street．
Billing Address2	The full second line of the billing address -- for example,一楼．本专栏通常是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 code of the customer's billing state or province.
Billing Province Name	The name of 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,151 O’Connor Street．
Shipping Address2	The full second line of the shipping address -- for example,一楼．本专栏通常是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 code of the customer's shipping state or province.
Shipping Province Name	The name of 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. An order can have more than one Payment Method. Multiple entries are separated with a space, a`+`, and another space.
Payment Reference(deprecated)	The unique token for the transaction. This number is not displayed in your store admin. This column is now deprecated.Payment Referencesshould be used instead.
Payment References	Contains the Payment IDs sent by Shopify to the payment providers. Use this ID to match order information between Shopify and your payment provider. This column includes all Payment IDs linked to an order, including failed payments, refunds, and captures. Multiple entries are separated with a space, a`+`, and another space.
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. This column only appears if you have the POS sales channel installed on your store.
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 order ID.
Tags	The tags associated with the order.
风险水平	The order's risk level.
Source	The order's source -- for example,web,draft order,POS．
Lineitem discount	The total discount applied to the 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 the line tax.
Phone	The customer's phone number.
Payment ID	A unique ID sent by Shopify to payment providers when a customer pays at checkout. Use this ID to match order information between Shopify and your payment provider. An order can have more than one Payment ID. It only includes successful or pending payments. It does not include captures and refunds. Multiple entries are separated with a space, a`+`, and another space.
Payment terms	The terms for payment of the order. For example,due on receipt．
Next payment due at	The date that the next payment is due.

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.

Description of each header in a transaction history export csv file
Header	Definition
Order	The order ID of a transaction. This number might be used by your payment provider, and it's the number that appears at the end of the URL on an order page.
Name	The order number associated with the transaction. This is the order number shown on yourOrderspage.
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 likeVisual Studio CodeorSublime Textto edit and debug your CSV file.

When you format your CSV file in a text editor, observe the following considerations:

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").
Tags are not case sensitive.
Different records must be separated by line breaks.