WooCommerce – Delete Thousands of Duplicate Products

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.

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:

  1. Install the Redirection plugin to create the redirection links.
  2. 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.

woocommerce products in a spreadsheet or table

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:

woocommerce remove all duplicate products

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

bulk remove duplicates in woocommerce

Then just set these values:

woocommerce delete duplicate products

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

bulk remove duplicates in woocommerce

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.

search for duplicate products in woocommerce

Now just enter the keyword:

woocommerce search duplicate products by 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:

remove duplicate products in woocommerce

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

view woocommerce products in a spreadsheet open bulk editor

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.

search for duplicate woocommerce products

Here you’ll see the fields you will use to make your search:

find woocommerce products by category, attribute, tag

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

delete duplicate products in woocommerce

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

view woocommerce products in a spreadsheet

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.

search for downloadable products in woocommerce

Now you need to do this in order to filter all downloadable products:

woocommerce search for duplicate 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:

woocommerce remove duplicate downloadable 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 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.

sheet editor open bulk edit tool

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.

woocommerce search for variations

This will open the Search tool, where you can search for the product variations:

woocommerce search for 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:

woocommerce bulk remove duplicate variations

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

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