How to Bulk Delete Products in WooCommerce?

Learn a simple way to bulk delete products from your WooCommerce store without navigating through the Products page. By using a CSV file along with the premium version of the Product Import Export Plugin for WooCommerce, this article explains how to bulk delete products.

Did you know there’s an easy way to bulk delete products on your WooCommerce store besides deleting them from the WooCommerce Products page? If you have a large inventory, this method can help you save a lot of time and effort.

Using a CSV file with the premium version of the Product Import Export Plugin for WooCommerce, you can swiftly and effectively delete hundreds or even thousands of products at once. This efficient method not only makes inventory management easier but also keeps your store organized and current.

In this article, we will dive into deleting products in bulk in WooCommerce.

Let’s get started.

Let’s give a quick summary of what we will be doing:

• Firstly, we will export the products into a CSV file from your store using the same Product Import Export Plugin. 
• Next, we will edit the CSV file to remove any products we don’t want to keep on our site. 
• Finally, we will use the same plugin with the “Delete non-matching products from store” option enabled to import the CSV file into our store.

Exporting Products into a CSV File

Now follow the below steps to export products from your WooCommerce store. 

Step 1: Install & Activate the WebToffee Product Import Export Plugin

• After purchasing the plugin, download the plugin file from My Account > Downloads. 
• Go to Plugins > Add New Plugin from your WordPress dashboard and upload the plugin file.
• Install and Activate the plugin.

Step 2: Select Product as Post Type for Export 

After you have installed and activated the plugin, let’s see how the export process is carried out.

• Go to – WebToffee Import Export (Pro) > Export. 

• Choose the post type as Product and proceed to select the export method.

Step 3: Choose Advanced Export Method

• Now select the method for exporting the products. You will have two options: Quick export and Advanced export. 
• Let’s select Advanced export and proceed to the next step. 

Step 4: Filter Product Data to Export 

Here, you can customize the export by selecting the number of products to be exported and specifying which products, categories, or tags to include or exclude.

However, if you want to export all products, it’s best to skip these steps.

Step 5: Map and Rename Export Columns

Here, you can decide which information to export and how to organize it. You can rearrange the product fields, rename the columns, and select specific fields to appear in the output export file.

Since we have to export all the products, you can skip configuring and proceed directly to the next step. If you prefer to rename or rearrange any fields, you can do so before moving forward.

Step 6: Set Advanced Options/Batch Export of Products 

In this final step, you can customize the export file name and format and access advanced options like scheduling, batch exporting, and more.

• In the Delimiter drop-down, choose a separator (comma, semi-colon, tab, space) that differentiates columns in the CSV file. 

• Select the number of products to be exported in a single batch. By default, it’s set to 100.

• Once done, click on Export to start exporting your products.

You can then download the CSV file and modify it to remove any products you no longer wish to keep on your site.

Now let’s proceed to importing these product files.

Import Products for Bulk Deletion

Follow the below steps to import products using the same plugin and delete them in bulk from your WooCommerce store. 

Step 1: Select Product as the Post Type to Import

Once you have installed the plugin,

• Go to WebToffee Import Export (Pro) and select Import.
• Select Product as the post type to import from the dropdown menu.

Step 2: Select Advanced Import Method

Here, you may select the Advanced import option and upload the CSV file you prepared earlier.

Proceed to the next step.

Step 3: Map Imported Columns to Product Data Fields

Here, you can map the CSV file to the WooCommerce data fields. Mapping is required to ensure that the column headers in the CSV file match the corresponding WooCommerce data fields.

Step 4: Set Advanced Options for Product Import

This is the final step in importing products, and here, we will configure the option to delete products in bulk. 

• Choose to Update the existing products in the store. 
• Then, you will find an option to Delete non-matching products from store. Enable the option to delete products from your store that are not presented in the CSV file.
• Now, click on the Import/Schedule button and select Import. 

After successfully importing the products, all existing products in the store that are not in the CSV file will be removed.

This keeps your store’s product inventory current by automatically removing outdated or irrelevant items. Additionally, the plugin minimizes the chance of human error and speeds up the process. This automated removal helps maintain a clutter-free store, ensuring that customers only view the most recent and relevant products.

This article aimed to show you how to delete products in bulk via CSV in WooCommerce. There are quite a few instances in which you may need to delete products in bulk from your WooCommerce store. Deleting each product from the WooCommerce Products page can be daunting. This is why you need a plugin to ease your effort.

The WooCommerce Product Import Export plugin we mentioned in this article also has a free version with some basic features you’re looking for. Check out the free plugin and see if it suits your requirements.

However, if you need advanced product filtering options and bulk delete products, you’ll need to purchase the premium version.

If you have any queries, drop them in the comments section; we will be happy to help you.