To export your Shopify orders along with their metafields you’ll need to perform two quick steps. First, have a worksheet that shows your Shopify orders. Second, map one or more columns to show the data of the metafield(s) you want to export. Once this is done, just export the workbook and you’ll be able to download all your order metafields data as an Excel file. Below are more details on each step.
Just like in Excel click the + button on the worksheets bar. You’ll now be presented with a list of what Shopify data you’d like to sync to the new worksheet - products, orders, customers, etc. Select the Orders option. The new worksheet will be added and you’ll see your Shopify Orders data starting to populate in it.
Now that we have our Orders worksheet we need to get our metafields data to show up in it. All that’s involve dis to configure columns to display the metafields you want to export. Here’s how:
Now that we have our Orders metafields data in our worksheet, let’s export everything to an Excel file. Open the Workbook menu, using the button on the very top-right of the screen. Select the Export to .xlsx option. You’ll be immediately prompted with the location where to save the Excel file on your computer. And that’s it!