/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

52 votes490 views6 answers
Length of an array javascript
TypeScript
1 vote170 views2 answers
Typescript null and undefined check
TypeScript
0 vote258 views1 answer
What kind of projects is suitable for the Agile methodology
TypeScript
0 vote172 views1 answer
Loc with multiple conditions
TypeScript
0 vote169 views1 answer
How to choose automation over manual testing
TypeScript
3 votes182 views1 answer
Parsing error: "parserOptions.project" has been set for @typescript-eslint/parser.
TypeScript
1 vote158 views1 answer
Typescript assigning parameter is forbidden
TypeScript
0 vote158 views1 answer
Add key value pair to all objects in array
TypeScript
0 vote170 views3 answers
Convert typescript to js online
TypeScript
-1 vote172 views1 answer
"gcm_sender_id":"15057814354"
TypeScript