WooCommerce – Upload Photo Galleries to Hundreds of Products

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.

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.

Video Guide

Text Guide

Once installed and activated, go to Sheet Editor > Edit products, and you will see a spreadsheet that contains all your products with all their information.

1- Upload galleries to products individually in the spreadsheet

This is really simple. Just go to the Gallery column. There, you can either upload an image by clicking the upload button or you can paste image URLs.

woocommerce-bulk-upload-galleries

Finally, click on Save to apply the changes made.

2- Upload galleries to hundreds of products by keyword, category, attribute, tag

If you want to upload product galleries to hundreds of products by keyword, category, attribute, or tag, you need to follow these simple steps:

a) Open the Bulk Edit tool

It’s located on the plugin’s top toolbar, so just click on it.

woocommerce-bulk-upload-galleries

b) Open the Search tool

Select the I want to search rows to update option in the Select the rows that you want to update dropdown.

woocommerce-bulk-upload-galleries

c) Filter your products

  • Contains keyword: Use this field to search all products containing a specific keyword.
  • Enter tags: Use this field to enter product categories, attributes, tags, or shipping classes.
  • After you’ve decided which search method you want to use, click on the Run search button.

woocommerce-bulk-upload-galleries

d) Upload image galleries to the products filtered

You need to use these values to upload image galleries to your products filtered:

woocommerce-bulk-upload-galleries

  • What field do you want to edit: Gallery
  • Select the type of edit: Set value
  • Replace existing value with this value: You can either upload the images or paste URLs.
  • Click on Execute now.

3- Upload galleries to downloadable products

If you want to upload galleries to your downloadable products, you need to follow these simple steps:

a) Open the Bulk Edit tool

It’s located on the plugin’s top toolbar, so just click on it.

woocommerce-bulk-upload-galleries

b) Open the Search tool

Select the I want to search rows to update option in the Select the rows that you want to update dropdown.

woocommerce-bulk-upload-galleries

c) Filter your downloadable products

Tick the Enable advanced filters checkbox.

Then, use these values to filter the downloadable products:

woocommerce-bulk-upload-galleries

  • Field key: Downloadable (_downloadable)
  • Operator: =
  • Value: tick the checkbox
  • Finally, click on Run search.

d) Upload image galleries to the products filtered

You need to use these values to upload image galleries to your products filtered:

woocommerce-bulk-upload-galleries

  • What field do you want to edit: Gallery
  • Select the type of edit: Set value
  • Replace existing value with this value: You can either upload the images or paste URLs.
  • Click on Execute now.

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 or continue working on something else.

Do you need help?

You can receive instant help in the live chat during business hours, or you can contact us and we will help you via email.