/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

5 votes316 views1 answer
Sqlite3.ProgrammingError: SQLite objects created in a thread can only be used in that same thread
TypeScript
2 votes316 views10 answers
Javascript
TypeScript
1 vote325 views2 answers
Ts-node command compile typescript
TypeScript
8 votes295 views3 answers
Angular window scroll to top not working
TypeScript
1 vote263 views4 answers
List all motherboard ports command line
TypeScript
0 vote359 views1 answer
Links a otros components angular
TypeScript
0 vote306 views1 answer
Q5: Identify the five major components of a communications system.
TypeScript
0 vote403 views1 answer
The events calendar update the word event
TypeScript
0 vote319 views1 answer
Window ethereum types
TypeScript
3 votes321 views2 answers
Foreach on dictionary in typescript
TypeScript