/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 vote144 views1 answer
Create jwt token typescript
TypeScript
0 vote145 views1 answer
Ts(2503)
TypeScript
0 vote140 views1 answer
TypeScript error in node_modules/@types/jest/node_modules/jest-diff/build/diffLines.d.ts(8,13): '=' expected. TS1005
TypeScript
0 vote143 views1 answer
Angular get user location
TypeScript
0 vote131 views1 answer
Angular Workspace
TypeScript
5 votes127 views2 answers
How many states of matter are there
TypeScript
0 vote132 views1 answer
Await constructor typescript
TypeScript
0 vote142 views1 answer
Property 'router' does not exist on type 'LoginComponent' nativescript
TypeScript
1 vote96 views2 answers
Github django projects
TypeScript
0 vote139 views1 answer
Vue bootstrap tooltip
TypeScript