This article explains how to export all or a few orders to a csv file.
How to export your orders
You may want to export a list of your orders if you're passing them on to a fulfillment service, or for your own records or book keeping.
To export a large number of orders at a time:
From your shop admin, go to the Orders page.
Check the checkbox next to all the orders you want to export. If you wish to export all of your orders, click on the checkbox next to orders in the list heading. This will select all orders in your list.
To export only a certain type of order (e.g. only fulfilled orders, or only closed orders), first apply a filter to your order list.
Click on the Export button at the top of the page on the right-hand side.
A new window will pop up asking if you want to "Export currently shown orders," or "Export orders by month or quarter." Select the option you want (if you want to Export all your orders, or you've applied a filter to your list to export only a certain type of order, choose "Export currently shown orders").
A CSV file containing your orders will be downloaded instantly.
Once the file is downloaded, you can open and view it in the text editor of your choice.
In addition to the product name under the
Lineitem name field that is exported, Shopify now exports the specific variant name as well. It appears as:
Lineitem name | "product name" - "variant name" |
The variant name will only export if it is not a default value. That is to say, none of the following variant names will export in the CSV file: "Deafult", "Title", or "Default Title"
To add some context, here's a snapshot of what an exported Orders CSV file looks like, focusing on that Linteitem name column.
The Orders.CSV file explained
|Header||What is it?|
|ID||The unique identifier Shopify uses in our database. You won't find this number anywhere in the admin|
|Name||The order number that you can see listed and/or search for in the admin|
|The email address entered during checkout|
|Financial Status||One of
|Paid at||Date the order was marked paid – date format is yyyy-mm-dd hh:mm:ss -timezone|
|Fulfillment Status||One of
|Fulfilled at||Date the order was marked fulfilled - date format is yyyy-mm-dd hh:mm:ss -timezone|
|Accepts Marketing||Yes / No for your customers – they choose in checkout|
|Currency||Three letter currency abbreviation that the customer paid with. Note: you only capture in the currency set in /admin/settings/general|
|Subtotal||Order total before tax & shipping|
|Shipping||Cost to the customer for shipping|
|Taxes||Sum of local, federal, and shipping taxes|
|Total||Order total = subtotal + shipping + taxes|
|Tags||Any order tags that you have manually entered in the admin – customers can't generate these|
|Discount Code||Name of the discount code if one was applied during checkout – empty if none used|
|Discount Amount||Amount in the currency specified in column
|Shipping Method||Name of the shipping rate selected by customer|
|Created at||Date the order was created - date format is yyyy-mm-dd hh:mm:ss -timezone|
|Lineitem quantity||A lineitem is one individual product or variant of an order. An order can have many lineitems. One lineitem can be purchased many times in one order, therefore
|Lineitem name||Title of one product or variant|
|Lineitem price||Price of one product or variant|
|Lineitem compare at price||Compare at price of one product or variant|
|Lineitem sku||Stock Keeping Unit for the lineitem (a unique identifier used for inventory)|
|Lineitem requires shipping||True/False setting controlled at the variant level of each product|
|Lineitem taxable||True/False setting controlled at the variant level of each product|
|Lineitem fulfillment status||For a product or variant, one of
|Billing Name||First and last names of the customer|
|Billing Street||Name of the street entered for billing address|
|Billing Address1||Line 1 of billing address – e.g. "123 Fake st."|
|Billing Address2||Line 2 of billing address – e.g. "Suite 200". This is often empty|
|Billing Company||This is often empty|
|Billing City||Name of the customer's city|
|Billing Zip||Zip codes, postal codes, etc... varies by your region|
|Billing Province||Two letter provincial or state code|
|Billing Country||Two letter country code|
|Billing Phone||Phone number entered during checkout – can be left empty||
||Customers can choose to specify different shipping and billing information (e.g. when sending a gift). The fields behave the same as Billing (see above). Available Shipping fields are
|Notes||Notes can be entered on the order in your admin|
|Note Attributes||Information that a customer can enter during the checkout process – sometimes called cart notes|
|GST||Amount of federal tax paid – may change by region (e.g. VAT in europe)|
|Cancelled at||If the order has been cancelled, date of cancellation – date format is yyyy-mm-dd hh:mm:ss -timezone|
|Payment Method||Name of payment gateway used to check out|
|Payment Reference||A unique checkout id. This checkout id is used behind the scenes to let Shopify communicate with payment processors|
|Refunded Amount||If a refund has been issued, the amount in the Currency of column
|Vendor||Vendor of a product or variant for the lineitem|
|Outstanding Balance||Total order cost minus (-) payment received so far (POS ONLY)|
|Employee||Name of employee who completed the sale (POS ONLY)|
|Location||Physical location of the retail store (POS ONLY)|
|Device ID||Unique identifier for the terminal that processed the sale (POS ONLY)|