/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

1 vote215 views1 answer
How to remove list dots in li bootstrap
TypeScript
0 vote204 views1 answer
If word contains space detects using jquery
TypeScript
2 votes224 views1 answer
Python remove folder recursively
TypeScript
0 vote211 views1 answer
Upload file requests python
TypeScript
-1 vote206 views1 answer
Two lists into one list of tules
TypeScript
0 vote209 views1 answer
Call appply bind
TypeScript
1 vote203 views1 answer
Adonis identify method
TypeScript
0 vote210 views1 answer
Coldfusion check if key exists and not empty
TypeScript
0 vote214 views1 answer
How to add array of objects in swagger 2.0
TypeScript
0 vote198 views1 answer
Import openzeppelin contracts in remix
TypeScript