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:

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.