/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 vote123 views5 answers
AddObjects giving a fatal error when pushing data to algolia
TypeScript
2 votes151 views1 answer
Rror: failed to init transaction (unable to lock database) error: could not lock database: File exists if you're sure a package manager is not already running, you can remove /var/lib/pacman/db.lck
TypeScript
0 vote90 views1 answer
How to show component in another component angular
TypeScript
7 votes126 views2 answers
Conditional style angular
TypeScript
0 vote125 views1 answer
Nodejs to send authentication bearer token cowin
TypeScript
13 votes123 views6 answers
React native typescript
TypeScript
-1 vote127 views2 answers
Function that redirects to another page react
TypeScript
2 votes137 views2 answers
Typescript datetimte
TypeScript
0 vote137 views1 answer
Three requirements for laser action
TypeScript
14 votes127 views4 answers
Matplotlib subplots size
TypeScript