/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 vote126 views5 answers
Movie Name -inurl:(htm|html|php|pls|txt) intitle:index.of “last modified” (mp4|wma|aac|avi)
PHP
0 vote166 views1 answer
Dropzone in php
PHP
0 vote134 views1 answer
Laravel request protected prop
PHP
0 vote122 views1 answer
Laravel inline if else if
PHP
1 vote147 views1 answer
Laravel insert or ignore
PHP
5 votes148 views2 answers
Current loggedin user laravel
PHP Laravel
1 vote154 views3 answers
Laravel check if item is in collection
PHP
1 vote164 views2 answers
How to delete image from aws using laravel 8
PHP
0 vote101 views2 answers
Laravel restrict home route access
PHP Laravel
4 votes139 views1 answer
Uuid nom package for laravel 18.04
PHP