search

Exporting 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:

Shopify Orders in a spreadsheet

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

Shopify orders spreadsheet

If you want to add additional information to the order data, use the Link button.

Shopify data in a spreadsheet

Mixtable will populate the spreadsheet with any desired data.

shopify orders data in a spreadsheet

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.

Export Shopify Orders in a .xlsx or .csv file

Now, open the workbook menu using the button on the very top-right of the screen. Select the Export > Export to Excel or Export to CSV option. You’ll be immediately prompted with the location where to save the Excel file on your computer. And that’s it!

export shopify orders

Well done!

Mixtable Spreadsheet Editor is an Excel-like app that is built to sync data with Shopify. With it, you can bulk edit products, metafields, inventory, collections, and more. Find here how to:

Mixtable is an online spreadsheet, designed from the ground up to bulk edit and analyze Shopify data.

Got a question? We're here to help! Reach out at [email protected], and we'll get back to you promptly.