WooCommerce – Delete Product Vatiations by Category, Attribute, Keyword

What do you do when you want to delete product variations to hundreds of products?

With the normal WooCommerce product editor you can do it, but it takes you lots of hours or even days, depending on how much products you have. But what if you need to do it in just some minutes? Do you think you’ll be able to delete product variations for two thousand products in a single day? It sounds exhausting and boring, doesn’t it?

That’s why in this article we’ll show you how to delete product variations by category, keyword, etc.

Install the Sheet Editor Plugin

This is a WordPress plugin that 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 installed and activated, you need to go to Sheet Editor > Edit products to open the plugin, which will display your products in a spreadsheet like this:

To delete product variations by keyword, category, attribute, or tag, you need to follow these simple steps.

a) Open the Bulk Edit tool

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

b) Open the Search tool

Select the I want to search rows to update option in the Select the rows that you want to update dropdown.

c) Filter your product variations

  • Contains keyword: Use this field to search all products containing a specific keyword.
  • Enter tags: Use this field to enter product categories, attributes, tags, or shipping classes.

After selecting any of these search methods, you need to tick the Search on variations checkbox.

Finally, click on the Run search button.

d) Delete the variations filtered

You need to use these values to delete the variations filtered:

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

To delete product variations in downloadable products, you need to follow these simple steps:

a) Open the Bulk Edit tool

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

b) Open the Search tool

Select the I want to search rows to update option in the Select the rows that you want to update dropdown.

c) Filter your downloadable product variations

Tick the Search on variations and the Enable advanced filters checkboxes. Then, use these values to filter the downloadable variations:

  • Field key: Downloadable (_downloadable)
  • Operator: =
  • Value: tick the checkbox

Finally, click on Run search.

d) Delete the variations filtered

You need to use these values to delete the variations filtered:

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

Done!

Do you see how easy it is to delete your products variations in WooCommerce? Save lots of time; start using 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