/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

3 votes196 views1 answer
Arraylist of objects in java
TypeScript
1 vote181 views1 answer
Get posts from selected taxonomy
TypeScript
9 votes203 views4 answers
Error TS2564: Property 'description' has no initializer and is not definitely assigned in the constructor. in angular class
TypeScript
1 vote223 views1 answer
React typescript onclick stop propagation
TypeScript
0 vote203 views1 answer
Type script
TypeScript
12 votes281 views4 answers
React event typescript
TypeScript
1 vote199 views1 answer
Sqlite.create "capacitor" cannot read property 'then' of undefined
TypeScript
0 vote319 views1 answer
Warning: format ‘%s’ expects argument of type ‘char *’, but argument 2 has type ‘int’
TypeScript
0 vote230 views1 answer
Get number of digits in an integer python without converting to string
TypeScript
0 vote196 views1 answer
Curl send 100 requests parallel
TypeScript