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 vote216 views1 answer
Modifier laravel migration to add a comment a column (MySQL/PostgreSQL)
PHP Laravel
2 votes177 views2 answers
Php remove non numeric
PHP
2 votes172 views2 answers
How unset request parameter in laravel
PHP
0 vote164 views1 answer
Show user only those products which he hasn't buyed laravel eloquent
PHP
0 vote167 views1 answer
Admin-ajax.php 400 (bad request)
PHP
0 vote217 views1 answer
Laravel 8 Auth Scaffolding using Inertia Jetstream
PHP Laravel
0 vote221 views1 answer
Validate rule if row exist laravel
PHP Laravel
0 vote233 views1 answer
Url() inside laravel config files
PHP Laravel
45 votes268 views6 answers
Laravel run seeder
PHP
1 vote206 views1 answer
Laravel trans with parameters
PHP Laravel