/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 vote101 views4 answers
Laravel pluck relationship
PHP
6 votes211 views3 answers
Disable admin bar wordpress
PHP Wordpress
-1 vote101 views2 answers
Php 8 "<?="
PHP
0 vote106 views2 answers
Global variable in laravel controller
PHP
0 vote114 views1 answer
Php calling abstract static function from inside abstrac class
PHP
0 vote109 views1 answer
How to make a loop that adds numbers to a variable in php
PHP
0 vote116 views1 answer
Php startup: unable to load dynamic library 'mysqli'
PHP
0 vote115 views2 answers
Movies -inurl:(htm|html|php|pls|txt) intitle:index.of “last modified” (mp4|wma|aac|avi)
PHP
12 votes101 views3 answers
Get featured image url
PHP
5 votes164 views2 answers
Memory limit wordpress
PHP