In this tutorial, we will show you how to bulk delete WooCommerce products with the same description or short description. This means that of all the products with the same product description or short description, we will only keep one.
When we import WooCommerce products, we can end up with duplicate products if the import is not done right. But for whatever reason you have products with the same description, it’s important to be able to remove duplicates easily.
However, that’s not possible with WooCommerce simply. You need some help, and that’s why in this tutorial we’ll use the WP Sheet Editor – WooCommerce Products plugin.
This plugin allows you to view and manage your WooCommerce products in a spreadsheet interface.
You can download the plugin here:
Download WooCommerce Products Spreadsheet Plugin - or - Check the features
Since you’ll remove products, you need to make sure to avoid showing 404 errors to your users after removing duplicates.
You need to create 301 redirections to the remaining products. Fortunately, with WP Sheet Editor, the redirections can be created automatically.
You just need to install these two elements:
- Install the Redirection plugin to create the redirection links.
- Install the WP Sheet Editor – Redirection extension.
Once both the two plugins 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.
1- Open the products’ spreadsheet
You can open the products’ spreadsheet by going to WP Sheet Editor > Edit products.
When you open the plugin, you’ll see a spreadsheet with all your products and their complete data.
2- Open the Bulk Edit tool
To remove all the products with duplicate descriptions / short descriptions, you need to use the Bulk Edit tool.
Something important: Products missing descriptions will not be deleted, so don’t worry about accidentally removing products missing descriptions because that won’t happen.
3- Bulk delete products with the same description or short description
To delete products with the same description, we have two options.
We can delete products with the same text in the “Product description” (Content) field, or we can delete products with the same text in the “Short description” field.
a) Delete products with the same product description
You need to select these values in order to remove products with the same content (product description):
- 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 (this field is for the product descripion field)
- Select type of edit: Remove duplicates
- Which duplicates do you want to delete: You have these two options:
- Delete the newest items and keep the oldest items
- Delete the oldest items and keep the newest items
- Select the Edit only parent products option.
- Click on Execute now
b) Delete products with the same short description
You need to select these values in order to remove products with the same content (product description):
- 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: Short description
- Select type of edit: Remove duplicates
- Which duplicates do you want to delete: You have these two options:
- Delete the newest items and keep the oldest items
- Delete the oldest items and keep the newest items
- Select the Edit only parent products option.
- Click on Execute now
As you can see, deleting products with duplicate descriptions is really easy with WP Sheet Editor – WooCommerce Products.
You can download the plugin here:
Download WooCommerce Products Spreadsheet Plugin - or - Check the features