Export Shopify Products with Metafields

To export your Shopify products along with their metafields is very straightforward if you choose to do it with Mixtable Spreadsheet Editor. You’ll need to perform three quick steps.

• First, have a worksheet that shows your Shopify products.
• Second, map one or more columns to show the metafield data you want to export.
• Third, when above are done, just export the spreadsheet and you’ll be able to download all your products with their metafield data as an Excel file or in .CSV format.

Below are more details on each step.

Step 1 - Show your Shopify Products in a spreadsheet

In an existing Mixtable spreadsheet, click the (+) button to add a new worksheet.

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 (no variants) 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 products in the Mixtable spreadsheet

Now that we have our Products (no variants) worksheet, we need to populate our metafields data in it. All that’s involved is to configure columns to display the metafields you want to export. Here’s how:

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

1. In the window that opens, select the Metafield radio button option

2. 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 new metafields then enter the Namespace and Name values you’d like to use. Then, click the Save button.

3. You’ll now see Mixtable set up this new column with a heading (which you are free to change), and populate all the cells with any pre-existing data for the metafield you just set up.

Step 3 - Export your metafields to an Excel file or .CSV

Now that we have our Products metafields data in our worksheet, let’s export everything to an Excel file. Click Import & Export in the top toolbar, then select Export to Excel. The file will be downloaded to your computer right away. And that’s it!

Keep exploring your Shopify data

Mixtable Explore & Export puts supported Shopify data into an Excel-like spreadsheet that runs in your browser. Choose the fields you need, then export the full spreadsheet to Excel or the active worksheet to CSV.

• Compare all the main approaches in the Shopify to Excel guide
• Export Shopify products, collections, products with metafields, or products with collections
• Export Shopify orders or orders with metafields
• Export Shopify blog posts or Shopify pages

For data types that use manual downloads, refresh the relevant Shopify data before exporting so the file contains the latest available records.