/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 vote128 views1 answer
Replace '\n' in string angular
TypeScript
1 vote132 views1 answer
React functional components setstate callback
TypeScript
4 votes128 views2 answers
When to do manual testing
TypeScript
2 votes144 views1 answer
Jquery check value exists in array
TypeScript
0 vote147 views1 answer
Minimum requirements to start it company
TypeScript
0 vote186 views1 answer
Check type of object typescript
TypeScript
0 vote136 views1 answer
Haskell list of lists to list
TypeScript
0 vote132 views1 answer
Best way to round to two typescript
TypeScript
0 vote143 views1 answer
Hardness of water is due to the presence of salts of
TypeScript
-1 vote172 views1 answer
Top data scientists in the world
TypeScript