/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 vote175 views1 answer
Ubuntu display stdouts of processn
TypeScript
2 votes163 views1 answer
Type casting in typescript
TypeScript
0 vote182 views1 answer
Publication only contains dependencies and/or constraints without a version. You need to add minimal version information, publish resolved versions
TypeScript
0 vote167 views1 answer
View and navigate your assignments (teacher) code for asp.net
TypeScript
0 vote158 views1 answer
How to round float to 2 decimal places
TypeScript
-1 vote175 views1 answer
Drupal
TypeScript
1 vote177 views1 answer
React make multiple fetch requests one after another
TypeScript
0 vote183 views1 answer
Theattachedfile“stdData.csv”containsdifferentmeasurementsfromfour sensors. Themeasurementsaretakenmanytimesfordifferenttests
TypeScript
0 vote296 views1 answer
How to send attachments to api
TypeScript
0 vote289 views1 answer
Gettime is not a function typescript
TypeScript