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: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.