How to Bulk Delete WooCommerce Products

In this tutorial, we will show you how to delete WooCommerce products in bulk. We’ll do it using an intuitive spreadsheet inside WordPress.

You don’t have to export or import anything, nor do you have to worry about server errors when deleting hundreds or thousands of WooCommerce products.

Normally, you don’t have many search options when it comes to deleting WooCommerce products from your store. It is also possible that your server will crash because it will try to delete all products at once.

Fortunately, WP Sheet Editor – WooCommerce Products allows you to do advanced product searches and massively edit all search results. And the best thing is that you won’t get server errors, because we bulk remove products in batches.

You need to follow the steps below to delete hundreds of WooCommerce products at once from your store.

1- Open the WooCommerce Products spreadsheet

After installing and activating WP Sheet Editor on your site, go to WP Sheet Editor > Edit Products to open the products spreadsheet.

You’ll see all your WooCommerce products as rows and all their fields as columns.

2- Filter the products you’ll bulk delete

Note. If you want to bulk delete all your WooCommerce products, skip this step.

You can filter your WooCommerce products using the advanced Search tool.

It allows you to use any field of your products as a search parameter, so you can filter products by category, keyword, tag, price, stock status, stock, sale price, status, etc.

In this example, we’ll do an advanced search, because we’ll find products by keyword, category, and stock status, all at once. However, you can use the filters individually.

• Contains keyword: We’ll find all the products with the “Tshirt” keyword in the title.
• Enter Product Type, Visibility, Category, etc: Here we’ll add the “Women” category.
• Tick the Enable advanced filters checkbox and enter the following fields:
  • Field: Stock status
  • Operator: =
  • Value: Out of stock
• Click on Run search to filter your products.

After filtering your products, you’ll see all the items that match the search parameters.

3- Bulk delete all the selected WooCommerce products

The Bulk Edit tool allows you to edit hundreds of products at once.

It contains quick bulk actions that you can view and use by hovering with the mouse over Bulk Edit in the toolbar.

How to remove the products completely

If you want to delete your products completely, you can select the Delete option.

If you want to move them to the trash

Once you open the Bulk Edit tool, you need to select Edit all the rows from my current search in the dropdown Select the rows that you want to update.

Finally, click on Execute Now to bulk remove all the selected products.

How to bulk move the products to the trash

If you want to move the products to the trash instead of deleting them completely, you can open the Bulk Edit tool.

Now you need to select the following values to change the products’ status in bulk:

• Select the rows that you want to update: Edit all the rows from my current search
• What field do you want to edit: Status
• Select type of edit: Set value
• Replace existing value with this value: Here you can select the status you want to assign to your products. In this case, you can select Trash, Draft, or Delete completely.
• Click on Execute Now.

This is how you can bulk delete your WooCommerce products using the WP Sheet Editor – WooCommerce Products plugin.

You can apply this and many other bulk changes with a few clicks.

Here’s a section on our blog where you can find tutorials for the WP Sheet Editor WooCommerce Products plugin. You’ll learn how to edit many products and save hundreds of hours of work.