/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 vote201 views1 answer
Update multiple documents with different field value by id set. Mongoose
TypeScript
0 vote195 views1 answer
Change field name relation typeorm
TypeScript
3 votes194 views3 answers
Cannot find module 'typescript' angular 9
TypeScript
0 vote185 views1 answer
Python set remove duplicate elements
TypeScript
0 vote195 views1 answer
React-stripe-elements hidePostalCode
TypeScript
3 votes201 views1 answer
Ts reverse array
TypeScript
5 votes189 views3 answers
Simbu type1
TypeScript
0 vote177 views1 answer
Restaurants near me
TypeScript
0 vote184 views1 answer
.find angular how does it work
TypeScript
1 vote220 views2 answers
Typescript submit event
TypeScript