Welcome to Sieger Creations Blog.
Many times it happens when you remove want to remove the products from Woocommerce in bulk like 5000 or 10,000 or even more. It consumes too much time and will be full of hectic. With the help of plugins you can remove in bulk but many time they crash the server due to low memory or less execution time of the hosting.
The best way to delete the products in Bulk is by using the MySQL database in the hosting. By going into the phpmyadmin, just run the SQL query and within 2 minutes. Here is the Process:
Step 1: Login to phpmyadmin from your Cpanel Hosting
Login to your cPanel hosting or Plesk hosting, Scroll down to database section and click on phpmyadmin.
Step 2: Select the Database
Click on the Respective database and click on SQL tab at top as shown in the below picture.

Step 3: COPY AND PASTE the below code
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 4: Click on Go Button and wait a few minutes.
Once the query is executed properly, All the products are removed. Go and check in WordPress Admin. All the products are removed.
Instructions Video
If you like this post, share it with your friends and colleagues and stay tuned for more amazing posts from us.
20 thoughts on “How to Remove Products in Bulk from Woocommerce”
it works…
thank you very much
This works perfectly, thanks!
Is there are way to have it only delete certain categories
No, For that you need to run another query.
Thanks
Sieger Creations Team
Thank you … thank you … thank you!
It worked! Thanks
Worked like a charm
Great guide very simple
Thank you so much.
Can I do this process via FTP?
Hello
No, Its a step done on PHP Myadmin side so can’t be done via FTP.
Thanks
Tushar
For me it doesn’t work as it should, is there any support?
Please connect with us on siegercreations@gmail.com.
Thanks
Tushar
Nice, works perfectly! Thanks
Nic Article bro But any other option to deleted only selected Bulk product , I have more tan one lakh products in our website My Website link https://togetherbooksdistributor.com/ , i want to deleted some 10000 products in woocommerce
If any option available to deleted multiple products
Thanks
Together Books Distributor
Thanks for the clarification. Works perfectly!
You are welcome. Thanks.
Hi Thanks For Information any update for bulk deleted product Category wise
Hello! Thanks for this helpful article about deleting all WooCommerce products from the database. I can also add that if you want to delete WooCommerce products from the database without coding, you can use Skyvia: https://skyvia.com/connectors/wordpress. Skyvia is a simple solution, and you don’t need to install it to use.
website design for b2b