/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 vote117 views1 answer
Return the Objects Keys and Values
TypeScript
0 vote115 views1 answer
Loop localstorage
TypeScript
1 vote123 views3 answers
Typescript range
TypeScript
3 votes121 views3 answers
File C:\Users\Praveen\AppData\Roaming\npm\ng.ps1 cannot be loaded because running scripts is disabled on this system. For more information, see about_Execution_Policies at https:/go.microsoft.com/fwlink/?LinkID=135170.
TypeScript
1 vote107 views1 answer
Get all documents in collection firestore flutter
TypeScript
3 votes114 views1 answer
Typescript object key from other object
TypeScript
0 vote114 views1 answer
How to make game objects spread in a specific vector
TypeScript
3 votes122 views1 answer
Google chrome extensions content scripts matches
TypeScript
1 vote134 views1 answer
Get distance beetwen two points roblox
TypeScript
0 vote109 views1 answer
Ionic email validation
TypeScript