/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 vote317 views1 answer
Nextjs global prisma
TypeScript
0 vote285 views1 answer
Dots are displaying only when trying to fetch records html template
TypeScript
0 vote294 views1 answer
React hooks typescript function return and receive
TypeScript
45 votes377 views5 answers
Cra typescript
TypeScript
0 vote275 views1 answer
Check if an element exists laravel
TypeScript
76 votes563 views6 answers
Running scripts is disabled on this system
TypeScript
1 vote337 views1 answer
Woocommerce sql query pulls products from category
TypeScript
1 vote296 views1 answer
Angular reload component on route param change
TypeScript
0 vote267 views1 answer
E typescript
TypeScript
0 vote341 views1 answer
How to return a new string with its first and last characters swapped
TypeScript