Skip to content
  • SLP
  • Fully Managed
  • WordPress Plugin
  • 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
    • Helpful Hints
    • What To Buy
  • Troubleshooting
Search box

Tag: id

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. The Legacy add-on , Tagalong used this system.  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 (Tagalong) 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 (Tagalong) Category “A” it may be assigned ID #19.

In order to “just move tagalong 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 Tagalong 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 / maintaining a (Tagalong) 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.

Table of Contents

Popular Tags

add-ons 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 Maps map software map tools MySLP near me power Premier results results layout search search layout shortcode shortcodes store locator Store Locator Plus Store Pages tagalong taxonomy troubleshooting user experience User Interface versions WPSLP

Recent Updates

  • Load Locations from WordPress Locator to MYSLP® December 7, 2018
  • Google Server (Browser) Key for WPSLP November 27, 2018
  • Map Controls November 1, 2018
  • undefined property: stdclass::$plugin October 5, 2018
  • CSV Import Duplicates Handling September 10, 2018

Index

  • .mo
  • .po
  • [slp_directory]
  • [slp_location]
  • [slp_map]
  • [slp_option]
  • [slp_pages]
  • [slp_results]
  • [slp_search]
  • [slplus]
  • [storepage]
  • 18n
  • account
  • activate
  • add-on shortcodes
  • add-ons
  • add-tel-to-phone
  • adding categories to locations
  • adding locations
  • address map
  • address matching
  • address-placeholder
  • 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
  • base plugin
  • 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 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
  • customization
  • data
  • data field names
  • data fields
  • debug.log
  • debugging
  • default label
  • deleting locations
  • design
  • dial link
  • directories
  • directory
  • directory builder
  • disable initial directory
  • disabled
  • discreet
  • discrete
  • discrete search
  • distance
  • distance-unit
  • documentation
  • domain
  • domains
  • downgrade
  • download
  • dropdown
  • dropdown_with_label
  • dropdown-style
  • duplicates
  • dynamic pricing
  • 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
  • faq
  • featured locations
  • featured results
  • features
  • fields
  • filter
  • filtering locations
  • filters
  • find button
  • first entry
  • force-load-javascript
  • format
  • forum
  • functionality
  • gallery
  • general settings
  • generate embed
  • generate embed code
  • geocode errors
  • geocoding
  • geolocation
  • gettext
  • Getting Started
  • 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
  • helpful hints
  • hide map
  • 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-hours
  • label-image
  • label-phone
  • label-website
  • labels
  • landing_page
  • landing_page attribute
  • language files
  • language switching
  • languages
  • large exports
  • large imports
  • layout
  • legacy
  • legend
  • license
  • LInks
  • list mode
  • load locations
  • loading indicator
  • loading-indicator-color
  • 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
  • loco translate
  • manage locations
  • Managing Locations
  • map
  • 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-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
  • multilingual
  • multiple languages
  • multiple maps
  • MySLP
  • MySLP 17.8
  • name
  • near me
  • no map
  • no results found
  • no-autozoom
  • no-homeicon-at-start
  • nonces
  • only with
  • only_with_category
  • options
  • 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
  • PATCH
  • PayPal
  • pegman
  • permissions
  • phone link
  • phone-extension-delimiter
  • php
  • php version
  • php-max-execution-time
  • plug-in
  • plugin
  • plugin directory
  • plugin environment
  • plugin style
  • polyglot
  • polyglots
  • POST
  • post code
  • power
  • Power Add On
  • Power Level
  • Premier
  • private
  • pro pack
  • process limits
  • Products
  • Professional
  • propack
  • purchases
  • PUT
  • QA
  • query google limits
  • radii
  • radii options
  • radius
  • radius behavior
  • ranked locations
  • ranking
  • Read More
  • recovery
  • region
  • remote file
  • remove-credits
  • reports
  • REST
  • REST API
  • 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 Pages
  • server
  • service levels
  • sets of locations
  • settings
  • shared host
  • shortcode
  • shortcodes
  • show locations at startup
  • show-cats-on-search
  • show-icon-array
  • 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
  • slugs
  • snazzy-maps
  • span
  • Squarespace
  • 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
  • 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
  • themes
  • toolbar
  • top results
  • top searches
  • transfer site
  • translate WP
  • translation
  • troubleshooting
  • turn off slp map
  • UI
  • unsubscribe
  • updates
  • upgrade
  • upgrades
  • upload file
  • URL Controls
  • url import
  • url-allow-address
  • url-control-description
  • use-nonces
  • use-pages
  • use-sensor
  • user experience
  • User Experience/Map
  • User Inteface
  • User Interface
  • utf-8
  • UX
  • Version 3
  • versions
  • view
  • what to buy
  • white screen
  • widgets
  • WooCommerce
  • WordPress
  • wp cron
  • WPML
  • WPSLP
  • zipcode
  • zoom
  • zoom-level
  • zoom-tweak
Go to the top
Proudly powered by WordPress | Theme: Fortune by Themes Harbor.