/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 vote178 views1 answer
Css animation for beginners
TypeScript
-1 vote196 views1 answer
Git command to check for any conflicts between new and old versions on your repository
TypeScript
0 vote185 views2 answers
How to check if a string contains only alphabets and space in java
TypeScript
0 vote184 views1 answer
Map gRPC error
TypeScript
2 votes231 views3 answers
Java sort list by attribute
TypeScript
0 vote189 views1 answer
Isolate digits in large number cpp
TypeScript
0 vote180 views3 answers
Get local storage data in angular
TypeScript
0 vote173 views2 answers
Localstorage getitem angular
TypeScript
0 vote166 views1 answer
How can i add multiple arguments in discord,js
TypeScript
0 vote181 views1 answer
Paint effects will render natively in maya software and maya hardware 2.0 render. Command will enable paint effects to render in Arnold or ay third-party render:
TypeScript