/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

1 vote288 views1 answer
Challenges in agile
TypeScript
0 vote294 views1 answer
Match a string that starts and ends with the same vowel
TypeScript
2 votes282 views2 answers
Change material ui appbar color
TypeScript
0 vote292 views1 answer
Check in Recat if an url is of image or video
TypeScript
0 vote337 views1 answer
Typescript class import csv file
TypeScript
1 vote297 views1 answer
Ng-select disabled
TypeScript
0 vote293 views1 answer
C# copy the elements of a list to another list
TypeScript
0 vote309 views1 answer
Print query from get_posts wordpress
TypeScript
1 vote274 views1 answer
Typescript use object keys as index
TypeScript
2 votes286 views2 answers
Length array angular
TypeScript