/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

-2 votes335 views1 answer
Typescript mocha Cannot use import statement outside a module
TypeScript
22 votes359 views4 answers
Cmd listening ports
TypeScript
0 vote314 views1 answer
Change event doesn't work on dynamically generated elements .
TypeScript
2 votes295 views1 answer
Media breakpoints bootstrap 4
TypeScript
0 vote325 views2 answers
Testing Objects for Properties
TypeScript
0 vote304 views1 answer
Keyboard shortcuts to delete whole word using backspace
TypeScript
0 vote333 views1 answer
Can't bind to 'ngbCollapse' since it isn't a known property of 'div'
TypeScript
1 vote315 views1 answer
Error: ./src/main.ts Module build failed (from ./node_modules/@ngtools/webpack/src/ivy/index.js): TypeError: Cannot read property 'createUniqueName' of undefined
TypeScript
1 vote329 views1 answer
Angular innerhtml style not working
TypeScript
2 votes318 views2 answers
Date format in typescript
TypeScript