In this tutorial, we will show you how to filter WooCommerce products by featured status, using an intuitive spreadsheet on the wp-admin dashboard.
The best part is that you don’t have to use any PHP snippet, so you don’t need any programming knowledge. You will be able to find all products with the “featured” checkbox enabled, or search for products whose visibility status is not “featured”.
As you may know by now, WooCommerce doesn’t allow you to filter products by featured status. One solution may be to do it using code, but that’s now the best option. We will show you how to use a spreadsheet where you can use any field and value to do advanced product searches with a few clicks.
We’re talking about the WP Sheet Editor plugin. It allows you to save a lot of time because you can:
- Edit all types of products in a spreadsheet
- Edit all product fields, including custom fields added with other plugins
- Bulk edit hundreds or thousands of products at once
- Filter and sort products using any field as a search parameter
- Copy product variations from one product to multiple products
- Import and export products with a few clicks
You can download the plugin here:
Download WooCommerce Products Spreadsheet Plugin - or - Check the features
Once you have installed the plugin, follow the steps in the sections below in order to filter all your featured products, or find products that are not featured.
1- Open the WooCommerce Products Spreadsheet
You can open the products spreadsheet by going to WP Sheet Editor > Edit products.
You will see all your WooCommerce products displayed in the spreadsheet.
Every row is a product and every column is a product field.
The spreadsheet allows you to view the featured status by paying attention to the Featured column.
Also, the Product visibility column tells you a product is featured.
2- Filter products by featured status
As we have mentioned above, the WP Sheet Editor plugin contains a Search tool that allows you to filter and sort your products using any field as a search filter.
In this example, it will allow us to find featured products or products that are not featured.
Let’s start by opening the Search tool.
To search for featured products, you need to select the following values in the Search tool:
- Tick the Enable advanced filters checkbox.
- In Field, select the “Is featured” field.
- In Operator, select the = operator.
- In Value, you need to tick the checkbox.
Note – To find products that are not featured, you just need to leave the “Value” checkbox empty.
Once you have selected the necessary values, you need to click on Run search.
After running the search, all the products that match the search criteria will be displayed on the spreadsheet. The results will depend on whether you search for featured/not featured products.
You’ll see the active search filters above the spreadsheet.
If you scroll to the right in the spreadsheet, you will see that the values in the column match the search results.
Search for featured or not featured products now!
With WP Sheet Editor, you can easily filter your products by featured status, using an intuitive spreadsheet on wp-admin.
Imporant – This is not the only search you can make. Here are some related tutorials: