What if you’re creating a WooCommerce store and you created products without images because the client didn’t send you the pictures? Now you finally have the pictures, but it’s going to take you several hours or days to upload them to each product.
Of course, you can do it the normal way. That means that you would have to change the images of your products one by one. That is the only way you can do it with WooCommerce.
However, you can do it in just some minutes or seconds with the Sheet Editor plugin. You can upload images to hundreds or thousands of products with just some clicks. Just take these simple steps.
Install Sheet Editor Plugin
You can skip this step if you already have the plugin installed and activated.
Once opened, you will see a spreadsheet that contains all your products with all their properties…
1- Open the Bulk Edit tool
This tool will help you apply changes to thousands of products at once. You can apply changes to all of them or filter them to apply changes to specific products by keyword, category, tag, attribute, etc.
2- Open the Search fields
Once you open the Bulk Edit tool, you need to select the I want to search rows to update option in the Select the rows that you want to update dropdown.
3- Filter your products
Using the search tool you can filter your products by keyword, category, attribute, tag or shipping class. Besides, you can filter all your downloadable products.
Here we show you the two options, you decide how to filter your products.
a) Keyword, status, category, attribute, tag, shipping class
- Contains keyword – Enter a specific product keyword.
- Status – Search for all the published or all the drafts
- Enter tags – Use this field to search for products by category, attribute, tag, shipping class
b) Downloadable products
Tick the Enable advanced filters checkbox, and use these values:
- Field key: Downloadable (_downloadable)
- Operator: =
- Value: Tick this checkbox
Finally, just click on the Run search button.
4- Upload the images to your products filtered
In the Bulk Edit fields, you need to use these values to upload the images to your products filtered:
- Select the rows that you want to update: I want to search rows to update
- What field do you want to edit: Featured Image
- Select type of edit: Set value
- You can either Upload the image or paste an image URL
- Hit Run search
5- Start selling more!
Images are one of the most important features costumers look for. So, if your products are ready with images, you have much more possibilities to sell them.
This plugin really will save you some long hours editing uploading images for your products one by one.