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.
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.
- 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 the Advanced import method
Here, you may select the Advanced import option and then upload the CSV file you prepared earlier.
Proceed to the next step. - 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.
- 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.
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.
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:
Comments (9)
Ralph
March 24, 2022
“Delete non-matching products from store” option is no longer in latest version of the plugin
Alan
March 24, 2022
Hi,
The option is still present in the plugin. Can you please share the plugin version installed on your site?
Vithlesh
August 22, 2021
Hii I want to delete product when I scan QR code of product through mobile, so it should delete the product directly from woocomerce database. Is it possible? If yes, than please share its solution on my mail.
vithlesh14@gmail.com
Mark
August 25, 2021
Hi,
You can delete certain products from the site by not including them in the CSV file and then import the CSV file with the Delete non-matching products from store option enabled so that all the products that are not in the SV file will be deleted. Please make sure that you either include ID or SKU in the CSV file and is mapped.
Kristian Brown
August 14, 2020
This is almost 100% the opposite way I’d want to remove products in bulk – by uploading all the details of the ones I want to keep?
I searched everywhere to find somewhere to help me delete products based on a list of SKUs given to me by a shop manager. In the end I’ve written some simple instructions using SQL to convert SKU’s to post_ids then clean up the post table and post_meta tables. I’ve shared it here; https://kristianbrown.co.uk/delete-woocommerce-products-using-skus/
Phil Birnie
October 22, 2020
I agree – it would be great if you could upload a CSV with a single column of SKUs and it would delete that set.
Alan
October 22, 2020
Hi,
Thank you for your valuable suggestion. We have included it in our development backlogs and will try to implement it in the upcoming releases.
Christian Brand
November 4, 2021
Is this feature already implemented? Currently this is exactly what I need 🙂
Alan
November 9, 2021
Hi,
Sorry to say that this feature is not yet implemented. Currently you can delete the products that are in the CSV file by setting the post_status as “trash” and those products will be moved to the trash.