Sometimes when you add new products to your WooCommerce store, you don’t immediately add product photo galleries. It may happen because the photos were not ready at the moment of uploading the products or because you forgot it.
One way or another, with the normal WP editor it can be painful to find all products without image gallery, all products within a category, or containing a specific attribute.
However, in this article we’ll show you how you can find your products without image gallery in all these ways.
Install WP Sheet Editor
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.
Open the Spreadsheet
Once installed and set up, the plugin will show you a spreadsheet containing all your products with all their information.
1- Open the Search tool
With this tool, you can quickly find all your products missing images. It’s located on the product toolbar, so just click on Search to open.
2- Use any of the search options
If you want to find all products missing image galleries, go to Step 3.
This tool allows you to find products missing image galleries by keyword, category, attribute, tag, etc.
You’ll find these fields:
- Contains keyword – Enter a specific keyword to find all products containing it.
- Status – Draft, Private, Published, Scheduled, etc.
- Enter Tags – Enter categories, attributes, tags, shipping classes.
You can use any of these options to filter your products.
3- Search for the products missing galleries
After selecting any of the search parameters, tick the Enable advanced filters checkbox and use these values:
- Field key: Gallery
- Operator: <
- Value: 1
Finally, click on Run search to filter your products.
4- See the spreadsheet
After that, your products will be displayed in the spreadsheet.