WooCommerce – How to Delete Out of Stock Variations

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.

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.

1- Open the Bulk Edit tool

This tool allows you to edit hundreds of products with a few clicks. It’s really easy to use.

It’s located on the plugin’s toolbar, so just click on it to open.

2- Find all the out of stock variations

For this you need to select the I want to search rows to update option in the Select the rows that you want to update dropdown.

After that, you need to do this in order to search for all the out of stock variations:

  • Tick the Search on variations
  • Tick the Enable advanced filters

Now you need to use these values:

  • Field key: Stock status (_stock_status)
  • Operator: =
  • Value: Leave this checkbox unchecked

Finally, click on Run search

3- Delete the filtered variations

Use these values in the Bulk Edit fields to delete the filtered variations:

  • Select the rows that you want to update: I want to search rows to update
  • What field do you want to edit: Status
  • Select the type of edit: Set value
  • Replace existing value with this value: Delete completely or Trash
  • Click on Execute now

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

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