There may be times you need to generate a spreadsheet of your products. You might need to do cost calculations, modify titles or update inventory, and many times it is easier to do these things in programs like Excel or Google Sheets. Once you have updated the data in the spreadsheet, you can use it to upload into the Bulk Editor app to update the Shopify products.
In this article we'll take you through the steps of exporting your Shopify product data to a spreadsheet with the Bulk Editor. We'll cover:
- Choosing the columns to export
- Generating the spreadsheet
- Downloading the spreadsheet
In order to follow along you should have:
- The Bulk Product Editor 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
Choosing the columns to export
To generate a spreadsheet of your Shopify products, first click the "Speadsheet Edit" link on the right hand side of the Bulk Editor app. Then, click the "Generate Spreadsheet" link in the middle of the screen.
Once you click "Generate Spreadsheet", you will see a field labeled "SEARCH COLUMN" towards the top of the page. This field will be used to identify the products, and will also be the first column in the spreadsheet.
Beneath the "SEARCH COLUMN" field, You will see a list of product and variant attributes. You can include any of these attributes in the spreadsheet by clicking 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 spreadsheet that's generated.
Generating the spreadsheet
Once you have chosen all the columns you want to include, click the "Generate Spreadsheet" button 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.
Downloading the spreadsheet
When the spreadsheet is ready, you can download it by clicking the download icon () beside it in the list. You can download older spreadsheets as well, but keep in mind these 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 spreadhseet, and it would be safer to generate a new one.
Modify and upload the spreadsheet into the app
Now that you've exported a spreadsheet, here's a few more things you can try:
- Using Email Triggers to Edit Products
- Running Sales: Editing Prices and Compare at Prices
- Deleting Shopify Products with the Bulk Editor