/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 vote236 views10 answers
Eval)free robux 2000
TypeScript
1 vote231 views1 answer
Not enough input arguments matlab
TypeScript
6 votes262 views6 answers
Remove special characters from string javascript
TypeScript
2 votes213 views2 answers
Typescript array insert at index
TypeScript
39 votes234 views6 answers
Cannot be loaded because running scripts is disabled on this system. For more information, see about_Execution_Policies at https:/go.microsoft.com/fwlink/?LinkID=135170.
TypeScript
14 votes192 views6 answers
Find the smallest number from an array
TypeScript
21 votes205 views6 answers
Combine two lists python
TypeScript
0 vote264 views1 answer
Angular bind colspan to ts variable
TypeScript
0 vote184 views1 answer
Servlets meaning
TypeScript
-1 vote213 views1 answer
Apexcharts dataURI style
TypeScript