WooCommerce – How to Find and Delete Unsold Products

Big stores are difficult to manage. If you sell thousands of products, everything will be bigger. You will have thousands of product images, your database can be huge and slow, and the normal operations like browsing the catalog or searching products can be slow.

In this case, it’s recommended to reduce the number of products to make everything faster and leaner.

But you certainly won’t delete products randomly. You only want to delete the products that no one purchased and you will keep the best selling products.

In this tutorial we’ll show you how to find and delete your unsold products using WP Sheet Editor. You’ll be able to delete thousands of products very quickly.

Install WP Sheet Editor

This is the first step to find and delete your unsold products quickly.

This plugin allows you to find specific products and apply changes to thousands of products with just some clicks.

Forget about this step if you already have WP Sheet Editor.

You can download the plugin here:

Download WooCommerce Products Spreadsheet Plugin - or - Read more

1- Delete unsold products by keyword

If you want to know which are your unsold shirts to delete them, you can look for them using the WP Sheet Editor search tool.

a) Open the Bulk Edit tool

This tool will help you modify lots of products at once.

b) Open the Search tool to filter your products

To filter your products, you need to select the I want to search rows to update option in the Select the rows that you want to update dropdown. It will help you find all the unsold shirts for example.

c) Look for the unsold products by keyword

To find the unsold products containing the keyword Shirt, you’ll look for all the products that have total sales in 0. So you need to do this in the Search tool:

  • Contains keyword: Write the keyword you want. Shirt for example.
  • Enable advanced filters: Tick it
  • Field key: Total sales (total_sales)
  • Operator: =
  • Value: 0
  • Run search: Click on it

e) Delete the unsold products filtered

To delete your unsold products, you need to set these values in the Bulk Edit tool:

  • What field do you want to edit: Status
  • Select type of edit: Set value
  • Replace existing value with this value: You can select either Delete completely or Trash
  • Execute now: Click on it

2- Delete unsold products by category, attribute, or tag

If you want to delete unsold products for an entire category, or products containing a specific attribute (color, size, etc.) or tag, you need to do this:

a) Open the Bulk Edit tool

This tool will help you modify lots of products at once.

b) Open the Search tool to filter your products

To filter your products, you need to select the I want to search rows to update option in the Select the rows that you want to update dropdown. It will help you find all the unsold shirts for example.

d) Look for your unsold products by category

Here we’ll find all the unsold products within a category.

  • Enter tags: Enter the category you want.
  • Enable advanced filters: Tick it
  • Field key: Total sales (total_sales)
  • Operator: =
  • Value: 0
  • Run search: Click on it

e) Delete the unsold products filtered

To delete your unsold products, you need to set these values in the bulk updates tool:

  • What field do you want to edit: Status
  • Select type of edit: Set value
  • Replace existing value with this value: You can select either Delete completely or Trash
  • Execute now: Click on it

Done!

As you can see, finding and deleting unsold products is really easy with WP Sheet Editor.

You can download the plugin here:

Download WooCommerce Products Spreadsheet Plugin - or - Read more

Do you need help?

You can receive instant help in the live chat during business hours, or you can contact us and we will help you via email.

Close Menu