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 vote318 views4 answers
Wordpress get current taxonomy
PHP
0 vote338 views1 answer
Array filter php get first object
PHP
1 vote250 views1 answer
Php preg_match unknown modifier 'g'
PHP
0 vote287 views2 answers
Mysqli::real_connect(): (HY000/1045): Access denied for user 'pma'@'localhost' (using password: NO)
PHP
0 vote287 views2 answers
Warning: mysqli_fetch_all() expects parameter 1 to be mysqli_result, bool given in C:\newxammp\htdocs\learn\index.php on line 11
PHP
0 vote290 views1 answer
Yii 1 clear cache
PHP
4 votes348 views1 answer
Laravel add utility class
PHP Laravel
0 vote296 views1 answer
Setup laravel on AWS
PHP Laravel
1 vote318 views2 answers
Decode jwt token laravel
PHP Laravel
0 vote297 views1 answer
Double pipe in php
PHP