Skip to content
  • MySLP
    • Dashboard Login
  • WordPress Plugin
    • Store Login
  • Documentation
  • Demo
  • News

Store Locator Plus® Documentation

Store Locator Plus® Documentation

  • By Product…
    • Base Plugin / Advanced
    • Power
    • Experience / Professional
    • Premier / Enterprise
    • MySLP Specific
    • WPSLP Specific
  • FAQ
    • What To Buy
  • Troubleshooting

Tag: metadata

10NovNovember 10, 2016

Tables and Category Data System

Posted by cici in Our Add Ons, Power / Power

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.

Sign Up For Store Locator Plus®

Table of Contents

Popular Tags

address map appearance categories css csv import embed google map Enterprise Experience experience add-on faq geocoding Google Maps google maps multiple destinations google maps multiple stops import javascript location map locator software map map customizer map generator map markers Maps map software map tools MySLP near me Pages power Premier results results layout search search layout shortcode shortcodes store locator Store Pages tagalong taxonomy troubleshooting user experience User Interface versions WordPress

Recent Updates

  • Results Panel Settings October 15, 2021
  • Upgrading Store Locator Plus August 1, 2021
  • Where to find the Store Locator Plus for WordPress versions and updates June 10, 2021
  • Most Common “What Should I Buy” Questions May 21, 2021
  • Categorical Location Markers September 15, 2020

Index

  • [slp_directory]
  • [slp_location]
  • [slp_map]
  • [slp_option]
  • [slp_pages]
  • [slp_results]
  • [slp_search]
  • [slplus]
  • [storepage]
  • 18n
  • above_and beyond style
  • account
  • activate
  • add-on shortcodes
  • add-ons
  • add-tel-to-phone
  • adding categories to locations
  • adding locations
  • address map
  • address matching
  • address-placeholder
  • admin
  • admin ui
  • aerial view
  • Ajax
  • allow address in url
  • allow-limit-in-url
  • allow-location-in-url
  • allow-tag-in-url
  • API Key
  • ApiNotActivatedMapError
  • appearance
  • append
  • append-to-search
  • attributes
  • autocomplete
  • back-up tools
  • backup
  • basic reporting
  • blank marker
  • block-ip-limit
  • block-ip-period
  • block-ip-release-after
  • Bootstrap
  • boundaries
  • boundaries-influence-type
  • brands
  • browser
  • bubble layout
  • bubble-footnote
  • bulk actions
  • bulk import
  • Buy Button
  • Buy Here For WooCommerce
  • buyers guide
  • by attribute
  • categories
  • categorization
  • category inport
  • category manager
  • category markers
  • category selector
  • center-map-at
  • changelog
  • checkboxes
  • cities
  • city search
  • city selector
  • cluster
  • cluster-gridsize
  • cluster-minimum
  • clusters-enabled
  • combined markers
  • configuration requirements
  • contact
  • contact extender
  • contact fields
  • copying to a new site
  • countries
  • country
  • country search
  • country selector
  • creating a page
  • credit cards
  • cron
  • css
  • csv
  • csv example
  • csv file format
  • CSV files
  • csv import
  • curly quotes
  • custom css
  • custom style
  • customization
  • data
  • data field names
  • data fields
  • debug.log
  • debugging
  • default label
  • default-country
  • deleting locations
  • Deploy
  • design
  • dial link
  • directories
  • directory
  • directory builder
  • disable initial directory
  • disabled
  • discreet
  • discrete
  • discrete search
  • distance
  • distance-unit
  • do not show results until search
  • documentation
  • domain
  • domains
  • downgrade
  • download
  • dropdown
  • dropdown_with_label
  • dropdown-style
  • duplicates
  • dynamic pricing
  • edit map marker
  • editing locations
  • editing style
  • embed google map
  • enable pages
  • enable-wp-debug
  • enhanced map
  • enhanced results
  • enhanced search
  • Enterprise
  • errors
  • EULA
  • examples
  • Experience
  • experience add-on
  • experience tab
  • export
  • extended
  • extended data
  • fallback
  • faq
  • featured locations
  • featured results
  • features
  • fields
  • filter
  • filtering locations
  • filters
  • find button
  • first entry
  • force-load-javascript
  • format
  • formatting
  • forum
  • functionality
  • gallery
  • general settings
  • generate embed
  • generate embed code
  • geocode errors
  • geocoding
  • geolocation
  • Getting Started
  • git
  • global positioning
  • google API
  • Google API Key
  • Google Browser Key
  • Google Maps
  • Google Maps API Error
  • Google Maps API Key
  • google maps multiple destinations
  • google maps multiple stops
  • google-geocode-key
  • google-map-style
  • google-server-key
  • GPS
  • graphics
  • gray map. search
  • guess
  • headers
  • height
  • helpful hints
  • hide map
  • hide-bubble
  • hide-empty
  • hide-search-form
  • hiding location
  • hierarchy
  • highlighting
  • home marker
  • how search works
  • How To
  • href#
  • html
  • http
  • https
  • hybrid view
  • i18n
  • icon array
  • iconarray
  • icons
  • id
  • identifier
  • image until search
  • immediately-show-locations
  • import
  • influence
  • info bubbles
  • info menu
  • initial distance
  • initial-radius
  • initial-results-returned
  • install
  • instructions
  • internationalization
  • ip address
  • ip-whitelist
  • javascript
  • jetPack
  • jquery
  • json
  • kilometers
  • l10n
  • label radius
  • label search
  • label-category
  • label-email
  • label-fax
  • label-for-find-button
  • label-hours
  • label-image
  • label-phone
  • label-website
  • labels
  • landing_page
  • landing_page attribute
  • languages
  • large exports
  • large imports
  • layout
  • legacy
  • legend
  • license
  • LInks
  • list mode
  • load locations
  • loading indicator
  • loading-indicator-color
  • loading-indicator-location
  • loading-indicator-search
  • localization
  • location import
  • location list
  • location management
  • location map
  • Location Passing
  • location sensor
  • location service
  • location software
  • Locations
  • locations list
  • locations mapping
  • locations panel
  • locator layout
  • locator software
  • locator style
  • Make SLP Core
  • manage locations
  • Managing Locations
  • map
  • map broken
  • map bubble
  • map customizer
  • map display
  • map features
  • map generator
  • map info bubble
  • Map Interaction
  • map layout
  • map marker
  • map markers
  • map settings
  • map software
  • map style
  • map tools
  • map type
  • map_marker_tooltip
  • map-center
  • map-center-lat
  • map-center-lng
  • map-controls-subheader
  • map-end-icon
  • map-height
  • map-height-units
  • map-home-icon
  • map-initial-display
  • map-marker-tooltip
  • map-option-fullscreenControl
  • map-option-hide-streetview
  • map-option-zoomControl
  • map-options-clickableIcons
  • map-options-mapTypeControl
  • map-options-scaleControl
  • maplayout
  • Maps
  • markers
  • max-results-returned
  • memory limits
  • menu
  • message-no-results
  • metadata
  • migration
  • miles
  • mobile
  • mobile apps
  • more locations
  • multi site
  • multiple maps
  • MySLP
  • MySLP 17.8
  • name
  • near me
  • no display
  • no map
  • no results found
  • no-autozoom
  • no-homeicon-at-start
  • nonces
  • only with
  • only_with_category
  • order by
  • order by name
  • order results
  • OS
  • Page Layout
  • page scraping
  • Pages
  • pages_directory_entry_css_class
  • pages_directory_wrapper_css_class
  • pages-directory-entry-css-class
  • pages-directory-wrapper-css-class
  • pagination
  • pagination-enabled
  • paid support
  • parent-child
  • PayPal
  • pegman
  • permissions
  • phone link
  • phone-extension-delimiter
  • php
  • php version
  • php-max-execution-time
  • phpStorm
  • plug-in
  • plug-in styles
  • plugin
  • plugin directory
  • plugin environment
  • plugin style
  • polyglot
  • post code
  • power
  • Power Add On
  • Power Level
  • Premier
  • premium-subscription-id
  • premium-user-id
  • private
  • pro pack
  • process limits
  • Products
  • Professional
  • propack
  • purchases
  • QA
  • query google limits
  • radii
  • radii options
  • radius
  • radius behavior
  • ranked locations
  • ranking
  • Read More
  • recovery
  • region
  • remote file
  • remote file retrieval
  • remove-credits
  • reports
  • restore
  • results
  • results interaction
  • results layout
  • results limit
  • results panel
  • results settings
  • results-click-animate-marker
  • results-click-label-marker
  • results-click-map-movement
  • results-click-marker-icon
  • results-click-marker-icon-behavior
  • results-header
  • results-no-wrapper
  • road map
  • SaaS
  • schedule_for_initial_distance
  • scheduled tasks
  • search
  • search attributes
  • search box
  • search broken
  • search error
  • search form
  • search labels
  • search layout
  • search results
  • search_form_style
  • search-box-subtitle
  • search-on-map-move
  • searchlayout
  • secure site
  • security
  • selector
  • sensor
  • SEO
  • SEO page template
  • SEO Pages
  • server
  • service levels
  • sets of locations
  • settings
  • shared host
  • shortcode
  • shortcodes
  • show locations at startup
  • show-cats-on-search
  • show-icon-array
  • show-legend-text
  • show-option-all
  • simple stuff
  • skip geocoding
  • skip goecoding
  • sl_id
  • SLP
  • SLP 4.7.10
  • SLP field name
  • slp_search_element
  • slp_searchelement
  • slp-power[csv_duplicates_handling]
  • SLPLUS Shortcode
  • SLPSaaS
  • slugs
  • snazzy-maps
  • span
  • Squarespace
  • staging
  • starting-image
  • startup
  • state search
  • state selector
  • states
  • store
  • store locator
  • Store Locator Plus
  • store locator software
  • store manager
  • Store Pages
  • straight quotes
  • street view
  • structure
  • style
  • style attribute
  • styling
  • submit button
  • subscription
  • subscriptions
  • support
  • T_PAAMAYIM_NEKUDOTAYIM
  • tables
  • tabular data
  • tag
  • tagalong
  • tags
  • taxonomy
  • template
  • terrain map
  • territories
  • testing
  • text lists
  • text_if_blank
  • text_if_blank attribute
  • theme
  • themes
  • toolbar
  • top results
  • top searches
  • transfer site
  • translate WP
  • translation
  • troubleshooting
  • turn off slp map
  • twenty sixteeen
  • twentyfifteen
  • UI
  • unsubscribe
  • update
  • updates
  • upgrade
  • upgrades
  • upload file
  • URL Controls
  • url import
  • url-allow-address
  • url-control-description
  • use sensor
  • use-contact-fields
  • use-nonces
  • use-pages
  • use-territory-bounds
  • user experience
  • User Experience/Map
  • User Inteface
  • User Interface
  • utf-8
  • UX
  • versions
  • view
  • what to buy
  • white screen
  • widgets
  • Wix
  • WooCommerce
  • WordPress
  • wp cron
  • WPML
  • WPSLP
  • zip-selector
  • zipcode
  • zoom
  • zoom-level
  • zoom-tweak
Proudly powered by WordPress | Theme: Fortune by Themes Harbor.
 

Loading Comments...
 

You must be logged in to post a comment.