A. If you are moving something like a staging/test site to a new site and want to bring everything over intact , the Store Locator Plus author strongly recommends looking into the WordPress backup tool Vault Press, or better , Jet Pack. One of the features included , besides real-time incremental backups of your site with restore points, is the ability to restore the site to an alternate site.
Tables and Category Data System
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.