/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 vote331 views5 answers
Rosa
TypeScript
6 votes391 views2 answers
Github:Module was compiled with an incompatible version of Kotlin. The binary version of its metadata is 1.5.1, expected version is 1.1.15 in android
TypeScript
2 votes330 views1 answer
Create model class angular
TypeScript
0 vote320 views2 answers
Convert java to typescript
TypeScript
2 votes353 views1 answer
Type casting in typescript
TypeScript
13 votes366 views5 answers
Useref react typescript
TypeScript
1 vote347 views1 answer
Header imitate python
TypeScript
0 vote347 views1 answer
Ratio of subplots matplotlib
TypeScript
1 vote341 views1 answer
Dev/storage/logs" and its not buildable: Permission denied
TypeScript
6 votes312 views3 answers
Mongodb count based on array of ids
TypeScript