WooCommerce – Bulk Upload Images to Products

posted in: Guides | 0

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.

You can download the plugin here:

- or - Read more about it

Once opened, you will see a spreadsheet that contains all your products with all their properties…

These are some simple steps you need to take to add images to all products.

A) How to upload the images one by one.

For this, you just need to use the Featured Image column and hit the Select Image button, which will allow you to look for the image for the specific product. That way you will have the opportunity of reducing the number of steps you could take to change it without the spreadsheet.

However, there is a way in which you can upload images for hundreds or thousands of products.

B) How to upload images to thousands of products at once

Here we’ll show you how to upload a picture to hundreds of products using the “Apply changes in bulk” tool. The first thing you need to do is to hit the Apply changes in bulk button.

When you select it, you will see several options. So, do the following…

Select the rows you want to edit.

As you can see, this store has different products. So, here we’ll show you how you can upload the images to your products. The first step to do it is to hit the Select rows button, which will allow you to find the different options we’ll show you.

This button helps you filter your products to find specifically the ones you want to upload the images

If you, for example, want to upload images to the products with the keyword T-Shirt, you just have to search for it. For this, just write the keyword you want to find in the Contains keyword field.

If you write T-shirt, the only products that will be taken into account for this modification will be the T-Shirts, not the shoes, nor the cellphones, but only the T-Shirts.

After that, you just hit the “Run search” button.

Select the Column “Featured Image”

As we want to upload feature images to our product T-Shirt, we need to select the column with the name “Featured Image”. You can do that by writing Featured Image in the Select column… field.

Select the image you want to upload

As we are just uploading images to our products missing them, we’ll select the option Set Value. This means that you are uploading the image for the first time to your product. After that, hit the Upload the file and look for the image you want to upload.

After that, just hit the Execute now button and that’s it. As you can see now, the images appear in the T-Shirts…

This means that the changes will apply only to the products within the category you select.

For example, let’s work on the products with the category Smartphones. For that, you go to Apply changes in bulk→ Select rows → Category name, write the name of the category you want to select, and hit the Run Search button.

Select the image you want to upload, and hit the Execute now button.

To select the image, you need to hit the Upload the file button and look for the image you want to upload. After that, just hit the Execute now button and that’s it.

Your products in the category of Smartphones will have images now.

Maybe your store includes some downloadable products such as e-books, PDF files, etc. So, you want to upload images to all those products. It’s really easy with Sheet Editor.

a) Go to Apply changes in bulk

b) Hit the Select rows button

c) Select Enable advanced filters

d) Type _downloadable

e) Write yes in the field Value

f) Hit the Run search button

g) Select the image you want to upload and hit the Execute now button

And that’s it! As you can see, the E-book products have images now.

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.

You can download the plugin here:

- or - Read more about it


Leave a Reply