Build Term Relationship after wp_insert_term

Working on a project with migrating some data to a WordPress database I got my long and precise script up and running, but the data wasn’t visible in the taxonomy list view in the admin – only the parent term there, few pages of data calculated (pagination on), but no data other than the parent.

Luckily I found a cache wiping solution by Matt Thiessen (major props to the guy) who replied that a DB cache wipe could help by deleting the children option for the taxonomy in the DB, in a similar way (snippet from the link):


wp_insert_term( $new_name, $my_taxonomy, array( ‘parent’=> (int)$new__term_id ) );
delete_option($my_taxonomy.”_children”); // clear the cache

Later this week I’ll post a snippet for switching to another WordPress database in the middle of a plugin. There are some solutions online, but they don’t seem to work in some cases, for example if you have different database table prefixes or so.

Mario Peshev

About Mario Peshev

Technical value creation advisor to PE-backed and mid-market companies. Founder of DevriX and Growth Shuttle, 40+ acquisitions as an operator, author of MBA Disrupted.