/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 vote149 views2 answers
Dart clone list
TypeScript
0 vote200 views2 answers
Paths typescript
TypeScript
1 vote133 views1 answer
How to add elements to Jlist
TypeScript
0 vote143 views1 answer
Disable button typescript
TypeScript
1 vote148 views4 answers
Ok
TypeScript
0 vote135 views1 answer
Alternative for .include in typescript
TypeScript
1 vote135 views1 answer
Angular host binding class on input
TypeScript
1 vote133 views1 answer
Ionic modal controller pass parameter
TypeScript
0 vote138 views1 answer
Do feral cats have rabies?
TypeScript
0 vote160 views1 answer
Stackoverflow ngbdate angular
TypeScript