This comment has been minimized.
This comment has been minimized.
Nice one. Just had to adjust my table name from "wp_terms" to my database table name "wpdn_terms" and so forth. |
This comment has been minimized.
This comment has been minimized.
Seems to be it's not deleting products since they are stored in |
This comment has been minimized.
This comment has been minimized.
Hi, i have a woocommerce website, The code i did paste is this, as above only changed the db name: query("DELETE a,c FROM limiykm_wp1 AS a LEFT JOIN limiykm_wp1_taxonomy AS c ON a.term_id = c.term_id LEFT JOIN limiykm_wp1_relationships AS b ON b.term_taxonomy_id = c.term_taxonomy_id WHERE c.taxonomy = 'product_tag'"); $wpdb->query("DELETE a,c FROM limiykm_wp1 AS a LEFT JOIN limiykm_wp1_taxonomy AS c ON a.term_id = c.term_id LEFT JOIN limiykm_wp1_relationships AS b ON b.term_taxonomy_id = c.term_taxonomy_id WHERE c.taxonomy = 'product_cat'"); Please help, i am no programmer, just a regular user. |
This comment has been minimized.
This comment has been minimized.
Just an FYI there's a missing |
This comment has been minimized.
This comment has been minimized.
Thanks. Saved me some time looking up the structure! |
This comment has been minimized.
This comment has been minimized.
There are a couple of issues with this where it could be improved:
I have nonetheless found it useful on a 'dev' box, particularly when working with 'product import'. Thanks :) |
This comment has been minimized.
this is great! thanks!