/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 vote135 views1 answer
How to remove text tab in wordpress editor
PHP
3 votes136 views2 answers
Blade set variable
PHP
1 vote151 views4 answers
Brew downgrade php
PHP
4 votes187 views2 answers
Php shorthand if isset
PHP
0 vote174 views1 answer
Laravel Http client throw exception if request is not successful
PHP Laravel
0 vote162 views1 answer
Laravel check if form has errors
PHP
0 vote185 views1 answer
Laravel imap - Set message flags
PHP Laravel
0 vote144 views1 answer
Php extract number from string without comma
PHP
0 vote129 views1 answer
Atom emmet php
PHP
14 votes160 views3 answers
Php code to convert to small letter
PHP