/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 vote259 views1 answer
How to get all the points of the circufrence python
TypeScript
1 vote314 views2 answers
When i console log a obj its printing object
TypeScript
0 vote266 views1 answer
Convert object to list of objects c#
TypeScript
2 votes266 views2 answers
Font family system
TypeScript
0 vote248 views2 answers
Property 'attributes' does not exist on type 'eventtarget'
TypeScript
2 votes245 views1 answer
Router navigate pass params
TypeScript
1 vote241 views1 answer
Div contenteditable maxlength reactjs
TypeScript
1 vote297 views1 answer
Css fonts system
TypeScript
0 vote216 views1 answer
Get number of digits in an integer python without converting to string
TypeScript
2 votes265 views1 answer
Serenity-is hide column
TypeScript