Editing products by spreadsheet
If you have a lot of different products to edit it may be faster to upload a spreadsheet with those edits. This article will show you how format your data and upload it to the Bulk Editor.
In order to follow along you should have:
- The Bulk Product Editor installed on your Shopify store
- A properly formatted Spreadsheet with the products and data you want to edit
You can also use the app to generate a template Spreadsheet for you which you can edit and re-upload.
Uploading Your Spreadsheet
Open up the Bulk Product Editor app and click "Spreadsheet Edit" near the top of the left hand side of the screen. Then click the "Click to Upload Spreadsheet" button in the middle of the page, and you'll see a file selection screen.
Select the Excel or CSV spreadsheet to upload. The app will process the file and see which products each row matches with.
Once the file has been processed you'll see the data from your spreadsheet on the screen:
The first dropdown on the left determines how the products to edit will be identified. Currently you can identify products by title, handle, barcode, SKU, variant ID, or Product ID.
For the rest of the columns, if the names in the spreadsheet are close to the Shopify names, the spreadsheet fields may auto-map to the correct Shopify field. However, in some cases you may have to map the fields yourself. The dropdown above the remaining columns determine which field(s) to edit. You have several different options:
(If you want to edit your products in a way that isn't displayed in the drop-down send us an email and we'll see if we can add it for you.)
Finally, the column on the right shows how many products would be matched with each edit. If all of your products are listing 0 matches, you may want to check to make sure the 'Match By' field is correct.
Running the Edit
Once everything looks good click on the Run Edit to complete the edit. You will see a screen showing the progress of the edit, and a list of the products and changes.
Once completed, you can view the edit by clicking 'History' on the left hand side of the screen, then 'Edit History', and then clicking the edit on the list. Most edits can be undone as well. To read more about undoing an edit, click here.
That's all there is to it! In a few steps you can quickly edit hundreds or even thousands of products on your store.
Now that you've scheduled an edit, here are more things you can try:
Don't have the app yet? Get it here