/TypeScript/Woocommerce bulk product delete

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

11 votes217 views1 answer
Check open ports windows
TypeScript
0 vote235 views1 answer
Angular build router-outlet not working
TypeScript
0 vote248 views1 answer
Pass data through router angular
TypeScript
0 vote246 views1 answer
C++ count frequency of elements vector
TypeScript
0 vote253 views1 answer
Google map Argument of type 'HTMLElement | null' is not assignable to parameter of type 'Element'
TypeScript
0 vote264 views1 answer
Node js if url is image
TypeScript
0 vote286 views1 answer
Material ui styled components with theme
TypeScript
9 votes261 views4 answers
Error TS2564: Property 'description' has no initializer and is not definitely assigned in the constructor. in angular class
TypeScript
6 votes226 views1 answer
How to read excel file with multiple sheets in python
TypeScript
0 vote247 views1 answer
Geodataframe from lat lon points python
TypeScript