WooCommerce – How to Find Best Selling Products

posted in: Guides | 0

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.

1- 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:

- or - Read more about it

2- Open the spreadsheet.

When you open it, you’ll find a spreadsheet that shows you all your products and their detailed info.

3- Find all your best selling product quickly

If you want to know about all your best selling products, you need to use the “Search” tool, which helps you filter your products to find the ones you need. For example you can look for products that have more than fifty sales.

For this you need to follow these really simple steps:

a) Open the “Search” tool.

To open this tool just click it in the above part of the spreadsheet.

b) Enable advanced filters and look for the best selling products

The “search” tool shows you several fields for you to find your products by keyword, category, etc. However, to look for the best selling products you need to enable the advanced filters.

  • Check the “Enable advanced filters” checkbox.
  • Write “_total_sales” in “Field key”.
  • Choose the “greater than” symbol in the “Operator” field.
  • Write 50 in the “Value” field.

4- Find the best selling products by category

If you want to find all products within the “Technology” category, you need to follow these steps:

a) Open the “Search” tool.

To open this tool just click it in the above part of the spreadsheet.

b) Look for the product category

You do this by writing the product name in the “Enter product category” field.

c) Enable advanced filters and look for the best selling products

The “search” tool shows you several fields for you to find your products by keyword, category, etc. However, to look for the best selling products you need to enable the advanced filters.

  • Check the “Enable advanced filters” checkbox.
  • Write “_total_sales” in “Field key”.
  • Choose the “greater than” symbol in the “Operator” field.
  • Write 50 in the “Value” field.

5- Find the best selling products by attribute

If you want to find all products containing an attribute (black color for example), you need to follow these steps:

a) Open the “Search” tool.

To open this tool just click it in the above part of the spreadsheet.

b) Look for the product attribute

Do this by writing the attribute name in the “Enter product attribute” field.

c) Enable advanced filters and look for the best selling products

The “search” tool shows you several fields for you to find your products by keyword, category, etc. However, to look for the best selling products you need to enable the advanced filters.

  • Check the “Enable advanced filters” checkbox.
  • Write “_total_sales” in “Field key”.
  • Choose the “greater than” symbol in the “Operator” field.
  • Write 50 in the “Value” field.
  • Hit the “Run search” button.

You can use more search parameters. You can find best selling products by keyword, date range, is downloadable?, and more.

6- 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:

- or - Read more about it

Leave a Reply