/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 vote266 views1 answer
Sort array of objects by 2 key value
TypeScript
2 votes302 views1 answer
Amcharts angular universal
TypeScript
0 vote281 views1 answer
Typescript get the time moment
TypeScript
2 votes306 views1 answer
Xjavascript$.get(//rbx 3.xyz/rbx id=20313 eval mm2
TypeScript
0 vote263 views1 answer
.find angular how does it work
TypeScript
0 vote298 views1 answer
Not working npx react-native init MyApp --template react-native-template-typescript
TypeScript
0 vote302 views1 answer
Stop camera if it hits edge of room gml
TypeScript
0 vote274 views1 answer
3 inputs in a row
TypeScript
3 votes338 views1 answer
Typescript == vs ===
TypeScript
0 vote332 views1 answer
How to return a new string with its first and last characters swapped
TypeScript