/TypeScript/Woocommerce bulk product delete

Woocommerce bulk product delete

DELETE relations.*, taxes.*, terms.*
FROM wp_term_relationships AS relations
INNER JOIN wp_term_taxonomy AS taxes
ON relations.term_taxonomy_id=taxes.term_taxonomy_id
INNER JOIN wp_terms AS terms
ON taxes.term_id=terms.term_id
WHERE object_id IN (SELECT ID FROM wp_posts WHERE post_type='product');
  
DELETE FROM wp_postmeta WHERE post_id IN (SELECT ID FROM wp_posts WHERE post_type = 'product');
DELETE FROM wp_posts WHERE post_type = 'product';

Source: wpfluent.com

Woocommerce bulk product delete

DELETE relations.*, taxes.*, terms.*
FROM wp_term_relationships AS relations
INNER JOIN wp_term_taxonomy AS taxes
ON relations.term_taxonomy_id=taxes.term_taxonomy_id
INNER JOIN wp_terms AS terms
ON taxes.term_id=terms.term_id
WHERE object_id IN (SELECT ID FROM wp_posts WHERE post_type='product');

DELETE FROM wp_postmeta WHERE post_id IN (SELECT ID FROM wp_posts WHERE post_type = 'product');
DELETE FROM wp_posts WHERE post_type = 'product';

Source: siegercreations.com

Similar codes

0 vote140 views1 answer
Dart check if variable is list
TypeScript
0 vote141 views3 answers
__REDUX_DEVTOOLS_EXTENSION_COMPOSE__
TypeScript
10 votes138 views2 answers
How to use variable as object key in typescript
TypeScript
0 vote149 views1 answer
Convert f#
TypeScript
0 vote713 views1 answer
The benefits of deploying a network using a WLC
TypeScript
2 votes137 views2 answers
Remove all the elements from a numpy array python
TypeScript
0 vote146 views1 answer
Benefits of waxing body hair
TypeScript
2 votes107 views2 answers
Python iterate object
TypeScript
1 vote89 views1 answer
<edit-config> changes in this plugin conflicts with <edit-config> changes in config.xml. Conflicts must be resolved before plugin can be added.
TypeScript
5 votes105 views1 answer
Python tkinter remove widget
TypeScript