WooCommerce – How to Remove Duplicate Product Variations

posted in: Guides | 0

Sometimes you make a mistake while importing products and you end up with duplicate product variations and then want to delete them from our WooCommerce store. However, it can be really difficult to do it if you don’t have a plugin to assist you with that.

For example, if you want to delete all duplicate product variations from products containing a specific keyword, you have to look for all of them one by one. Also, you’ll have to look for all duplicate product variations in products within a category. That sounds boring, doesn’t it?

That’s why in this article we’ll teach you how to delete duplicate product variations using WP Sheet Editor.

Install WP Sheet Editor

This plugin helps you manage your WooCommerce store, editing it in a beautiful spreadsheet.

You can skip this step if you have the plugin installed and activated.

You can download the plugin here:

- or - Read more about it

When you open the plugin, you’ll see a spreadsheet with all your products and their complete information.

If you want to delete all duplicate product variations from all products containing a specific keyword, you need to use the “Bulk Edit” tool. Therefore, you need to open it on the toolbar.

After that, look for all product variations containing the desired product variation. For example, you can look for all product variations containing the “Shirt” keyword.

For this, hit the “Select Rows” button in the Bulk Edit tool.

Once you open the search tool by hitting the “Select Rows” button, you’ll see different fields to filter your products.

So here you need to enter your product keyword in the “Contains keyword” field.

Also, don’t forget to check the “Search on product variations” checkbox to focus your search only on product variations.

Finally, hit the “Run search” button. This will execute the search and will take you back to the Bulk Edit tool to make changes to the selected products.

Back in the Bulk Edit tool, you need to set these values to delete your duplicate product variations:

Important. It will delete the variations with same attributes. This might not work depending on plugin conflicts or if you use old versions of WooCommerce. Please make a database backup before executing the changes.

  • Check the “I understand it will update the posts from my search” checkbox.
  • Select the “Title” column as the field you’ll edit.
  • Select “Delete duplicates” as the type of edit you’ll apply.
  • Hit the “Execute now” button.
  • Done!

To delete all product variations by category, attribute or tag, you’ll not have problems with WP Sheet Editor because it helps you do that with just some clicks.

First, you need to open the “Bulk Edit” tool by clinking it on the toolbar.

Second, go to the search tool by clicking the “Select rows” button. This will open the necessary fields for you to search for your product variations by category, attribute, or tag.

Third, enter the product category, attribute or tag in the “Enter Product category…” field. It’s important to notice that this same field works to look for products in those three ways.

Fourth, check the “Search on product variations” checkbox and hit the “Run search” button, which will take you back to the Bulk Edit tool.

Once in the Bulk Edit tool, you need to set these values to delete your duplicate product variations.

Important. It will delete the variations with same attributes. This might not work depending on plugin conflicts or if you use old versions of WooCommerce. Please make a database backup before executing the changes.

  • Check the “I understand it will update the posts from my search” checkbox.
  • Select the “Title” column as the field you’ll edit.
  • Select “Delete duplicates” as the type of edit you’ll apply.
  • Hit the “Execute now” button.
  • Done!

With WP Sheet Editor it’s really easy to delete duplicate product variations from downloadable products. You just need to open the “Bulk Edit” tool by clicking on the toolbar.

Once you open the Bulk Edit tool, you need to hit the “Select rows” button to open the search tool.

In the search tool, check the “Search on product variations” checkbox. Then, check the “Enable advanced filters” to open the filters you need to look for all the downloadable products.

Here you need to set these values to look for the downloadable products:

  • Select “_downloadable” in the “Field key”.
  • Select “=” in “Operator”.
  • Check the “Value” checkbox.

Hit the “Run search” button, which will take you back to the Bulk Edit tool.

Back in the Bulk Edit tool, you need to set these values to delete your duplicate product variations.

Important. It will delete the variations with same attributes. This might not work depending on plugin conflicts or if you use old versions of WooCommerce. Please make a database backup before executing the changes.

  • Check the “I understand it will update the posts from my search” checkbox.
  • Select the “Title” column as the field you’ll edit.
  • Select “Delete duplicates” as the type of edit you’ll apply.
  • Hit the “Execute now” button.

Done!

As you can see, it’s really easy to delete duplicate product variations with WP Sheet Edit.

You can download the plugin here:

- or - Read more about it

Leave a Reply