WooCommerce – How to Search for Products with Low Sales

Let’s see how to search for WooCommerce products with low sales.

When your WooCommerce store is having products with low sales, you will naturally want to find those products and edit them to improve their sales.

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

Probably 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?

How do you search for 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 – WP Sheet Editor

With WP Sheet Editor, you can view and edit all your WooCommerce products in a spreadsheet that has advanced search, bulk change, export and import tools.

You can skip this step if you already have the plugin installed and activated.

After installing the plugin and activating your license, go to WP Sheet Editor > Edit products.

Now let’s look at different ways to search for all WooCommerce low-sale products.

2. Search for WooCommerce products with low sales

If you want to search for all products with low sales, open the plugin’s Search tool.

Once the tool is open, you can search for your products with low sales combined with different parameters, as you can see in the following sections:

a) Search for all the products with the lowest sales

When you want to know which the products with the lowest sales are, you can enter the following values into the Search tool:

• Tick the Enable advanced filters checkbox and select these values:
  • Field key: Total Sales (total_sales)
  • Operator: <
  • Value: Enter the value that best fits your low-sale concept
• Click on Run search.

b) Search for products with low sales by keyword

If you need to filter all low-sales products that include a keyword, you can easily do it.

Once the Search tool is open, you’ll have to do the following:

• Contains keyword: Enter the keyword in this field.
• Tick the Enable advanced filters checkbox and select these values:
  • Field key: Total Sales (total_sales)
  • Operator: <
  • Value: Enter the value that best fits your low-sale concept
• Click on Run search.

c) Search for low sales products by keyword and attribute

Now let’s see how to look for all the black shirts that report low sales.

For this, we’ll enter the following values in the Search tool:

• Contains keyword: Enter the keyword in this field.
• Enter product attributes: Enter any product attribute here.
• Tick the Enable advanced filters checkbox and select these values:
  • Field key: Total Sales (total_sales)
  • Operator: <
  • Value: Enter the value that best fits your low-sale concept
• Click on Run search.

d) Filter products with low sales by vendor

You can always combine your search parameters, even the advanced ones.

To show you how it works, let’s say you want to find all low-sale products by vendor.

For this, you’ll have to enter the values in the Search tool in the following way:

• Tick the Enable advanced filters checkbox and select these values:
  • Field: Vendor (post_author)
  • Operator: =
  • Value: Enter the vendor’s name
• Click on Add new and select the following values in the new filter:
  • Field key: Total Sales (total_sales)
  • Operator: <
  • Value: Enter the value that best fits your low-sale concept
• Click on Run search.

3. Bulk edit your low-sales products

After filtering your products, they will be displayed in the spreadsheet. Now you can use the spreadsheet to change names, upload pictures, add categories, etc. You decide which changes you’ll apply.

Visit our Guides page to find more than 100 easy-to-follow tutorials.

As you can see, you can easily find and edit WooCommerce products with low sales with WP Sheet Editor.