Export Shopify Products With Collections

To export your Shopify products along with the list of collections the products are in you’ll need to perform two quick steps. First, have a worksheet that shows your Shopify products. Second, map the products’ manual collections to be shown in a column. Once this is done, just export the spreadsheet and you’ll be able to download all your products with their collections data as an Excel file. Below are more details on each step.

Step 1 - Have a worksheet that shows your Shopify Products

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 - Map Product Manual Collections to a column in your worksheet

To show your products’ manual collections, you first need to map a column in your Products-linked worksheet.

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.

From the column options you see, select the Product Collections radio button, and then click on the Save button.

You’ll now see that the new column is set up to show each product’s Manual Collections, and it will begin to populate with the handles of any existing Manual Collections that each product is in.

Step 3 - Export your spreadsheet to an Excel file

Now that we have our Products’ collections 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.