/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 vote369 views1 answer
Activate virtualenv scripts
TypeScript
1 vote297 views2 answers
React-scripts
TypeScript
1 vote291 views1 answer
Ionic 3 alert backdrop dismiss
TypeScript
12 votes291 views1 answer
How check is file exist linux
TypeScript
0 vote279 views1 answer
Let variable name : any = () => { return new typescript fie}
TypeScript
2 votes283 views2 answers
Material form
TypeScript
0 vote277 views1 answer
How to permit only a few values in dbms
TypeScript
0 vote280 views1 answer
Laravel middleware for apis
TypeScript
1 vote308 views1 answer
Import exec ts
TypeScript
1 vote313 views1 answer
How to edit unity scripts in sublime text
TypeScript