WooCommerce Delete all Product Variations Quickly

posted in: Guides | 0

Sometimes you create a bunch of Variable Products in your WooCommerce store because you want to try a new theme or template, or a plugin, or it´s just a demo for a client.

But then you realize that your Variable Products should be Simple Products instead, or you realize that you made a mistake when creating the variations.

You have 2 options:

  • You either delete them and create the products again
  • Or you delete the product variations, one by one, to fix the mistake

Well. We know that deleting a lot of product variations can be difficult, so in this tutorial we show you how to do that in just a couple of clicks.

1- Install WP Sheet Editor

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

It lets you view all the products in a spreadsheet, edit the products quickly, make advanced searches, and cool feature for updating hundreds of products at once in just a few seconds.

The first step in the tutorial is to install the plugin.

You can download the plugin here:

- or - Read more about it

2- Quick setup

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. Then continue.

Read more info about the setup process.

3- Start using the spreadsheet

Now you can see the spreadsheet. It shows all your WooCommerce products and you see a couple of tools in the toolbar.

woocommerce-products-spreadsheet

4- Delete the product variations in bulk

Now you need to open the “Apply changes in bulk” tool. The tool has a form like this:

delete-woocommerce-variations

In our case, we need to change the “Status” field for the variations. We select “Set value” in the second dropdown, and we set the status to “trash”, which moves the variations to the trash bin / deletes them.

We are applying the change to all products, but only to the variations inside the products. It´s important to check the “Execute formula only on variations” option, otherwise you´d be moving the products to the trash (you can revert the change though).

You can filter the update scope, you can apply the change to the products under a specific category or tag or product attribute, and you can filter by product keyword too. In this case we use “all products”.

5- Done

Deleting the variations is fairly easy. You can do that with a couple of clicks, and the formula execution takes just a couple of seconds.

You can delete thousands of variations at once, and your site won´t become slow, the update is extremely fast.

So you can save hours (or days) of work by using WP Sheet Editor.

You can download the plugin here:

- or - Read more about it

Leave a Reply