/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 vote160 views1 answer
Regexp in typescript types
TypeScript
0 vote171 views1 answer
"Which of the following is the best description of the interior structure of a highly evolved high-mass star late in its lifetime but before the collapse of its iron core?"
TypeScript
0 vote158 views1 answer
If statements equals same value python
TypeScript
1 vote153 views1 answer
Json to object typescript
TypeScript
0 vote147 views1 answer
Filename requests python
TypeScript
3 votes170 views3 answers
Cannot find module typescript
TypeScript
0 vote152 views1 answer
Fragment no longer exists
TypeScript
1 vote139 views1 answer
Smooth scroll in viewportscroller
TypeScript
0 vote145 views1 answer
Ngx-numeral
TypeScript
0 vote145 views1 answer
Declaration of instance field not allowed after declaration of instance method. Instead, this should come at the beginning of the class/interface
TypeScript