Find WooCommerce product variations missing images using the WP Sheet Editor plugin.
Sometimes when you create a bunch of variable products, you don’t upload images to those variations, maybe because you didn’t have them ready, or your client didn’t give them to you.
Unfortunately, WooCommerce doesn’t give you any search tool that can help you find your variations without images, and the only way you can do that is by checking products one by one.
Editing product variations in WooCommerce is very difficult because you have to open every product, go to the “variations” tab, and inspect every variation.
That’s why in this entry we’ll show you how easy it is to find product variations without images with WP Sheet Editor.
1. Install WP Sheet Editor
This plugin makes it easier for you to manage your WooCommerce store because it has a powerful “Bulk Edit” tool, which helps you find and edit thousands of products at once.
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 all your products and their complete information displayed in a useful spreadsheet.
The following sections show you how to find product variations missing featured images using different search criteria.
2. Find all product variations without images
This tool allows you to search for products using different parameters. It’s located on the plugin’s toolbar, so just click on Search to open it.
After the tool is open, you need to follow the right section to search for all the variations missing images combined with different parameters:
a) Look for all product variations missing their featured image
If you are only looking for the variations without images, follow these steps:
- Tick the Search on variations
- Tick the Enable advanced filters
Now you need to use these values:
- Field key: Featured Image
- Operator: =
- Value: 0 or leave the field empty
Finally, click on Run search.
b) Filter product variations without images by keyword
To find all the product variations containing a specific keyword, you need to use the plugin’s search tool. It’s located on the plugin’s toolbar, so just click on Search to open it.
After that, you need to do this in order to search for all the variations missing images:
- Writhe the product keyword in the Contains keyword
- Tick the Search on variations
- Tick the Enable advanced filters
Now you need to use these values:
- Field key: Featured Image
- Operator: =
- Value: Enter “0” or leave the field empty
Finally, click on Run search.
c) Search for product variations without images by category, attribute, or tag
If you want to search for all the product variations by category, attribute, or tag, you need to use the plugin’s search tool. It’s located on the plugin’s toolbar, so just click on Search to open it.
After that, you need to do this in order to search for all the variations missing images:
- Writhe the product category, attribute, or tag in the Enter tags
- Tick the Search on variations
- Tick the Enable advanced filters
Now you need to use these values:
- Field key: Featured Image
- Operator: =
- Value: “0” or leave the field empty
Finally, click on Run search.
If you want to learn how to Bulk Edit Product Variations, you can check our tutorial.
Did you notice how easy it is to find your WooCommerce product variations missing images?
You can download the plugin here:
Download WooCommerce Products Spreadsheet Plugin - or - Check the features