/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 vote325 views1 answer
Create react app with typescript declare types for libraries in npm
TypeScript
0 vote322 views1 answer
String of bits to integer java
TypeScript
2 votes311 views1 answer
What are benefits of zip files
TypeScript
0 vote306 views1 answer
Google places auto-complete
TypeScript
1 vote312 views1 answer
Use map with filter in react components from arrays of data
TypeScript
2 votes301 views1 answer
Media breakpoints bootstrap 4
TypeScript
0 vote334 views1 answer
Swift charts highlight color
TypeScript
0 vote301 views1 answer
Mat card api
TypeScript
0 vote348 views1 answer
Highlight styled components on vscode
TypeScript
0 vote321 views2 answers
Isnull or empty typescript
TypeScript