WooCommerce – Upload Photo Galleries to hundreds of Products

posted in: Guides | 0

What if you have created your WooCommerce store and suddenly your client asks you to upload galleries to all the products? Maybe the pictures were not ready when you created the store for whatever reason, and now the client asks you to upload them to the products.

How much time will it take you to upload the galleries? Surely it will take you several hours or days.

But don’t worry! In this article we’ll show you how you can upload picture galleries to hundreds or even thousands of products with just a few clicks.

1- Install the WP Sheet Editor Plugin

WP Sheet Editor provides a Products Spreadsheet where you can see all the product information and you can edit freely.

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

2- Setup the WooCommerce Products Spreadsheet

The setup is easy and it only takes 2 minutes.

Please follow this tutorial for the quick setup.

3- Open the Sheet Editor Plugin

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

4. Upload galleries to your products one by one

The first way to upload the galleries to your products is to do it one by one. For example you can have very different products and want to upload them individually.

For this you simply need to go to the “Gallery” column in the spreadsheet and hit the “Select image” button in each product.

Once there, follow these steps:

a) Hit Upload Files and then Select Files

This is to upload files you have in a folder on your computer. Here you can upload not just one but many images to create your gallery.

b) Select the images you want to upload and hit Open

Once you have selected the images, hit Open so that the images start to upload.

Then, you just have to hit “Insert into post”, and the gallery for the first product will be ready.

Now your product has its gallery ready and you can watch the gallery by hitting the view image button, which will show the images by opening a pop-up.

That is the way to upload galleries to your products one by one. The advantage of using the spreadsheet is that you can upload photos quickly, you just need to edit every cell. You can save all the changes at the end.

But it’s not the only way. If you have hundreds or thousands of products, you can upload the galleries to all the products at once. You can upload them using our formulas feature. Here are some examples.

What if you have two thousand products missing galleries and they need the same photo gallery? for example, 100 chairs might require the same product pictures.

We’ll show you how to upload the same pictures to all the products at once.

You can use the “Apply changes in bulk” tool to make that modification. You can open it by clicking the button above the spreadsheet.

Maybe you want to upload images to all the products in one specific category. So here we show you how you can do it with just a few clicks.

a) Go to Apply changes in bulk → Select rows

This tool helps you to filter the cells you will modify. That way you will make sure that only the categories you select will be modified.

b) Look for the category you wish in the “Enter category name” field

For example you may want to upload images to the products in the Smartphone category, so you have to write “Smartphone” in the “Enter category name” and hit the “Run search” button.

Once the search has been done, the products selected for the upload of the image will be just the ones in the smartphone category.

c) Select the Gallery column in order to edit it

First, select the column you want to modify. Do it by writing Gallery in the “What field do you want to edit” field.

Second, choose “Set value” in the Select type of edit.

Third, hit the “Upload the files” button to look for the pictures in your computer.

After that, you just click the “Execute now” button.

Now, when you view the products in the spreadsheet or in the public store, the products will have the pictures.

If you don’t want to filter your products by categories to upload the galleries, then you can do it in other several ways. For example here we’ll show you how to upload galleries to the “Blue T-Shirts”. This means that the attribute you’ll filter is the blue color, together with the T-Shirt keyword.

For that just go to Apply changes in bulk → Select rows. Then you need to go to the “Category name” field, which also lets you select attributes, tags, etc.

So what you need to do is to write the attributes you want to edit.  You can write the T-Shirt keyword and the Blue attribute. Then just hit the “Run search” button and your products will be filtered.

After that you need to look for the images you’ll upload to the gallery.

To look for the images, the first thing you need to do is to select the field you want to edit, which in this case is “Gallery”. Then you select “Set value” in the “Select type of edit” field.

Finally, just hit the “Execute now” button, and that’s it.

Now, as you can see, the gallery appears in the blue T-shirts.

If your WooCommerce store sells e-books, then you are dealing with downloadable products. That means that you may want to upload galleries to those products.

You can do it one by one or you can upload galleries to thousands of e-books at once using the “Apply changes in bulk” tool.

a) Upload galleries to downloadable products one by one

If you will upload galleries to the e-books one by one, just look for the products you want to edit.

For this, you need to use the “Search” tool. This tool will allow you to filter all your products and choose only the ones you want to edit.

As you’re dealing with e-books, you’ll look for the ebooks and will also look for the downloadable products.

To look for the ebooks, write the word E-book in the “Contains keyword” field; to look for the downloadable products, enable the advanced filters by checking the “Enable advanced filters” field.

This will help the Search tool be more specific when searching for the products.

Look for the keyword

Look for the downloadable products

After searching for the downloadable e-books, just hit the “Run search” button and your products will be filtered.

Then you just have to hit the Select image button and select the images you want to include in your first product’s gallery, then the second one and so on…

b) Upload galleries hundreds of downloadable products at once

In order to do this you need to use the “Apply changes in bulk” tool. Then hit the select rows button and do the same search you did in the previous step; that means you need to look for the e-book keyword, and then open the advanced filters and look for the downloadable products.

Look for the keyword

Look for the downloadable products

After that, you just have to select the images you want to include in the gallery.

Remember that to do that the first thing you need to do is to select the field you want to edit, which in this case is “Gallery”.

Then you select “Set value” in the “Select type of edit” field. Finally, just hit the “Execute now” button, and that’s it.

Enjoy your free time

As you can see, uploading galleries to lots of products is really easy with Sheet Editor.

After dedicating just some minutes to upload the galleries, you will have time to chill a little bit or continue working on something else. 😉

You can download the plugin here:

- or - Read more about it

Leave a Reply