It’s very common to import products from Excel or a CSV file, but it’s easy to make mistakes, and you can end up with thousands of duplicate products.
Now, that’s a problem if you don’t have any plugin to help you with that. That’s why in this article we’ll show you how to delete duplicate products with the same title in seconds using the WP Sheet Editor plugin.
Install WP Sheet Editor
This plugin helps you easily manage your WooCommerce store because it displays all your products in a beautiful spreadsheet and contains a powerful bulk edit tool to help you apply changes to thousands of products at once.
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
Before executing the “Remove Duplicates” feature:
To avoid showing 404 errors to your users after removing duplicates, you need to create 301 redirections to the remaining products. But we can create them automatically for you. Just do this:
- Install the Redirection plugin to create the redirection links.
- Install the WP Sheet Editor – Redirection extension.
Video Guide
Text Guide
Once both the plugin and the extension are installed on your website, you can run the “Remove Duplicates” feature freely because our plugin will automatically create the 301 redirections to the remaining products.
A backup is recommended to avoid any problems.
When you open the plugin, you’ll see a spreadsheet with all your products and their complete information.
1. Delete all duplicate products
To delete all your duplicate products, you need to open the Bulk Edit tool, which is located on the plugin’s toolbar. Just click on it.
Then just set these values:
- Select the rows that you want to update: Edit all rows from my current search (even non-visible rows).
- What field do you want to edit: Title
- Select type of edit: Remove duplicates
- Which duplicates do you want to delete?: Select to delete the newest items and keep the oldest items, or vice versa.
- Click on Execute now
2. Delete duplicate products by SKU
To delete all your duplicate products by SKU, you need to open the Bulk Edit tool, which is located on the plugin’s toolbar. Just click on it.
Then just set these values:
- Select the rows that you want to update: Edit all rows from my current search (even non-visible rows).
- What field do you want to edit: SKU
- Select type of edit: Remove duplicates
- Which duplicates do you want to delete?: Select to delete the newest items and keep the oldest items, or vice versa
- Click on Execute now
Now you will not have products with repeated SKUs.
3. Delete duplicate products by keyword
With this plugin, it’s really easy to delete duplicate products by keyword.
You just need to take some simple steps:
a) Open the Bulk Edit tool
This tool helps you apply changes to thousands of products at once. It’s located on the toolbar, so just click on it to open.
b) Filter your products by keyword
Once you open the Bulk Edit tool, select I want to search rows to update in the Select the rows that you want to update dropdown.
Now just enter the keyword:
- Contains keyword: Enter any keyword to search all products containing it.
- After selecting the keyword, click on Run search to filter your products.
c) Delete duplicate products
Once you’re back in the Bulk Edit tool, you need to set these values to delete your duplicate products:
- Select the rows that you want to update: I want to search rows to update and edit all the search results
- What field do you want to edit: Title
- Select the type of edit: Remove duplicates
- Which duplicates do you want to delete?: Select to delete the newest items and keep the oldest items, or vice versa
- Click on Execute now
Now, all your duplicate products that contained the same keyword will be deleted.
4. Delete all duplicate products by category, attribute, tag, or shipping class
With this plugin it’s really easy to delete duplicate products by category, attribute, tag, or shipping class.
You just need to take some simple steps:
a) Open the Bulk Edit tool
This tool helps you apply changes to thousands of products at once. It’s located on the toolbar, so just click on it to open.
b) Filter your products by category, attribute, tag, or shipping class.
Once you open the Bulk Edit tool, select I want to search rows to update in the Select the rows that you want to update dropdown.
Here you’ll see the fields you will use to make your search:
- Enter the Categories, Attributes, Tags or Shipping Classes you want to look for.
- After selecting the taxonomies, click on Run search to filter your products.
c) Delete duplicate products
Once you’re back in the Bulk Edit tool, you need to set these values to delete your duplicate products:
- Select the rows that you want to update: I want to search rows to update
- What field do you want to edit: Title
- Select the type of edit: Remove duplicates
- Which duplicates do you want to delete?: Select to delete the newest items and keep the oldest items, or vice versa
- Click on Execute now
Done! Now all your duplicate products will be deleted.
5. Delete duplicate downloadable products
With WP Sheet Editor, it’s really easy to delete all your duplicate downloadable products.
You just need to take some simple steps:
a) Open the Bulk Edit tool
This tool helps you apply changes to thousands of products at once. It’s located on the toolbar, so just click on it to open.
b) Filter your downloadable products
Once you open the Bulk Edit tool, select I want to search rows to update in the Select the rows that you want to update dropdown.
Now you need to do this in order to filter all downloadable products:
- Tick the Enable advanced filters checkbox
- Field key: Downloadable (_downloadable)
- Operator: =
- Value: Tick this checkbox
- Click on Run search to filter your products.
c) Delete duplicates
Once you’re back in the Bulk Edit tool, you need to set these values to delete your products with duplicate descriptions:
- Select the rows that you want to update: I want to search rows to update
- What field do you want to edit: Title
- Select the type of edit: Remove duplicates
- Which duplicates do you want to delete?: Select to delete the newest items and keep the oldest items, or vice versa
- Click on Execute now
Done! Now all your duplicate downloadable products be deleted.
6. Delete duplicate product variations
Now, let’s learn how to delete duplicate product variations.
You just need to follow these simple steps:
a) Open the Bulk Edit tool
This tool helps you apply changes to thousands of products at once. It’s located on the toolbar, so just click on it to open.
b) Filter your product variations
Once you open the Bulk Edit tool, select I want to search rows to update in the Select the rows that you want to update dropdown.
This will open the Search tool, where you can search for the product variations:
- You will find the Search on variations option, so you’ll only need to check the checkbox.
- And click on Run search to filter your variable products.
c) Delete duplicate products
Once you’re back in the Bulk Edit tool, you need to set these values to delete your duplicate products:
- Select the rows that you want to update: I want to search rows to update
- What field do you want to edit: Title
- Select the type of edit: Remove duplicates
- Which duplicates do you want to delete?: Select to delete the newest items and keep the oldest items, or vice versa
- Click on Execute now
After these easy steps, all your duplicate variable products will be deleted.
Easy!
As you can see, deleting duplicate products is really easy with WP Sheet Editor.
You can download the plugin here:
Download WooCommerce Products Spreadsheet Plugin - or - Check the features