WooCommerce – How to Upload Images to lots of Product Variations

Sometimes your parent products have their images and everything complete, but their variations don’t have any images.

One day, your client asks you to upload images to all product variations missing them.

However, in WooCommerce you’ll take lots of hours to do that, and it’ll be tedious and boring.

That’s why in this article we’ll show you how to upload images to product variations by keyword, category, attribute, tag, date, and downloadable products.

1- Install WP Sheet Editor

This plugin allows you to apply changes to thousands of products with just some clicks. It includes powerful tools such as the “Apply changes in bulk” and the “Search” tool.

You can skip this step if you have the plugin installed and activated.

You can download the plugin here:

Download WooCommerce Products Spreadsheet Plugin - or - Read more

When you open the plugin you’ll see a spreadsheet with all your products and their info.

In the following sections, we show you how to...

You can upload featured images to all variations containing a specific keyword. For this, follow these simple steps.

a) Open the Bulk Edit tool

This tool helps you apply changes to thousands of products at once. You just need to filter them and then apply the changes you wish.

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

b) Filter your variations missing images by keyword

For this you need to select the I want to search rows to update option in the Select the rows that you want to update dropdown.

Now, you need to do the following:

  • Enter the product keyword in the Contains Keyword field
  • Tick the Search on variations checkbox
  • Tick the Enable advanced filters checkbox and use these values:
    • Field key: Featured Image
    • Operator: =
    • Value: 0
  • Click on Run search to filter your products

c) Upload images to the variations filtered

To upload images to the products filtered, you need to do this:

  • Select the rows that you want to update: I want to search rows to update
  • What field do you want to update: Featured Image
  • Select type of edit: Set value
  • To upload from your computer, click on Upload the file
  • To load it from a URL, click on File URL
  • Click on Execute now

You can easily upload featured images to all variations containing a specific category, attribute or tag. For this, follow these simple steps.

a) Open the Bulk Edit tool

This tool helps you apply changes to thousands of products at once. You just need to filter them and then apply the changes you wish.

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

b) Filter your variations missing images by category, attribute, tag

For this you need to select the I want to search rows to update option in the Select the rows that you want to update dropdown.

Now, you need to do the following:

  • Enter the product category, attribute or tag in the Enter Tags field
  • Tick the Search on variations checkbox
  • Tick the Enable advanced filters checkbox and use these values:
    • Field key: Featured Image
    • Operator: =
    • Value: 0
  • Click on Run search to filter your products

c) Upload images to the variations filtered

To upload images to the products filtered, you need to do this:

  • Select the rows that you want to update: I want to search rows to update
  • What field do you want to update: Featured Image
  • Select type of edit: Set value
  • To upload from your computer, click on Upload the file
  • To load it from a URL, click on File URL
  • Click on Execute now

You can easily upload featured images to all variations by date range. For example, all variations created between January the 1st and the 31st. For this, follow these simple steps.

a) Open the Bulk Edit tool

This tool helps you apply changes to thousands of products at once. You just need to filter them and then apply the changes you wish.

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

b) Filter your variations missing images by date range

For this you need to select the I want to search rows to update option in the Select the rows that you want to update dropdown.

Now, you need to do the following:

  • Tick the Search on variations checkbox
  • Tick the Enable advanced filters checkbox and use these values:
    • Field key: Featured Image
    • Operator: =
    • Value: 0
  • Date range from: Select the initial date
  • To: Enter the final date
  • Click on Run search to filter your products

c) Upload images to the variations filtered

To upload images to the products filtered, you need to do this:

  • Select the rows that you want to update: I want to search rows to update
  • What field do you want to update: Featured Image
  • Select type of edit: Set value
  • To upload from your computer, click on Upload the file
  • To load it from a URL, click on File URL
  • Click on Execute now

If you have download variations, you can easily upload images to all of them. Just follow these simple steps.

a) Open the Bulk Edit tool

This tool helps you apply changes to thousands of products at once. You just need to filter them and then apply the changes you wish.

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

b) Filter your download variations missing images

For this you need to select the I want to search rows to update option in the Select the rows that you want to update dropdown.

Now, you need to do the following:

  • Tick the Search on variations checkbox
  • Tick the Enable advanced filters checkbox and use these values:
    • Field key: Featured Image
    • Operator: =
    • Value: 0
  • Click on Add new to add a new filter, and use these values:
    • Field key: Downloadable
    • Operator: =
    • Value: Tick this checkbox
  • Click on Run search to filter your products

c) Upload images to the variations filtered

To upload images to the products filtered, you need to do this:

  • Select the rows that you want to update: I want to search rows to update
  • What field do you want to update: Featured Image
  • Select type of edit: Set value
  • To upload from your computer, click on Upload the file
  • To load it from a URL, click on File URL
  • Click on Execute now

Done!

Did you see how easy it is to upload images to your product variations?

Get the plugin now and start saving time.

You can download the plugin here:

Download WooCommerce Products Spreadsheet Plugin - or - Read more

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.

Close Menu