/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

9 votes191 views2 answers
Array contains typescript
TypeScript
0 vote229 views1 answer
Increment elements in array typescript
TypeScript
0 vote183 views1 answer
What do you need local sccripts for
TypeScript
5 votes194 views3 answers
Add space between subplots matplotlib
TypeScript
2 votes194 views1 answer
Types date typescript
TypeScript
0 vote177 views1 answer
Typescript array to string
TypeScript
1 vote198 views1 answer
Luxon react ts install
TypeScript
0 vote186 views1 answer
Error TS2564: Property
TypeScript
29 votes208 views6 answers
Bootstrap angular
TypeScript
0 vote231 views1 answer
Angular build router-outlet not working
TypeScript