Exporting Shopify products

Exporting Shopify products allows for bulk editing and data analysis beyond Shopify’s native capabilities, provides data backups, and facilitates store migrations. Mixtable is the easiest way to export your Shopify products’ data to Excel, with the product data you want.

Sync the Shopify product data you want to export to a spreadsheet

• First, set up a worksheet that syncs data to your Shopify products or variants, depending on which data you want to export.

• You can map product data onto a variants worksheet and vice versa. As you add columns for your desired data,

• Mixtable will automatically populate them with any existing data. When this population is done, which should take a minute if you have a lot of data, you can trigger the export.

Note: Because Mixtable product/variant worksheets sync live with Shopify, your data is always current. You can export the most recent product/variant information at any time, without needing to refresh or update.

Export Shopify product data to .xlsx

• Now 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!

Well done!

Mixtable Spreadsheet Editor is an Excel-like app that is built to sync data with Shopify. With it, you can bulk edit products, metafields, inventory, categories, and more. Find here:

• How to export Shopify products with metafields
• How to export products with collections
• How to export pages into CSV or Excel
• How to export Shopify blog posts into CSV or Excel