WooCommerce – How to Delete Out of Stock Variations

posted in: Guides | 0

Sometimes your client asks you to delete all out of stock variations, but it can be painful if you have hundreds of variable products and want to identify which of them are out of stock. The normal WP editor doesn’t give you any tool to filter your products and apply changes to hundreds of them at once.

That’s why in this entry we’ll show you how to delete all out of stock variations using WP Sheet Editor.

1- Install WP Sheet Editor

Sheet Editor is a plugin that makes it simpler for you to apply changes to hundreds of products at once with its bulk updates tool. It’s designed to help you make thousands of changes with a few clicks.

You can skip this step if you 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 a spreadsheet showing all your products and their complete information.

2- Find the product variations you want to delete

You may want to delete all products containing a specific keyword, category, tag or all products within a specific category. Fortunately, WP Sheet Editor gives you the tools to do whatever of these changes.

For this, you need to follow these easy steps:

a) Open the “Apply changes in bulk” tool.

This tool will help you filter and edit hundreds of products at once.

b) Open the “Select rows” button.

This button helps you filter your products to find exactly the ones you want.

c) Look for your products by keyword, category, attribute or tag.

If you want to look for all products containing a keyword, just write the keyword in the “Contains keyword” field.

If you want to look for all products within a category or containing an attribute or name, you need to write it in the “Enter Product category…” field. This is an advantage of WP Sheet Editor because it uses a single field to help you find your products by all taxonomies (categories, tags, attributes).

d) Look for the out of stock products.

Whatever you choose in the previous search (keyword, attribute, category, tag), you need to look for products out of stock after that.

For that you need to do this:

  • Check the “Search on variations” checkbox.
  • Check the “Enable advanced filters” checkbox. It will display the necessary fields to look for the products out of stock.
  • Select “_stock_status” in “Field key”.
  • Choose the “equal” sign in Operator.
  • Leave the “Value” checkbox unchecked. It means “out of stock”.
  • Hit the “Run search” button.

3- Delete out of stock variations

After finding all out of stock product variations (by keyword, category, attribute, or tag), you need to proceed with the removal of the variations.

  • Check the “I understand it will update the posts from my search” checkbox.
  • Select “Status” as the field you want to edit.
  • Select “Set value” as the type of edit you’ll make.
  • Write “trash” in the “Replace existing value with this value” field.
  • Hit the “Execute now button”.

This will delete all the variations without stock from our search, it can delete thousands of variations in seconds. It’s the fastest way possible.

It’s really easy!

As you can see, deleting out of stock variations is really easy with WP Sheet Editor.

You can download the plugin here:

- or - Read more about it

Leave a Reply