WooCommerce – How to Find and Edit Products with Low Sales

posted in: Guides | 0

Sometimes you manage a WooCommerce store that makes low sales and you want to find the products with worst sales and improve them.

Maybe those products have crappy images, or maybe they’re out of stock and you need to delete them.

Maybe the product information is okay, and you need to increase your marketing efforts or reduce prices.

But how do you find the products that have low sales numbers? How do you find all products with low sales by category or attribute? How do you find and edit all T-Shirts with low sales?

In this article we’ll show you how to find and edit products with low sales.

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

This spreadsheet shows you the products and their detailed information.

If you want to know about all products with low sales, you need to use the “Search” tool, which helps you to find products by filtering them in several ways.

In this case, it’ll help you find all products with low sales.

a) Open the “Search” tool

Open this tool by clicking it on the above part of the spreadsheet.

b) Look for products with low sales

Once you open the “Search” tool, you’ll see several options to help you search for the products you want. In this case, you need to do the following:

  • Check the “Enable advanced filters” checkbox.
  • Write _total_sales in “Field key”.
  • Look for the < symbol in “Operator”.
  • Write 10 in the “Value” field to find product with less than 10 sales
  • Hit the “Run search” button.

c) Edit products with low sales

Once you’ve made the search, you need to start editing the products. For example, you can change names, categories, attributes, descriptions, etc. For this you can use the spreadsheet to apply changes quickly.

Maybe you don’t want to look for all products with low sales. For example you may want to look for all the products within the “Clothes” category, so you need to take these steps:

a) Open the “Search” tool

Open this tool by clicking it on the above part of the spreadsheet.

b) Look for the category name

To look for the category name you need to write it in the “Enter product category” field. For example you may write “Clothes”.

c) Look for products with low sales

Once you open the “Search” tool, you’ll see several options to help you search for the products you want. In this case, you need to do the following:

  • Check the “Enable advanced filters” checkbox.
  • Write _total_sales in “Field key”.
  • Look for the < symbol in “Operator”.
  • Write 10 in the “Value” field.
  • Hit the “Run search” button.

d) Edit products with low sales

Once you’ve made the search, you need to start editing the products. For example, you can change names, categories, attributes, descriptions, etc. For this you can use the spreadsheet to apply changes quickly.

If you want to look for all the “red” products with low sales, you need to take these simple steps:

a) Open the “Search” tool

Open this tool by clicking it on the above part of the spreadsheet.

b) Look for the product color

To look for the color you need to write it in the “Enter product attribute” field. For example you may write “red” in order to look for all the red products.

c) Look for products with low sales

Once you open the “Search” tool, you’ll see several options to help you search for the products you want. In this case, you need to do the following:

  • Check the “Enable advanced filters” checkbox.
  • Write _total_sales in “Field key”.
  • Look for the < symbol in “Operator”.
  • Write 10 in the “Value” field.
  • Hit the “Run search” button.

d) Edit products with low sales

Once you’ve made the search, you need to start editing the products. For example, you can change names, categories, attributes, descriptions, etc. For this you can use the spreadsheet to apply changes quickly.

If you sell downloadable products, maybe you want to find which ones have low sales. So in this case you need to apply two advanced filters: one for the downloadable products and one for the low sales.

a) Open the “Search” tool

Open this tool by clicking it on the above part of the spreadsheet.

b) Look for products with low sales

Once you open the “Search” tool, you’ll see several options to help you search for the products you want. In this case, you need to do the following:

  • Check the “Enable advanced filters” checkbox.
  • Write “_total_sales” in “Field key”.
  • Look for the < symbol in “Operator”.
  • Write 10 in the “Value” field.

c) Look for the downloadable products

  • Hit “Add new” to add another advanced filter and look for the downloadable products.

  • Write “_downloadable” in “Field key”.
  • Select the symbol in “Operator”.
  • Write “yes” in the “Value” field.

d) Edit products with low sales

Once you’ve made the search, you need to start editing the products. For example, you can change names, categories, attributes, descriptions, etc. For this you can use the spreadsheet to apply changes quickly.

7- Done!

As you can see, finding and editing products with low sales is really easy with WP Sheet Editor.

You can download the plugin here:

- or - Read more about it

Leave a Reply