Tag: metadata

Table

There are components of the Power Add-on that use the built-in WordPress category system involving several tables.   When moving sites over or combining sites, whether it be from a staging site, or  an older site  to a live site , getting the data in wp_slp_tagalong to match up with a pre-existing site that has pre-existing category data (taxonomies) will be a chore.

For example,

Under a Current site , there may have been an assigned Category “A” ID # 3 at the time the category was created in the taxonomy table but  Live may already be using that ID, therefore when you create a  Category “A” it may be assigned ID #19.

In order to “just move tagalong /categories over” you would need to edit every entry in the “wp_slp_tagalong” table and change ID # 3 to ID #19. To do so, you need to first let WordPress create all of the categories (you could do this with a category-only import) second look up all the ID numbers of the assigned categories, third edit the wp_slp_tagalong exported data from Current to change all of the ID numbers from the “old” WordPress site to be the ID# assigned on the “new (Live)” WordPress site. If you only have 2 or 3 categories it may not be a chore but it can get out-of-hand very quickly. If you make any editing mistakes you will have various issues.

WordPress table descriptions can be found under the WordPress Codex page Database Descriptions

The two tables that would be employed by WordPress when creating or maintaining a category:

wp_terms = the category information itself

wp_term_taxonomy = the metadata that tells WordPress about different category groupings, in other words “this category is for posts”, “this category is for Store Locator Plus locations”, “this category is for videos”, etc. You will not need to export/import this but you WILL need to know what the old (Current) system assigned as the SLP Locations taxonomy ID and what it is on the new WP system. When you export wp_terms from the old system you will need to edit that export and change the taxonomy ID from what it was on Current to what it is on Live.