/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

1 vote173 views1 answer
Ts get year from date
TypeScript
0 vote163 views1 answer
Serenity-is change button text
TypeScript
0 vote180 views1 answer
Brickccolor scripts roblox
TypeScript
0 vote226 views6 answers
How to find nuber of tweets per day using python
TypeScript
0 vote181 views1 answer
IC markets minimum deposit
TypeScript
0 vote168 views1 answer
Terminal update file metadata
TypeScript
0 vote192 views1 answer
Flutter: Error: google_fonts was unable to load font LobsterTwo-Bold because the following exception occured:
TypeScript
2 votes239 views1 answer
'mat-checkbox' is not a known element
TypeScript
17 votes172 views4 answers
Pygame mouse events
TypeScript
9 votes170 views2 answers
Delete all child elements jquery
TypeScript