How to Delete Products in Bulk via CSV in WooCommerce?

Did you know there’s an easy way to bulk delete products on your WooCommerce store other than deleting them from the WooCommerce Products page? If not, dive in, and we will show you how to easily delete products in bulk in WooCommerce.

If you have hundreds and thousands of products to delete, you can quickly do that with a CSV file containing the product data and the premium version of the Product Import Export Plugin For WooCommerce.

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 with the same Product Import Export Plugin.
  • Next, we’ll edit the CSV file to remove any products we don’t want to keep on our site.
  • Finally, we’ll use the same plugin with the “Delete non-matching products from store” option enabled to import the CSV file into our store.

With that being said, let’s get started.

How to Bulk Delete Products in WooCommerce?

Prerequisites:

  • Install and activate the Product Import Export Plugin by WebToffee.
  • Export products from your store using the Plugin. (You can also specifically export products using this plugin)
  • Edit the CSV file and remove the products you don’t want to keep on your website.

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

  1. Select Products as the post type to import

    Go to WebToffee Import Export (Pro) and select Import. From the dropdown menu, select Product as the post type to import.

    Select Products as the post type to import

  2. Select the Advanced import method

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

    Proceed to the next 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.

    Mapping columns

  4. Select the option to delete products in the store

    In the next step, the Advanced Options section. Choose to update the existing products in the store. Then, you will find an option to delete non-matching products from the store.
    Delete non matching products

    Enable the option to delete products from your store that are not presented in the CSV file.
    Now you can click on the Import/Schedule button.

Import progress log

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

Also Read: What are SKU and Parent SKU?

Conclusion

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.

This article aimed to show you how to delete products in bulk via CSV in WooCommerce. If you have any queries, drop them in the comments section; we will be happy to help you.

We also recommend you read the below article:

Article by

Anjali is a Testing Engineer at WebToffee who loves working on WordPress and WooCommerce with a passion for doodling the experiences of her life.

Comments (9)

Got any query? Please leave a comment or reach out to our support

Your email address will not be published. Required fields are marked *