/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 vote309 views1 answer
Php remove script tag from string
PHP
0 vote350 views1 answer
Wordpress - php settings
PHP Wordpress
7 votes275 views6 answers
Install laravel 7
PHP
3 votes295 views2 answers
Laravel longblob migration
PHP
0 vote320 views1 answer
Login page php mysql check if user is verified in the database before user can be logged in
PHP
9 votes392 views3 answers
Image validate in laravel validater
PHP Laravel
0 vote282 views1 answer
Mysqli fetch row assoc
PHP
0 vote343 views1 answer
Laravel new project command doesn't create vendor
PHP Laravel
0 vote361 views2 answers
How to pass bearer token in swagger in laravel
PHP Laravel
6 votes334 views3 answers
Laravel ecommerce
PHP Laravel