Exporting Shopify Data to the Matrixify Format
In addition to exporting data to CSV format, the Bulk Product Editor now supports exporting product data to the Matrixify format. Matrixify is an application that allows you to export various types of data, such as products, orders, and customers, to a CSV file.
This knowledge base article will guide you through the process of exporting Shopify data to the Matrixify format.
In order to follow along, you should have:
- The Bulk Product Editor app installed on your Shopify store
- Products on your Shopify store to export
- A spreadsheet program like Excel or Google Sheets to view or modify the spreadsheet once complete
Step 1: Choosing the columns to export
To generate a spreadsheet of your Shopify products:
1. Click Export Product Data on the left-hand side of the Bulk Editor app.
All products will be selected by default. If you only want to export certain products, choose the products you want to export by selecting the checkboxes next to their names.
You will see a list of product and variant attributes. You can include any of these attributes in the spreadsheet by selecting the box beside that option. Additional fields can be used to filter the list after it is generated, and you can include as many as you need.
Keep in mind that if you plan on using the spreadsheet to upload into the app for an edit, it will only read the first 2 columns in the file; all others will be ignored (you can rearrange or delete extra columns easily inside the spreadsheet editor you are using).
If you include product and variant columns, there will be a row for each variant in the generated spreadsheet.
Step 2: Generating the spreadsheet
Select the format you would like to export in, Matrixify Excel (.xlsx) or Matrixify CSV Zip File (.zip).
Once you have chosen all the columns, you want to include, click Generate Spreadsheet towards the bottom of the screen. The progress of the spreadsheet can be seen in the list below it, along with any other spreadsheets that have been generated in the past.
Step 3: Downloading the spreadsheet
To view all the spreadsheets that have been generated:
- Click History > Exported Products
You will see a button to download each export besides the spreadsheet on the list. Keep in mind the older spreadsheets will have old data, so if you have made any changes since the spreadsheet was generated, those changes will not be included in the older spreadsheet, and it would be safer to generate a new one.
Step 4: Modify and upload the spreadsheet into the app
Once you have downloaded the spreadsheet, you can use a spreadsheet program like Excel or Google Sheets to filter and modify the data. Microsoft Excel is relatively inexpensive these days, but Google Sheets is free and will work as well.
Once you have modified the data, you can use it to update your Shopify products by completing a spreadsheet edit with the Bulk Editor app. If you've never completed a spreadsheet edit, this document will explain the process in more detail: Editing Shopify Products with a Spreadsheet.