WooCommerce – Remove Duplicate Products with Same Descriptions

Sometimes you import thousands of products from the wholesaler and you make a mistake during the import, and you end up with hundreds of duplicate products.

Now you have 2 choices:

  • Delete everything and import again, which means double work
  • Or just delete the duplicates quickly

In this article, we’ll show you how to delete hundreds of products with duplicate descriptions in seconds using WP Sheet Editor.

Install WP Sheet Editor

This plugin allows you to apply changes to lots of products at once with its powerful Bulk Edit tool.

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.

Important. Products missing descriptions will not be deleted.

To delete all your products containing duplicate descriptions, 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: Content
  • Select type of edit: Remove duplicates
  • Click on Execute now

    With WP Sheet Editor it’s really easy to delete products with duplicate descriptions 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 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: Content
    • Select the type of edit: Remove duplicates
    • Click on Execute now

    Done! Now all your products with duplicate descriptions will be deleted.

    With WP Sheet Editor it’s really easy to delete all your downloadable products with duplicate descriptions.

    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: Content
    • Select the type of edit: Remove duplicates
    • Click on Execute now

    Done! Now all your downloadable products with duplicate descriptions will be deleted.

    Easy!

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

    Close Menu