/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 vote146 views1 answer
TypeScript error in node_modules/@types/jest/node_modules/jest-diff/build/diffLines.d.ts(8,13): '=' expected. TS1005
TypeScript
0 vote147 views1 answer
Different types of errors in numerical methods
TypeScript
1 vote148 views1 answer
See sheets of excel file python
TypeScript
1 vote143 views1 answer
Ion select active by button
TypeScript
0 vote186 views1 answer
Curl -s "http://google.com?[1-1000]"
TypeScript
0 vote154 views1 answer
Prolog check if element in different lists are same
TypeScript
0 vote144 views1 answer
Set environment variable typescript
TypeScript
-80 votes141 views10 answers
Code
TypeScript
0 vote139 views1 answer
Check if email exists firebase
TypeScript
9 votes151 views4 answers
Combine list of lists python
TypeScript