WooCommerce – How to Bulk Delete all Product Variations Quickly

Learn different ways to filter and bulk delete WooCommerce product variations.

Do you want to delete the variations from your WooCommerce products, but there are too many of them?

In this tutorial, we will show you how to bulk remove thousands of variations from your variable products, without deleting the products.

This allows you to create new variations for the products or simply convert the variable products into simple products.

Normally, you would have to open a variable product on your store, delete the variations one by one, save changes, and repeat the process with another product.

That would certainly take a lot of time. You could spend hours or even days removing your product variations without deleting the products.

Fortunately, WP Sheet Editor is a plugin that provides a bulk editor for WooCommerce products.

It allows you to view all the products in a spreadsheet, edit the products quickly, make advanced searches, and cool features for updating hundreds of products at once.

When you activate the plugin you see a quick setup page, you just need to enable the Products spreadsheet here and enable/disable the spreadsheet columns that you need.

Read more info about the setup process.

Once you set up the spreadsheet, you’ll see all your WooCommerce products and their complete information displayed on it.

You can now proceed to bulk remove all the variations from your products.

Since we need to bulk delete the product variations only, we need to use some search filters that will allow you to modify variations only, instead of modifying main products.

WP Sheet Editor allows you to view the product variations next to the parent products on the spreadsheet.

Just click Display variations on the toolbar, and you’ll see the variations displayed on the spreadsheet.

Option 1: Bulk delete all product variations at once

If you want to bulk delete all product variations from your WooCommerce store, you need to do the following.

On the products’ spreadsheet, open the Bulk Edit tool with one click.

Now, select these values to remove all the product variations at once:

• Select the rows that you want to update: Edit all the rows from my current search (including non-visible rows)
• What field do you want to edit: Status
• Select type of edit: Set value
• Replace existing value with this value: Delete completely
• Select Edit only variations.
• Click Execute Now.

Option 2: Manually select products to bulk delete their variations

WP Sheet Editor allows you to manually select the products from which you want to remove the variations.

Just use the checkbox picker column and open the Bulk Edit tool:

Now, open the Bulk Edit tool, and select these values to bulk delete all the product variations at once:

• Select the rows that you want to update: Edit the rows that I selected manually in the spreadsheet
• What field do you want to edit: Status
• Select type of edit: Set value
• Replace existing value with this value: Delete completely
• Select Edit only variations.
• Click Execute Now.

Option 3: Bulk delete variations by keyword, attribute, category, etc.

With WP Sheet Editor, you can also remove the variations from all products containing a specific keyword, category, attribute, tag, a specific price, etc.

As you can see, you can bulk delete WooCommerce product variations easily if you use the WP Sheet Editor plugin.

The best part is that your site won’t become slow, and the update is extremely fast, so you can save hours (or days) of work.