/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

7 votes169 views3 answers
Ts await foreach loop
TypeScript
0 vote181 views1 answer
Cannot find name 'modalRef'
TypeScript
0 vote187 views1 answer
Get elements by id like jquery
TypeScript
2 votes203 views1 answer
Mat-form-field email validation
TypeScript
0 vote195 views2 answers
How to see constraints in postgresql
TypeScript
7 votes194 views2 answers
Typed usestate
TypeScript
2 votes195 views1 answer
React native paper select
TypeScript
1 vote180 views1 answer
Whats the file path for the documents folder linux
TypeScript
3 votes181 views3 answers
E.target.value typescript
TypeScript
2 votes193 views2 answers
Typescript iterate over enum
TypeScript