/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 vote124 views1 answer
Serenity-is change button text
TypeScript
0 vote131 views2 answers
How to teleport a sprite to a new room in game maker studio 2
TypeScript
1 vote128 views1 answer
Why does the Circum-Pacific belt of earthquakes coincide with the Pacific ring of fire
TypeScript
0 vote147 views1 answer
Query the NAME field for all American cities in the CITY table with populations larger than 120000. The CountryCode for America is USA.
TypeScript
0 vote131 views1 answer
Create array of structs cpp
TypeScript
18 votes120 views3 answers
Enum to number typescript
TypeScript
0 vote120 views1 answer
Why touchable opacity to take width of its child
TypeScript
-1 vote138 views1 answer
Typescript enum value to enum
TypeScript
1 vote133 views2 answers
Angular module build
TypeScript
3 votes124 views2 answers
Sort array by date typescript
TypeScript