/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 vote181 views3 answers
Typescript optional parameters
TypeScript
0 vote176 views1 answer
Typescript namespace example
TypeScript
-1 vote156 views2 answers
Jquery in angular
TypeScript
7 votes169 views5 answers
How to multiply two lists in python
TypeScript
0 vote194 views1 answer
React-native-size-matters npm
TypeScript
0 vote266 views1 answer
No file or variants found for asset: assets/images.
TypeScript
5 votes219 views1 answer
Angular navigate to the same route with different parameter
TypeScript
0 vote221 views1 answer
Tar contents of current folder
TypeScript
0 vote168 views1 answer
Input deno
TypeScript
0 vote164 views1 answer
Update object in array in ngxrx store in angular
TypeScript