Website Design Hub

woocommerce-bulk-remove-products

How to remove all Woocommerce Products

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:

Website Design in East Rand - Web Design Hub

Next up is to select your relevant database – In most cases you should probably only have one database here.

Website Design in East Rand - Web Design Hub

STEP 2:

Select the SQL tab and copy the code below and paste it in this section.

Website Design in East Rand - Web Design Hub

STEP 3:

When you’ve pasted the SQL Query, go ahead and select “Go” and let it run… it should be fairly quick…and….

Website Design in East Rand - Web Design Hub

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!

webdesignhub
Rapheala Scabia
Crazy, Fun and Outspoken Web Designer & Developer at Webdesign Hub

6 thoughts on “How to remove all Woocommerce Products”

  1. Hello. This post was extremely remarkable, especially since I was looking for thoughts on this issue last couple of days. Pietra Bartlet Gemperle

  2. I visited several websites except the audio feature for audio songs present at this site is actually marvelous. Tracee Moe Darrin

Leave a Comment

Your email address will not be published.