WooCommerce – Hide Products Without Images from the Catalog

Have WooCommerce products without thumbnail? You may need to hide products without image from the catalog.

Maybe you have created a WooCommerce store and added products missing featured images.

Or maybe you have a CSV file with products’ data, but the products have no image URLs, so the products have been imported and created without product image.

In this case, you may need to hide these products from the catalog.

That’s why, we will show you how to remove products with no featured image from the catalog in bulk.

For that, we will use the WP Sheet Editor – WooCommerce Products plugin, which allows you to make advanced searches, and mass changes in a few minutes.

If instead of hiding your products that are missing their featured images, you want to learn how to upload images from the spreadsheet, you can check our tutorial on how to search and bulk edit products without image.

Install the WP Sheet Editor – WooCommerce Products

Once you install the plugin to open it you must go to WP Sheet Editor > Edit Products

1. Hide products without images individually

You can edit any field directly in the spreadsheet, as easily as you would in Excel or Google Sheets.

In this case, we will locate the Visibility column and change the current visibility type to “exclude-from-catalog”. The best part is that you can drag cells, copy and paste, or select the option from the drop-down.

Once you are done editing, save the changes.

This is the best option when your products do not share any filtering parameters, or you want to edit only some of them.

2. Search for products without images and hide them

Now, to find the products that have no image, we will use the advanced Search tool.

With this tool, you can also filter the products without descriptions, by date, price, etc.

Click on Search.

Once you open the tool, you will see different fields that will help you perform different types of searches:

• Keyword: Enter a specific keyword to search for all products that contain it.
• Category, Tags: Enter categories or tags to filter products containing either a specific tag or category.
• Search on variations: If you check this box, the plugin filters all product variations.
• Enable advanced filters: This checkbox opens advanced filters to search for your products.

To find all products without featured images, you must select the following values:

• Check the Enable advanced filters’ checkbox.
• Field key: featured image
• Operator: Equals symbol (=)
• Value: Leave empty

Once the products without featured images have been filtered in the sheet, to hide them from the catalog, we will use the Bulk Editor.

This tool allows you to apply thousands of changes in a few minutes.

Click on Bulk Edit to open it.

You must select these values to hide the products from the catalog:

• Select the rows you want to update: Edit all results from my current search (including rows not visible)
• What field do you want to edit: Visibility
• Select the type of edit: Set value
• We will replace the existing terms with these terms: exclude-from-catalog
• Click Execute now.

Products with no featured image are now hidden from the catalog.

3. Search for products missing images by keyword

We show you how to find products without featured images by keyword.

Just use the Search tool.

Now select the following values to filter the products by keyword:

Contains keyword: In this field, type a keyword of the product.

Check the Enable advanced filters checkbox and select the following fields:

• Field key: Featured image
• Operator: Equal symbol (=)
• Value: Leave it empty

Now that the products have been filtered, to exclude them from the catalog, we must use the Bulk Edit tool.

Now select these values to remove the products from the catalog:

• Select the rows you want to update: Edit all results from my current search (including rows not visible)
• What field do you want to edit: Visibility
• Select the type of edit: Set value
• We will replace the existing terms with these terms: exclude-from-catalog
• Click Execute now.

All filtered products have been successfully excluded from the catalog.

4. Exclude products without images from the catalog by category, attribute, or tag

The plugin allows you to find all products that have no featured images by a specific category, attribute, or tag.

All you have to do is open the Search tool.

Now you must enter the category, attribute, or tag in the Taxonomy field. It is important to mention that this same field works to filter your products by categories, attributes, tags, visibility, type, and classes.

Then check the Enable advanced filters checkbox and select the following values:

• Field key: featured image
• Operator: Equals symbol (=)
• Value: Leave empty

To exclude products from the catalog, we will use the Bulk Edit tool.

Once you open the Bulk Edit tool, select these values to edit the products:

• Select the rows you want to update: Edit all results from my current search (including rows not visible)
• What field do you want to edit: Visibility
• Select the type of edit: Set value
• We will replace the existing terms with these terms: exclude-from-catalog
• Click Execute now.

Products within the same category, without images, have been excluded from the catalog.

In this tutorial, we have shown you how to filter your products by various elements such as missing featured images, or by keywords, or categories.

All this is for you to be able to hide the products without images from the WooCommerce catalog efficiently.