Export Shopify Products With Metafields

To export your Shopify products along with their metafields you’ll need to perform two quick steps. First, have a worksheet that shows your Shopify products. 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 products with their metafields data as an Excel file. Below are more details on each step.

Step 1 - Have a worksheet that shows your Shopify Products

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 Products option. The new worksheet will be added and you’ll see your Shopify Products data starting to populate in it.

Step 2 - Sync metafields to columns

Now that we have our Products 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:

  1. Right click on the column header of a column that is not yet mapped to sync to a field. Such columns have a grey background, whereas columns that are set up for data syncing have a light purple background. When you right click you’ll see a context menu show up. Select the Shopify Sync Settings option.
  2. In the window that opens, select the Metafield radio button option
  3. You’ll see that you are now being prompted for information on the metafield that we’ll map into this column. Each metafield in Shopify has a Namespace and a Name. Enter the values for any existing metafields here. If you are creating a new metafields then enter the Namespace and Name values you’d like to use. Then, click the Save button.
  4. You’ll now see Mixtable set up this new column with a heading (which you are free to change), and populating all the cells with any pre-existing data for the metafield you just set up.

Step 3 - Export your workbook to an Excel file

Now that we have our Products 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!