WooCommerce – How to Find Products without Gallery Images

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.

You can download the plugin here:

- or - Read more about it

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.

You can download the plugin here:

- or - Read more about it

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