Let’s take a look at how to search for top-rated or lowest-rated products in your WooCommerce store.
Searching for top-rated products can be useful if you want to feature the products with best reviews on your WooCommerce store.
It can also be useful to search for lowest-rated products if you want to make improvements or avoid selling products with worst reviews (discontinue products).
We will do this using the WP Sheet Editor plugin, which allows you to view and manage your WooCommerce products in a spreadsheet format. You can bulk edit thousands of products, search for products using any field as a search filter, export products to CSV files, and import products from CSV files.
You can download the plugin here:
Download WooCommerce Products Spreadsheet Plugin - or - Check the features
After installing the plugin and activating your license, you need to follow the steps in the sections below in order to search for worst or best rated WooCommerce products.
Open the products spreadsheet
To open the products’ spreadsheet, go to WP Sheet Editor > Edit products.
You will see all your WooCommerce products displayed on the spreadsheet.
View average rating on the spreadsheet
If you want to see how many stars your WooCommerce products have received on average when customers leave a review, just pay attention to the “Average rating” column.
The number you see in that column is the average number of stars your products receive when users leave a review in the store.
Search for products with worst or best reviews
Now let’s see how to search for products with better or worse ratings.
For this, we will use the Search tool, which allows you to search for WooCommerce products using any field as a search filter.
In this case, we are going to use the “Average rating” field to search for our products with 4 or more stars (top-rated products) or products with 3 or less stars (lowest-rated products).
Option 1 – Search for top-rated products
If you want to search for your best-rated WooCommerce products, you need to select the following values in the Search tool:
- Tick the Enable advanced filters checkbox.
- Field: Average rating
- Operator: >=
- Value: 4
- Click on Run search.
Once you run the search, the spreadsheet will show you only the products that have an average of 4 stars or more.
This lets you know that these are the highest rated products in the entire store, and you can now feature them in the store.
Option 2 – Search for worst-rated products
If you want to search for the lowest rated products in your entire WooCommerce store, just select these values in the search tool:
- Tick the Enable advanced filters checkbox.
- Field: Average rating
- Operator: >=
- Value: 3
- Click on Run search.
Once you run the search, the spreadsheet will show you only the products that have an average of 3 stars or less.
This lets you know which are your lowest-rated products in the entire WooCommerce store. You can now proceed to remove the products, discontinue them, or any other action you may want to take based on this data.
As you can see, WP Sheet Editor allows you to analyze product ratings by searching for the best rated products or the worst rated products on your WooCommerce store. You can use this data to modify your products, make changes to your product catalog, create reports on best and worst products, etc.
You can download the plugin here:
Download WooCommerce Products Spreadsheet Plugin - or - Check the features