Export Orders

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:

  1. From your shop admin, go to the Orders page.

  2. 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.

    #

  3. 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.

  4. Click on the Export button at the top of the page on the right-hand side.

    #

  5. 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").

    #

  6. A CSV file containing your orders will be downloaded instantly.

  7. 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" |

Reminder

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
Email The email address entered during checkout
Financial Status One of { pending, authorized, partially_paid, paid, partially_refunded, refunded, voided }
Paid at Date the order was marked paid – date format is yyyy-mm-dd hh:mm:ss -timezone
Fulfillment Status One of { fulfilled, null, partial }
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 I – Zero (0) if no discount was applied
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 quantity shows how many of that product or variant was purchased for this unique order ID.
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 { fulfilled, null, partial }
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
Shipping address fields 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 { Shipping Name, Shipping Street, Shipping Address1, Shipping Address2, Shipping Company, Shipping City, Shipping Zip, Shipping Province, Shipping Country, Shipping Phone }
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)
Canceled at If the order has been canceled, 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 I – otherwise zero (0)
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)
Risk Level Indicates the likelihood that this order is fraudulent. Possible values are Low, Medium, or High. It's recommended to manually review orders with Medium or High risk. Follow this link for more information.

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.