/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 vote198 views4 answers
How to execute scripts when a button gui is pressed roblox
TypeScript
0 vote203 views1 answer
Tuple must contain two elements unity
TypeScript
0 vote192 views1 answer
Roots of grass
TypeScript
0 vote232 views1 answer
Inteface method extension angular
TypeScript
0 vote266 views2 answers
Where are WordPress Posts Stored
TypeScript
3 votes200 views1 answer
Checking if a substring exists in a string r
TypeScript
2 votes258 views1 answer
Formgroup addcontrol
TypeScript
12 votes204 views5 answers
Font awesome angular
TypeScript
0 vote194 views1 answer
Filter by list of Ids
TypeScript
0 vote241 views3 answers
How to get particular key value from array of objects in javascrip
TypeScript