WooCommerce – Bulk Delete Duplicate Variations – NO CODE

In this tutorial, we’ll show you how to delete duplicate variations in WooCommerce, without any code needed.

 

You can end up with duplicate variations when importing variable products, and it can be really difficult to delete them manually.

Another option is to remove them using code, but that’s hard.

That’s why we’ll show you how to delete duplicate product variations using WP Sheet Editor.

Install WP Sheet Editor

This plugin helps you manage your WooCommerce store, editing hundreds of products in a beautiful spreadsheet.

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

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

WooCommerce products from WP Sheet Editor Spreadsheet

1. Delete duplicate product variations by keyword

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.

bulk delete duplicate product variations

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.

make a search for products to be edited in bulk

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.

search for product variations by keyword

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 the 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.

delete duplicate product variations

  • 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

2. Remove duplicate variations by category, attribute, or tag

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.

bulk delete duplicate product variations

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

make a search for products to be edited in bulk

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

filter variations by category

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 the 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.

delete duplicate product variations

  • 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.

3. Remove duplicate product variations from downloadable products

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.

bulk delete duplicate product variations

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

make a search for products to be edited in bulk

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

search for downloadable product variations

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 the 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.

delete duplicate product variations

  • 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.

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

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.