WooCommerce – How to Delete Out of Stock Products Quickly

Sometimes stores have products just for a season or they stop selling them after the products run out of stock. So when that happens, maybe you’ll need to delete those products from your WooCommerce store.

How do you delete all out of stock T-Shirts? How do you delete all out of stock green jeans? What do you do to delete all products containing a tag?

In this article, we’ll show you how to delete thousands of out of stock products with just a few clicks.

This works in all servers, even cheap servers. It won’t slow down your site.

Install Sheet Editor Plugin

WP Sheet Editor provides a Products Spreadsheet where you can see all the product information and you can 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

Once you open the plugin, you’ll find all your products along with their detailed information.

To look for the out of stock products and delete them all, you need to open the “Bulk Edit” tool. This tool helps you apply changes to thousands of products at once, so open it by clicking it in the spreadsheet.

Once you open the tool, select the I want to search rows to update in the Select the rows that you want to update dropdown, which will allow you to filter your products in several ways; in this case we’ll look for all the out of stock products.

Filter the out of stock products

  • Enable advanced filters: Check it
  • Field key: Stock status (_stock_status)
  • Operator: =
  • Value: Leave it inactive
  • Run search: Click on it

Delete the products you’ve filtered

After filtering the products, use these values to delete them:

  • What field do you want to update: Status
  • Select type of edit: Set value
  • Replace existing value with this value: Delete complete
  • Click on Execute now

IMPORTANT. You can select Trash or Delete completely

If you don’t want to delete all out of stock products, maybe you want to do it by category, which is a more specific way of filtering them. When that happens, you first need to open the “Bulk Edit” tool.

Once you open the tool, select the I want to search rows to update in the Select the rows that you want to update dropdown, which will allow you to filter your products in several ways; in this case we’ll look for all the out of stock products by keyword, category, attribute, or tag.

a) Filter your products by keyword, category, attribute or tag.

To look for all products containing a keyword, category, attribute or tag, you need to use the following fields:

  • Contains keyword – Enter a product keyword
  • Enter tags – You can look for products by category, attribute, or tag. This same fiels helps you filter your products in all those ways.

  • Enable advanced filters: Check it
  • Field key: Stock status (_stock_status)
  • Operator: =
  • Value: Leave it inactive
  • Run search: Click on it

You just have to choose a search method and hit the Run search button to filter your products.

b) Delete the products you’ve filtered

After filtering the products you need to set the necessary values to delete the products, so do this:

  • What field do you want to update: Status
  • Select type of edit: Set value
  • Replace existing value with this value: Delete complete
  • Click on Execute now

IMPORTANT. You can select Trash or Delete completely

If you want to delete all out of stock downloadable products

Once you open the tool, select the I want to search rows to update in the Select the rows that you want to update dropdown, which will allow you to filter all your out of stock downloadable products.

a) Filter all out of stock downloadable products

You need to know which of your downloadable products have run out of stock. Therefore, you need to use two advanced filters like this:

  • Enable advanced filters: Check it
  • Field key: Stock status (_stock_status)
  • Operator: =
  • Value: Leave it inactive

Now you need to click on Add new to add a new advanced filter.

  • Field key: Downloadable (_downloadable)
  • Operator: =
  • Value: Check it

After that, just hit the Run search button to filter your out of stock downloadable products.

b) Delete the products you’ve filtered

After filtering the products you need to set the necessary values to delete them, so do this:

  • What field do you want to update: Status
  • Select type of edit: Set value
  • Replace existing value with this value: Delete complete
  • Click on Execute now

IMPORTANT. You can select Trash or Delete completely

A piece of cake!

As you can see, deleting out of stock products us really easy with sheet editor, so don’t lose time and start using it.

You can download the plugin here:

- or - Read more about it

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