WooCommerce – How to Find and Edit Products with Low Sales

Let’s learn how to find and edit 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 numbers?

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

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.

This spreadsheet shows you the products and their detailed information.

Now let’s look at different ways to search for all low-sale products in the following sections.

2. Find products with low sales

If you want to search for all products with low sales, you don’t need to open and check them one by one.

Just open the plugin’s Search tool, which is located on the toolbar.

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) Find all Products with the Lowest Sales

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

• Field key: Total Sales (total_sales)
• Operator: <
• Value: Enter the value that best fits your low-sale concept

Click on Run search.

b) Find 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 you want to look for
• Enable the advanced filters
• Field key: Total Sales (total_sales)
• Operator: <
• Value: Enter the value you want to search for

Finally, Run the 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 you want to look for
• Product Attribute: Look for the attribute you want to filter your products by
• Enable the advanced filters
• Field key: Total Sales (total_sales)
• Operator: <
• Value: Enter the value you want to search for

Then just run the 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:

• Enable the advanced filters
• Field: Vendor (post_author)
• Operator: =
• Value: Enter the vendor’s name
• Add new filter
• Field: Total Sales (total_sales)
• Operator: <
• Value: Enter the value you want to search for

Click on Run search.

3. Edit your low-sales products

After filtering your products, they will be displayed in the spreadsheet.

You can use it 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.

Done!

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