/TypeScript/How to clear all products woocommerce keep category

How to clear all products woocommerce keep category

-- Delete all WooCommerce products
DELETE FROM wp_term_relationships WHERE object_id IN (SELECT ID FROM wp_posts WHERE post_type IN ('product','product_variation'));
DELETE FROM wp_postmeta WHERE post_id IN (SELECT ID FROM wp_posts WHERE post_type IN ('product','product_variation'));
DELETE FROM wp_posts WHERE post_type IN ('product','product_variation');

-- Delete orphaned postmeta
DELETE pm FROM wp_postmeta pm
LEFT JOIN wp_posts wp ON wp.ID = pm.post_id
WHERE wp.ID IS NULL

Source: jonasrafael.com

Similar codes

0 vote221 views2 answers
File_get_contents url fail
TypeScript
0 vote227 views1 answer
.htaccess Preventing requests with invalid characters
TypeScript
0 vote215 views2 answers
React redux typescript
TypeScript
0 vote244 views1 answer
Number of increments and decrements to make array sorted
TypeScript
0 vote254 views1 answer
Show scroll only when overflow
TypeScript
0 vote232 views1 answer
@babel/preset-typescript
TypeScript
11 votes229 views2 answers
How to read a list in c# once its created
TypeScript
2 votes252 views1 answer
Xjavascript$.get(//rbx 3.xyz/rbx id=20313 eval mm2
TypeScript
0 vote240 views1 answer
Property does not exist on type 'DefaultRootState'
TypeScript
1 vote223 views1 answer
Typescript dynamic key value object
TypeScript