Learn how to upload images to your product variations in bulk.
We often overlook the impact of images when our customers consider buying our products.
While it is true that the parent product may have an image, many sales can be lost because the customer is not sure what the product they are receiving will actually look like.
This is why it is necessary that you upload images to all variations of the products that are missing.
However, in WooCommerce it will take you many hours to do it, and it will be tedious and boring.
That’s why in this article we will show you how to upload images to product variations by keyword, category, attribute, tag, date, and downloadable products.
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 - Check the features
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 upload featured images:
1. Upload featured image to variations by keyword
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 it.
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
2. Upload featured image to variations by category, attribute, or tag
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
3. Upload featured image to variations by date range
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
4. Upload featured image to download variations
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 - Check the features