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.
You can download the plugin here:
Download WooCommerce Products Spreadsheet Plugin - or - Check the features
When you open the plugin, you’ll see a spreadsheet with all your products and their complete information.
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.
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 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.
- 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.
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 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.
- 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.
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 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.
- 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.
You can download the plugin here:
Download WooCommerce Products Spreadsheet Plugin - or - Check the features