/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 vote106 views1 answer
React inherit html input props
TypeScript
0 vote108 views1 answer
Three requirements for laser action
TypeScript
0 vote100 views1 answer
The Effects of Boredom, Loneliness, and Distress Tolerance on Problem Internet Use Among University Students
TypeScript
4 votes104 views1 answer
Map vs for each
TypeScript
-1 vote118 views1 answer
Components of api request
TypeScript
2 votes140 views1 answer
Laravel model dont exists id
TypeScript
1 vote108 views1 answer
Property 'unsubscribe' does not exist on type 'Observable<Object>'
TypeScript
1 vote130 views1 answer
Type script edeode url
TypeScript
1 vote65 views1 answer
Mongoose project first element from array
TypeScript
9 votes100 views1 answer
How to print list letters without commas in python
TypeScript