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.

4- Look for product variations

Since we want to delete only product variations, we need to specify that because otherwise we would delete all products, and that’s not what we want right now.

So to look for product variations, please follow these simple steps.

a) Open the “Bulk Edit” tool.

This tool will allow you to apply changes to thousands of products at once.

b) Hit the “Select rows” button.

This button will open a search tool to help you filter your products.

c) Look for product variations.

To look for your product variations, you need to check the “Search on variations” checkbox and then hit the “Run search” button.

5- Delete all product variations in bulk

Deleting all product variations is really easy with WP Sheet Editor. You just need to set these values:

  • Check the “I understand it will update the posts from my search” checkbox.
  • Select “Status” as the field you’ll edit.
  • Select “Set value” as the type of edit you’ll apply,
  • Write “trash” in the “Replace existing value with this value” field.
  • Hit the “Execute now” button.

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