How to Find WooCommerce Products with Low Sales

Every WooCommerce store eventually accumulates products that do not sell as expected. Whether you are dealing with seasonal dead stock, items with missing images, or products that are simply priced too high, identifying underperforming inventory is a necessary maintenance task.

Natively, WooCommerce provides basic reports, but it does not offer a quick way to filter your entire product catalog by exact sales thresholds and edit those specific products directly. Finding and updating these items manually requires cross-referencing sales reports with your product list, which takes hours if you have hundreds of items.

In this guide, you will learn how to search for WooCommerce products with low sales and bulk edit them using a spreadsheet interface.

How Do I Find Products with Low Sales in WooCommerce?

To quickly find low-selling products without writing database queries, use the WP Sheet Editor plugin. Open the products spreadsheet, launch the Search tool, and enable the advanced filters. Set the Field key to Total Sales (total_sales), use the less than (<) operator, and enter your target sales threshold (e.g., 5). The spreadsheet will immediately filter and display only the products that fall below that sales number.

Video Tutorial: Finding Low-Sales Products

1. Install WP Sheet Editor

To follow along with this workflow, you need the WP Sheet Editor – WooCommerce Products Spreadsheet plugin. This tool allows you to view, filter, and edit all your WooCommerce products in a single spreadsheet environment, making inventory management much faster.

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

After installing the plugin and activating your license, navigate to WP Sheet Editor > Edit products in your WordPress dashboard to open the spreadsheet interface.

2. Open the Advanced Search Tool

To begin filtering your catalog, click on the Search tool located on the plugin’s top toolbar. This tool allows you to combine multiple search parameters to drill down into your specific inventory needs.

Below are four practical ways to locate underperforming products using the search tool.

a) Search for All Products Below a Specific Sales Threshold

If you want to view all products across your entire store that have sold fewer than a specific number of units, you can target the native WooCommerce sales tracking field.

• Tick the Enable advanced filters checkbox.
• Configure the filter with these exact values:
  • Field key: Total Sales (total_sales)
  • Operator: <
  • Value: Enter the number that defines “low sales” for your store (e.g., 10).
• Click the Run search button.

b) Filter Low-Selling Products by Keyword

Sometimes you need to find low-performing products within a specific product line or naming convention. For example, finding all “T-Shirts” that aren’t selling well.

Inside the Search tool, combine the keyword field with the advanced sales filter:

• Contains keyword: Enter your target keyword (e.g., “shirt”).
• Tick the Enable advanced filters checkbox and configure the sales threshold:
  • Field key: Total Sales (total_sales)
  • Operator: <
  • Value: Enter your low-sale threshold value.
• Click Run search.

c) Find Low-Sales Products by Keyword and Attribute

If you have a complex catalog, you may want to get highly specific. For example, you want to find all “Shirts” that are “Black” but have poor sales performance.

You can layer multiple parameters in the Search tool:

• Contains keyword: Enter your keyword here.
• Enter product attributes: Type or select the specific product attribute (e.g., Color: Black).
• Tick the Enable advanced filters checkbox to add the sales condition:
  • Field key: Total Sales (total_sales)
  • Operator: <
  • Value: Enter your numeric threshold.
• Click Run search.

d) Filter Underperforming Inventory by Vendor or Author

If you run a multi-vendor marketplace or have multiple team members managing different product lines, you can filter low-sales products belonging to a specific user.

To do this, you will add two advanced filters:

• Tick the Enable advanced filters checkbox to set up the vendor filter:
  • Field: Author (post_author)
  • Operator: =
  • Value: Enter the vendor’s username or user ID.
• Click on the Add new button to create a second filter condition for the sales data:
  • Field key: Total Sales (total_sales)
  • Operator: <
  • Value: Enter the low-sale value.
• Click Run search.

3. Take Action: Bulk Edit Your Low-Sales Products

After running your search, the spreadsheet will refresh to display only the products that meet your specific low-sales criteria. Instead of simply viewing a report, you can now take immediate action directly from the grid.

Depending on why the products are underperforming, you can use the spreadsheet to:

• Improve Marketing Data: Quickly update product titles, rewrite descriptions, or assign better categories to improve search visibility.
• Run a Clearance Sale: Use the Bulk Edit tool to lower the regular price or apply a bulk sale price to clear out dead stock.
• Clean up the Catalog: If the products are discontinued or permanently out of stock, you can select them all and bulk delete them.

For more practical tutorials on managing your WooCommerce store data, visit our Guides page to find hundreds of detailed tutorials.

By leveraging advanced search parameters, WP Sheet Editor turns basic inventory management into an actionable process, allowing you to optimize your underperforming products without navigating through multiple WooCommerce screens.