/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 vote260 views1 answer
Angular tokenize
TypeScript
-1 vote222 views2 answers
What are the components of the environment? Explain it along with the examples class 6
TypeScript
0 vote252 views1 answer
Delete attachments in nodejs
TypeScript
0 vote175 views1 answer
Terrform variable list type
TypeScript
0 vote206 views1 answer
TypeError: key must be an instance of a class implements jwt.AbstractJWKBase
TypeScript
1 vote226 views2 answers
Hosts path
TypeScript
1 vote179 views1 answer
Sonar properties exclude rule
TypeScript
0 vote191 views1 answer
Get url params in typescript
TypeScript
1 vote202 views1 answer
Get function return type typescript
TypeScript
0 vote258 views1 answer
Failed to find '~@nativescript/theme/css/core.css'
TypeScript