Exporting Shopify Data to CSV
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 it 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 app. 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 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.
You will see a field labeled "Identifier 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 (the first column in the spreadsheet is always the match field).
Beneath the "Identifier Column" field, 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
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.