/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

26 votes265 views3 answers
How to install typescript in windows 10
TypeScript
0 vote286 views1 answer
Delete attachments in nodejs
TypeScript
0 vote270 views1 answer
Common child hackerrank solution
TypeScript
0 vote307 views1 answer
Error Extracting tar content of undefined failed, the file appears to be corrupt: "EBUSY: resource busy or locked,
TypeScript
0 vote302 views1 answer
OSError: [E941] Can't find model 'en'. It looks like you're trying to load a model from a shortcut, which is deprecated as of spaCy v3.0. To load the model, use its full name instead:
TypeScript
0 vote283 views1 answer
How to combine pdf documents C#
TypeScript
39 votes334 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
0 vote290 views1 answer
Mat-autocomplete options dropdown does not stick when scrolling
TypeScript
1 vote273 views4 answers
Ok
TypeScript
1 vote253 views1 answer
Typescript while
TypeScript