Woocommerce bulk product delete

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

Woocommerce bulk product delete

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: siegercreations.com

Similar codes

0 vote383 views1 answer
Laravel timestamps on pivot table
PHP Laravel
-1 vote323 views1 answer
Laravel 7 generator
PHP
1 vote346 views1 answer
Codeigniter 3 Configured database connection has cache enabled
PHP
0 vote324 views2 answers
New static laravel
PHP
0 vote400 views1 answer
How to run database Query in WordPress?
PHP Wordpress
0 vote378 views1 answer
Install php extensions for magento 2
PHP
15 votes380 views6 answers
Install laravel
PHP Laravel
5 votes361 views2 answers
Array prepend php
PHP
1 vote412 views1 answer
Laravel pluralization text
PHP
46 votes326 views6 answers
For in php
PHP