WooCommerce – How to Remove Duplicate Product Variations

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:

Download WooCommerce Products Spreadsheet Plugin - or - Read more

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.

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

In the search tool, you need to do this:

  • Write the keyword in the Contains keyword field.
  • Tick the Search on variations checkbox.
  • Click on Run search

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.

  • Select the rows that you want to update: I want to search rows to update.
  • What field do you want to update: Title
  • Select type of edit: Remove duplicates
  • Click on Run search

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.

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

In the search tool, you need to do this:

  • Write the desired category, attribute or tag in the Enter Tags field.
  • Tick the Search on variations checkbox.
  • Click on Run search

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.

  • Select the rows that you want to update: I want to search rows to update.
  • What field do you want to update: Title
  • Select type of edit: Remove duplicates
  • Click on Run search

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.

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

In the search tool, you need to do this:

  • Tick the Search on variations checkbox.
  • Tick the Enable advanced filters checkbox
  • Field key: Downloadable
  • Operator: =
  • Value: Tick this checkbox.
  • Click on Run search

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.

  • Select the rows that you want to update: I want to search rows to update.
  • What field do you want to update: Title
  • Select type of edit: Remove duplicates
  • Click on Run search

Done!

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

You can download the plugin here:

Download WooCommerce Products Spreadsheet Plugin - or - Read more

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