In this tutorial, we show you how to hide WooCommerce products without their featured images from the catalog.
When we create a WooCommerce store we have to edit a lot of fields like price, product type, attributes, featured images, etc.
Or maybe you have a CSV file with your product information, but they were not imported correctly, and now you have products with missing fields, without images, etc.
You know that this is a big problem because images are important for your customers to see what your products are about.
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 WooCommerce Bulk Product Editor.
This plugin 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 Find and Bulk Edit Products Without Images.
Install the WP Sheet Editor – WooCommerce Products
You can download the plugin here: Download WooCommerce Products Spreadsheet Plugin - or - Check the features
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. Find 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.
You can download the plugin here:
Download WooCommerce Products Spreadsheet Plugin - or - Check the features