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.
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 workbook 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
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 - Basic (without Variants) option. The new worksheet will be added and you’ll see your Shopify Products data starting to populate in it.
Step 2 - Map a Products’ 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. Right click on the 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 green background. When you right click you’ll see a context menu show up. Select the Shopify Sync Settings option.
From the column options you see, select the Product’s Manual 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 workbook to an Excel file
Now that we have our Products’ collections 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!
