/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 vote212 views1 answer
Npm run scripts does not work
TypeScript
0 vote211 views1 answer
Get one property from list of objects linq
TypeScript
1 vote222 views1 answer
Ion-datetime open programmatically
TypeScript
0 vote239 views1 answer
Why table columns are messing in one another in angular
TypeScript
0 vote240 views1 answer
How to combine pdf documents C#
TypeScript
3 votes207 views1 answer
Typescript req.query.query
TypeScript
0 vote243 views1 answer
Not working npx react-native init MyApp --template react-native-template-typescript
TypeScript
0 vote215 views1 answer
Error TS2339: Property 'open' does not exist on type 'MatDialogModule'.
TypeScript
22 votes233 views4 answers
Cmd listening ports
TypeScript
0 vote247 views2 answers
Prestashop show all products in category
TypeScript