So you’ve got a few thousand products on your WooCommerce store? I bet you may have bumped your head trying to figure out how to remove your products in bulk.
Sure there is the most common way which is to select Producs > All products from your dashboard and selecting Screen Options and tweaking and fine tuning the most amount of products you can safely remove at a give time by selecting all in bulk and pressing delete.
The problem is that your system resources get exhausted and you end up with an error.
So you can probably up your number of items on page to around 200 or maxing out at 300. I’ve even managed to push it to 600 products by adjusting some server settings and maxing them out.
Realistically though, we only used this method once years ago. It is NOT worth it unless you don’t actually want to delete all your products and that’s ok if that’s what it is but when you import thousands of products at a time to cater for a dropshipping website or a manufacturer handing you their old CSV and asking you to make sense of it, then all of this changes very quickly.
So, you’ve made a boo-boo on your import of 22 000 products and now have to delete them 200 products at a time? Wow, if that one option of deleting products doesn’t boggle ones mind in order to seek a better way of doing it, I don’t know what will.
Luckily though, we know the power of databases and instruction strings… I will admit I am not a full blown expert on SQL databases but I know my way around them. Especially when you know where to go.
Here is the ULTIMATE way of removing ALL of your Woocommerce products in about 5 minutes, let’s get started:
STEP 1:
You’ll need access to your SQL database, for this example, we’re going to use the CPanel method, because CPanel is very widely used.
If you aren’t using CPanel, well, don’t worry – Just head to the database section in your hosting and select “PHP My Admin” or anything around this. Worst case scenario, you are welcome to ask us for assistance, just visit CONTACT US and fill in the form, free of charge, 😉
First thing is to gain access to your Cpanel and follow the quick steps in the below screenshots:
Next up is to select your relevant database – In most cases you should probably only have one database here.
STEP 2:
Select the SQL tab and copy the code below and paste it in this section.
DELETE relations.*, taxes.*, terms.*
FROM wp_term_relationships AS relations
INNER JOIN wp_term_taxonomy AS taxes
ON relations.term_taxonomy_id=taxes.term_taxonomy_id
INNER JOIN wp_terms AS terms
ON taxes.term_id=terms.term_id
WHERE object_id IN (SELECT ID FROM wp_posts WHERE post_type=’product’);
DELETE FROM wp_postmeta WHERE post_id IN (SELECT ID FROM wp_posts WHERE post_type = ‘product’);
DELETE FROM wp_posts WHERE post_type = ‘product’;
STEP 3:
When you’ve pasted the SQL Query, go ahead and select “Go” and let it run… it should be fairly quick…and….
You’re done! That’s it. So it may have taken you ten minutes or so but imagine that it would probably take you no more than a few minutes if you knew your way around the second time 😉
We hope you’ve found this article on the How-To’s of our WordPress useful, in this case WooCommerce but none the less, easy as pie 🙂
Happy selling and chat soon peeps.
Adios!

Hello. This post was extremely remarkable, especially since I was looking for thoughts on this issue last couple of days. Pietra Bartlet Gemperle
Definitely, what a great site and educative posts, I surely will bookmark your blog. Best Regards! Cortney Thibaud Conger
Thanks Cortney
I visited several websites except the audio feature for audio songs present at this site is actually marvelous. Tracee Moe Darrin
Thanks Tracee
This article will assist the internet viewers for creating new webpage or even a weblog from start to end. Jacquenetta Abbey Bondie