How to Bulk Delete Products in WooCommerce?

Looking to delete WooCommerce products in bulk? Whether you’re cleaning up old listings or removing test items, bulk product deletion can save you hours. Check out the fastest ways to do it from your WooCommerce dashboard or by utilizing a CSV file with the premium version of the Product Import Export Plugin.

Running a WooCommerce store often involves keeping your product catalog up to date, removing outdated, duplicate, or test items to ensure everything stays fresh and relevant. But let’s be honest, manually deleting products one by one through the WooCommerce Products page can be a real drag, especially if you have a large inventory.

That’s where bulk deletion comes into play. WooCommerce’s built-in Bulk Actions tool allows you to delete several products right from the dashboard, but it can be a bit cumbersome if you have a large inventory. A quicker and more efficient alternative is to use a CSV file with the premium version of the Product Import Export Plugin for WooCommerce. In this article, we’ll explore both methods so you can decide which one works best for your store.

Let’s get started.

1. Clean Up Outdated or Discontinued Products

Over time, your store may accumulate products that are no longer relevant. Maybe they’re out of stock, discontinued, or part of an old collection. Keeping these around clutters your catalog and can confuse customers.

2. Remove Test or Duplicate Listings

If you’ve been experimenting with your store or have imported data multiple times, you might have test products or accidental duplicates. Bulk deletion helps clear these in one go.

3. Save Time Compared to Manual Deletion

Deleting products one by one from the Products page can be painfully slow, especially if you have hundreds or thousands to remove. Bulk deletion streamlines this process, significantly cutting the time and hassle.

4. Improve Store Performance and Navigation

A cleaner catalog isn’t just visually better; it can also help your store load faster and make navigation easier for customers, which improves the overall user experience.

5. Prepare for Seasonal or Strategic Changes

Doing a product refresh for a new season? Switching to a different inventory strategy? Bulk deleting products helps you reset and organize your store in line with new goals or campaigns.

When it comes to cleaning up your WooCommerce product catalog, there are two main ways to bulk delete products: using the default WooCommerce bulk action tool or using a CSV file with the Product Import Export Plugin for WooCommerce (Premium).

Let’s look at both.

a. Using the Default WooCommerce Bulk Actions Tool

WooCommerce includes a basic Bulk Actions feature that allows you to select multiple products from the Products page in your WordPress dashboard and delete them at once. For this,

• Go to Products > All Products.

• Use the checkboxes to select the products you want to delete.

• From the Bulk Actions dropdown, choose Move to Trash and click Apply.

Limitations of this method:

• Limited visibility: You can only see and select a set number of products per page, requiring manual selection across multiple pages.
• Time-consuming: Selecting and deleting products in batches can be tedious, especially if you have hundreds or thousands.
• No filters for custom conditions: You can’t easily filter products by SKU, category, stock status, or other custom fields.

b. Using a Product Import Export Plugin (Recommended)

If you want the quickest, most efficient way to delete large batches of WooCommerce products, using the premium version of the Product Import Export Plugin for WooCommerce is highly recommended. Unlike manual deletion, which can be slow and prone to errors, this method lets you remove hundreds or even thousands of products in just a few clicks, making it ideal for large stores, catalog clean-ups, seasonal refreshes, or bulk product updates.

By leveraging a CSV file, the plugin identifies exactly which products to delete, ensuring accuracy and control over the process. This approach is especially useful when you’re dealing with variable products, outdated items, imported catalogs, or products coming from external inventory systems.

Requirements:

1. Premium version of the Product Import Export Plugin for WooCommerce

The advanced features required for bulk deletion, including delete actions and deeper product control, are only available in the premium version. These capabilities go beyond simple imports and exports, giving you full flexibility to manage your product catalog.

2. A properly formatted CSV file

To delete products, your CSV file must include key identifiers such as:

• Product ID
• SKU
• Or any other unique identifier

Along with these identifiers, the CSV should include a dedicated column specifying the delete action (e.g., Delete, Remove, or the exact keyword required by the plugin). During the import process, the plugin will read this action and automatically delete the matching products from your store.

Here’s a quick overview of what we’ll be doing:

• Export products from your store to a CSV file using the Product Import/Export Plugin.
• Edit the CSV to remove the products you no longer want on your site.
• Re-import the file using the same plugin, this time with the “Delete non-matching products from store” option enabled. This will delete all products not listed in the CSV.

Exporting Products into a CSV File

Now, follow the steps below 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, as well as access advanced options like scheduling, batch exporting, and more.

• In the Delimiter drop-down, choose a separator (comma, semicolon, 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 Export to start exporting your products.

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

Now let’s proceed to importing these product files.

Import Products for Bulk Deletion

Follow the steps below 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 the Import/Schedule button and select Import.

After the import process is completed, the plugin will compare the products listed in your CSV file with the products currently in your WooCommerce store. Any product not included in the CSV will be automatically removed. This ensures that only the products you intentionally keep — those present in the CSV — remain in your catalog.

Advantages of this method:

• Fast Bulk Deletion: Quickly delete large inventories with just a few steps—ideal for stores with hundreds or thousands of products.
• Targeted Control: Filter and delete by any product field, such as SKU, ID, name, or category, giving you precise control over what stays and what goes.
• No Manual Selection: No need for manual selection or scrolling through multiple pages in the dashboard.
• Up-to-Date Inventory: Keeps your product catalog up to date by automatically removing outdated or irrelevant items, helping you maintain a clean and relevant storefront.
• Error-Free Execution: Minimizes human error by using structured CSV data for deletion, ensuring accuracy.
• Automated Maintenance: Supports scheduled or repeat deletion tasks, making it perfect for ongoing store maintenance and inventory refreshes.

This article aims to show you how to delete products in bulk via CSV in WooCommerce. There are several instances where 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 make your effort easier.

The WooCommerce Product Import Export plugin, 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 questions, drop them in the comments section; we’ll be happy to help you.