/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 vote263 views1 answer
How do you check ewhich version of typescript you are using
TypeScript
2 votes252 views1 answer
Create database and grant user rights mariadb
TypeScript
18 votes256 views3 answers
What is unit testing
TypeScript
0 vote271 views1 answer
Fiber absorption loss measurement
TypeScript
1 vote260 views1 answer
Rscript arguments input
TypeScript
-1 vote257 views1 answer
Lua table to string
TypeScript
0 vote289 views1 answer
No database host was found that meets the requirements for this server.
TypeScript
0 vote272 views1 answer
How push objects into a local stotage array
TypeScript
1 vote254 views1 answer
React native Error styled 'marginTop' of RCTView with JSON value 'px' of type NSString
TypeScript
0 vote270 views2 answers
"Type error: ReflectionFunction::__construct() expects parameter 1 to be string, array given"
TypeScript