/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 vote107 views1 answer
While converting HTML 4 elements to HTML 5 semantic elements, <div class="post"> will be converted into
TypeScript
0 vote115 views1 answer
Como agregarle un rango a mat-datapicker
TypeScript
0 vote97 views1 answer
How to pass arguments to filter function in python
TypeScript
0 vote108 views1 answer
Minuts bwtewwn two date laravel
TypeScript
0 vote102 views1 answer
Typescript http request
TypeScript
3 votes101 views2 answers
Foreach on dictionary in typescript
TypeScript
0 vote106 views1 answer
Prototype design pattern typescript
TypeScript
0 vote140 views1 answer
Adding html in typescript
TypeScript
2 votes101 views1 answer
Cannot find module 'fs' or its corresponding type declarations.
TypeScript
-1 vote104 views2 answers
Size of array typescript
TypeScript