WooCommerce – Remove Duplicate Products with Same Descriptions

posted in: Guides | 0

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 and set these values:

  • Check the “I understand it will update the posts from my search” checkbox.
  • Select “Content” as the column you’ll edit.
  • Select “Delete duplicates” as the type of edit you’ll apply.
  • Hit the “Execute now” button.
  • Done! Now all your products with duplicate descriptions will be deleted.

With WP Sheet Editor it’s really easy to delete products with duplicate descriptions containing a keyword in their titles. For that, you need to take these really simple steps.

So the first step you need to take is to open the “Bulk Edit” tool. This tool will help you apply changes to thousands of products at once; in this case, you’ll delete all products containing duplicate descriptions from your WooCommerce store.

Once you open the Bulk Edit tool, you need to hit the “Select rows”, which will help you filter your products by keyword.

Now the only things you need to do is to enter the product keyword in the “Contains keyword” field and then hit the “Run search” button.

Once you’re back in the Bulk Edit tool, you need to set these values to delete your products with duplicate descriptions:

  • Check the “I understand it will update the posts from my search” checkbox.
  • Select “Content” as the column you’ll edit.
  • Select “Delete duplicates” as the type of edit you’ll apply.
  • Hit the “Execute now” button.
  • Done! Now all your duplicate products containing a keyword will be deleted.

 

If you want to delete all your products containing duplicate descriptions by category, attribute, or tag, you simply need to open the “Bulk Edit” tool by clicking it on the toolbar.

After opening the tool, you need to open the “Select rows” button, which will open a search tool to filter your products.

Once there, you need to enter the product category, attribute or tag in the “Enter Product category…” field. It’s important to notice that this field allows you to search for your products in those three ways.

After that, just hit the “Run search” button.

Once back in the Bulk Edit tool, set these values to delete your products with duplicate descriptions:

  • Check the “I understand it will update the posts from my search” checkbox.
  • Select “Content” as the column you’ll edit.
  • Select “Delete duplicates” as the type of edit you’ll apply.
  • Hit the “Execute now” button.
  • Done! Now all your products containing duplicate descriptions and containing a category, attribute or tag will be deleted.

If you want to delete all your downloadable products with duplicate descriptions, you need to open the “Bulk Edit” tool, which allows you to apply changes to thousands of products at once.

Then, you need to hit the “Select rows” button, which will open a search tool for you to filter your products.

After that, you need to check the “Enable advanced filters” checkbox and set these values to look for your downloadable products:

  • Select “_downloadable” in the “Field key”.
  • Select “=” in “Operator”.
  • Check the “Value” checkbox.
  • Hit the “Run search” button, which will take you back to the Bulk Edit tool.

Once back in the bulk edit tool, set these values to delete your downloadable products containing duplicate descriptions:

  • Check the “I understand it will update the posts from my search” checkbox.
  • Select “Content” as the column you’ll edit.
  • Select “Delete duplicates” as the type of edit you’ll apply.
  • Hit the “Execute now” button.
  • Done! Now all your downloadable products containing duplicate descriptions will be deleted.

Easy!

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

Leave a Reply