/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 vote290 views1 answer
Defining constant in config laravel
PHP
0 vote303 views3 answers
Mail sending setting magneto for mailhog
PHP
1 vote264 views1 answer
Mb_strtolower
PHP
8 votes343 views3 answers
Validate time in laravel
PHP Laravel
0 vote294 views1 answer
Lengthawarepaginator gives keys on page 2
PHP
25 votes275 views4 answers
Start php server
PHP
1 vote283 views1 answer
Wp get image alt
PHP
0 vote245 views1 answer
Markdown mail html rendering laravel
PHP
1 vote259 views3 answers
Php ?:
PHP
0 vote291 views1 answer
Laravel sendgrid using 2 possible authenticators. Authenticator LOGIN returned Expected response code 250
PHP