/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 vote116 views1 answer
Type 'MutableRefObject<undefined>' is not assignable to type 'RefObject<HTMLInputElement>'. Types of property 'current' are incompatible. Type 'undefined' is not assignable to type 'HTMLInputElement | null'. TS2322
TypeScript
-1 vote122 views3 answers
Connect redis typescript usage
TypeScript
1 vote95 views1 answer
If env variable exists bash
TypeScript
0 vote94 views1 answer
Date get date dots
TypeScript
0 vote106 views1 answer
Running same tests against different browsers
TypeScript
0 vote113 views1 answer
Check if a user already exists firebase realtime database react native
TypeScript
0 vote169 views1 answer
Typescript get class properties
TypeScript
0 vote313 views1 answer
Cacerts default password
TypeScript
1 vote108 views1 answer
How to use variables with if statements python
TypeScript
3 votes97 views1 answer
Typescript req.query.query
TypeScript