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.

Prerequisites

In order to follow along you should have:

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. 

Bulk_Editor_Spreadsheet_Edit.png

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:

Bulk_Editor_Spreadsheet_Edit_List.png

You can use the first dropdown on the left to choose how to locate the products to edit. Currently you can locate products by title, handle, barcode, or SKU.

The dropdown above the remaining columns determine which field(s) to edit. You have several different options:

Bulk_Editor_Spreadsheet_Edit_Field_List.png

(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.

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.

Bulk_Editor_Spreadsheet_Edit_Progress_List.png

 Once completed, you can view the edit by clicking the "Edit History" link on the left hand side of the page.

Bulk_Editor_Edit_History_List.png

Conclusion

That's all there is to it! In a few steps you can quickly edit hundreds or even thousands of products on your store.


Next Steps

Now that you've scheduled an edit, here are more things you can try:


Don't have the app yet? Get it here

Did this answer your question? Thanks for the feedback There was a problem submitting your feedback. Please try again later.