When your client asks you to give him a report on the best selling products, you may have some problems finding all of them. For example with the normal WP editor you only can find your best selling products if you look for them one by one.
But that’s a serious problem if you want to find all the best selling products when you have 1000 of them in your store. Also it’s a big problem if you want to classify your best selling products by category, attribute, keyword, and more parameters.
That’s why in this article we’ll show you how easy it is to find your best selling products with WP Sheet Editor.
Install WP Sheet Editor
This provides a Products Spreadsheet where you can see all the product information and edit freely.
You can skip this step if you already have the plugin installed and activated.
You can download the plugin here: Download WooCommerce Products Spreadsheet Plugin - or - Read more
Open the spreadsheet
When you open it, you’ll find a spreadsheet that shows you all your products and their detailed info.
a) Open the Search tool
You need to click on Search on the plugin’s toolbar.
b) Search for your products
In the Search tool, you need to set these values to search for all best-selling products containing a keyword.
- Tick the Enable advanced filters checkbox and use these values.
- Field key: Total Sales
- Operator: >
- Value: 50, for example
- Click on Run search
a) Open the Search tool
You need to click on Search on the plugin’s toolbar. This tool helps you filter your products in different ways. In this case, it’ll help you find all best-selling products containing a keyword.
b) Search for your products
In the Search tool, you need to set these values to search for all best-selling products containing a keyword.
- Contains keyword: Enter the keyword you wish to filter all products containing it.
- Tick the Enable advanced filters checkbox and use these values.
- Field key: Total Sales
- Operator: >
- Value: 50, for example
- Click on Run search
a) Open the Search tool
Click on Search on the plugin’s toolbar. It helps you filter your products in different ways. In this case, it’ll help you find all best-selling products containing a category, attribute, or tag.
b) Search for your products
In the Search tool, you need to set these values to search for all best-selling products by category, attribute, or tag.
- Enter Tags: Enter categories, attributes, tags, This same field works for the three of them.
- Tick the Enable advanced filters checkbox and use these values.
- Field key: Total Sales
- Operator: >
- Value: 50, for example
- Click on Run search
a) Open the Search tool
Click on Search on the plugin’s toolbar. It helps you filter your products in different ways. In this case, it’ll help you find all best-selling downloadable products.
b) Search for your products
In the Search tool, you need to set these values to search for all best-selling products containing a keyword.
- Tick the Enable advanced filters checkbox and use these values.
- Field key: Total Sales
- Operator: >
- Value: 50, for example
- Click on Add new to add a new advanced filter.
- Field key: Downloadable
- Operator: =
- Value: Tick this checkbox
- Click on Run search
Enjoy your free time!
The search tool in WP Sheet Editor helps you save much time because you can find lots of products with just some clicks.
You can download the plugin here: Download WooCommerce Products Spreadsheet Plugin - or - Read more