/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 vote329 views1 answer
Number_format() expects parameter 1 to be float, string given
TypeScript
1 vote305 views1 answer
Angular host binding class on input
TypeScript
0 vote347 views1 answer
Highcharts print
TypeScript
5 votes315 views1 answer
Git remove commits from branch after push
TypeScript
0 vote304 views1 answer
React Draft Wysiwyg typescript
TypeScript
15 votes363 views2 answers
How to check if var exists python
TypeScript
16 votes340 views4 answers
Npx create-next-app typescript
TypeScript
0 vote303 views1 answer
Checked a element is focused with its key pressed
TypeScript
0 vote314 views1 answer
Centos remote desktop clients vs remote management for linux
TypeScript
0 vote307 views1 answer
React-scripts start error
TypeScript