/PHP/How to delete all products woocommerce in phpmyadmin

How to delete all products woocommerce in phpmyadmin

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';

Source: wpfluent.com

Similar codes

0 vote192 views1 answer
Laravel ID Generator
PHP
2 votes208 views1 answer
Img upload in php
PHP
10 votes217 views4 answers
Import session laravel
PHP Laravel
0 vote243 views1 answer
Imagefont.truetype python don't work
PHP
0 vote186 views1 answer
Laravel nginx
PHP
1 vote224 views1 answer
How validate if one parameter is exist another parameter must exist in laravel
PHP Laravel
20 votes205 views6 answers
Php error
PHP
0 vote197 views1 answer
Check date php
PHP
8 votes230 views2 answers
Store file into specific directory laravel using storage facade
PHP Laravel
8 votes192 views4 answers
Wordpress enqueue if shortcode
PHP