WooCommerce – How to Delete Out of Stock Products Quickly

posted in: Guides | 0

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.

1- 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

2- Setup the WooCommerce Products Spreadsheet

The setup is easy and it only takes 2 minutes.

Please follow this tutorial for the quick setup.

3- Open the Sheet Editor Plugin

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, hit the “Select rows” button, which will allow you to filter your products in several ways; in this case we’ll look for all the out of stock products.

a) Open the “Select rows” tool.

Once you open the “Select rows” tool, you need to enable the advanced filters by checking the “Enable advanced filters” checkbox.

Enable the advanced filters.

Check the “Enable advanced filters” checkbox. You’ll see new options to help you find the out of stock products.

Just to the following:

  • Write “_stock_status” in the “Field key” status.
  • In “Operator”, make sure you have the equal symbol (=).
  • Leave the “Value” checkbox unchecked. It means out of stock
  • Hit the “Run search” button.

b) Delete the products

After filtering the products do this:

  • Confirm that you understand the products will be updated. Do it by checking the “I understand it will update the posts from my search” checkbox.
  • Select status as the field you want to edit. This will update the product status.
  • In the type of edit, select Set value.
  • Write “trash” in the value field.
  • To complete the action, hit the “Execute now” button.

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 need to open the “Bulk Edit” tool and then hit the “Select rows” button.

The “Select rows” button will help you filter the products to find the ones you want to modify.

a) Look for product category, attribute or tag.

To look for all products within a category or containing an attribute or tag, you need to write it in the “Enter product category…” field. This same fiels helps you look in all those ways.

Then just check the “Enable advanced filters” checkbox.

After that, just set these values to look for the out of stock products.

  • Write “_stock_status” in the “Field key” status.
  • In “Operator”, make sure you have the equal symbol (=).
  • Leave the “Value” checkbox unchecked. It means out of stock
  • Hit the “Run search” button.

b) Delete the products

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

  • Confirm that you understand the products will be updated. Do this by checking the “I understand it will update the posts from my post” checkbox.
  • Select “Status” as the field you want to edit.
  • In the type of edit, select “Set value”.
  • Write “trash” in the value field.
  • To complete the action, hit the “Execute now” button.

If you want to delete all out of stock products containing a keyword, you need to use the “Bulk Edit” tool.

The “Select rows” button will help you filter the products to find the ones you want to modify.

a) Look for product keyword.

To look for all products containing a specific keyword, you need to write it in the “Contains keyword” field. Simple as that!

Then just check the “Enable advanced filters” checkbox.

After that, just set these values to look for the out of stock products.

  • Write “_stock_status” in the “Field key” status.
  • In “Operator”, make sure you have the equal symbol (=).
  • Leave the “Value” checkbox unchecked. It means out of stock
  • Hit the “Run search” button.

b) Delete the products

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

  • Confirm that you understand the products will be updated. Do this by checking the “I understand it will update the posts from my post” checkbox.
  • Select “Status” as the field you want to edit.
  • In the type of edit, select “Set value”.
  • Write “trash” in the value field.
  • To complete the action, hit the “Execute now” button.

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

Leave a Reply