WooCommerce – Remove Thousands of Duplicate Products in Seconds

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

- or - Read more about it

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

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
  • Click on Execute now

With this plugin it’s really easy to delete duplicate products by keyword, status, category, attribute, or tag.

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, status, category, attribute, or tag

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 find the following fields to make your search:

  • Contains keyword: Any keyword to search all products containing it.
  • Status: Draft, Published, Scheduled, etc.
  • Enter Tags: Categories, Attributes, and Tags.

After selecting the search method, 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
  • Click on Execute now

Done! Now all your duplicate products will be deleted.

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
  • Click on Execute now

Done! Now all your duplicate downloadable products be deleted.

Easy!

As you can see, deleting duplicate products is really easy with WP Sheet Editor.

You can download the plugin here:

- or - Read more about it

Close Menu