Export Shopify orders

Exported Shopify orders facilitate data analysis, backups, and store migrations. It also comes in handy if you need to send your accountant a breakdown of sales every month. The Mixtable spreadsheet app provides the easiest way to export your Shopify orders to Excel with the fields you need. Here’s how it works:

Load Shopify Orders in a spreadsheet

First, set up a worksheet that syncs data to your Shopify orders. You can use the pre-built Orders and Order Items template available in the Create Spreadsheet section.

To load new Shopify data, start by selecting an empty column — any column with a non-green header (green headers mean the column is already linked to Shopify data). Then, click the button in the column header to open the selection window to choose the data you want to pull in.

Mixtable will populate the spreadsheet with any desired data.

When the data sync is ready, which could take a few minutes if you have a lot of data, you can trigger the export.

Order fields you can include

When you export your Shopify order data with Mixtable spreadsheet apps, you can include extra data, such as:

• Order number
• Order ID
• Total order amount
• Fulfilment status (fulfilled; unfulfilled; partially fulfilled; scheduled; on hold)
• Financial status (paid, pending)
• Order status page

Note: Because Mixtable order worksheets sync live with Shopify, your data is always current. You can export the most recent order information at any time, without needing to refresh or update.

Add related data for Metafields, Vendors, Product Types, etc. to your Shopify Orders (no line items) worksheet

Connecting order details with Metafields, Vendors, Product Types, etc. information used to mean VLOOKUP formulas. Not anymore! Mixtable now puts this data directly within your reach. Here's how to do it:

If you have already created a Mixtable spreadsheet with your Shopify Order information, you can quickly add related data to it.

Note: The worksheet needs to show order information, e.g., you can use the Orders and Order Items template spreadsheet, or the Orders (no line items) or Orders (with line items) worksheets.

To load new Shopify data, start by selecting an empty column — any column with a non-green header (green headers mean the column is already linked to Shopify data). Then, click the button in the column header to open the selection window to choose the data you want to pull in.

• From the Shopify Sync Settings window, choose Related Data Fields.

• Then, choose Metafields, Vendors, Product Types, etc. from the drop-down list.
• Allow some time for the data to appear in the columns; you are ready!

Find more about Related Data Fields functionality here.

Export Shopify Orders in a .xlsx or .csv file

Now, click Import & Export in the top toolbar, then choose Export to Excel or Export to CSV. You’ll be immediately prompted with the location where to save the Excel file on your computer. And that’s it!

Well done!

Mixtable Explore & Export is an Excel-like app built to sync data with Shopify automatically. It looks, feels, and behaves like Excel (including formulas), but runs in your browser. Find here:

• How to export Shopify products, products with metafields, and products with collections;
• How to export Shopify orders and orders with metafields;
• How to export blog posts or pages into CSV or Excel.

Because Mixtable keeps your spreadsheet updated automatically as your Shopify data changes, there’s no need to wait for manual syncs — just open and export.