/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 vote137 views1 answer
'`pydot` failed to call GraphViz.' OSError: `pydot` failed to call GraphViz.Please install GraphViz (https://www.graphviz.org/) and ensure that its executables are in the $PATH.
TypeScript
0 vote109 views1 answer
How to check if an element starts with class in jquery
TypeScript
1 vote104 views1 answer
Ng-select disabled
TypeScript
0 vote105 views1 answer
How to delete a struct in a arra of strcts c
TypeScript
0 vote140 views1 answer
Online doctor appointments in pakistan
TypeScript
1 vote107 views1 answer
Cannot read property 'slideTo' of undefined TypeError: Cannot read property 'slideTo' of undefined
TypeScript
3 votes114 views1 answer
Typescript array string to array literal
TypeScript
0 vote117 views3 answers
How to print brackets characters in c#
TypeScript
0 vote117 views1 answer
Computed vue typescript
TypeScript
1 vote94 views1 answer
Dispatcher servlet as its web application context
TypeScript