To speed up imports you should NOT include columns that have no data.
For imports that did NOT start out as a CSV export from the SAME SITE you should NOT have an sl_id column.
For geocoding, assigning a latitude and longitude, to work during import you need to have at least one of the address fields in your file and preferably these main fields:
All field names can drop the leading “sl_” for readability. For example sl_address can become address.
Add ons for Store Locator Plus can extend the fields that can be imported. The field names usually match the field label, for example the Experience add on can have “Featured” and “Rank” as import columns.
Version 4.7.9 of the Store Locator Plus application includes changes to the admin interface user experience. Premier members who have current subscriptions for WordPress or are Enterprise level subscribers for MySLP have a new module that adds URL control functionality.
“Experience” Tab has been renamed “Settings”
Formerly the tab was referenced as “Experience ” (back end) where you had options to change how the search,map,and results interfaced. These options are now under the Settings tab, the functionality of the tab remains the same. The change was made so the nomenclature is now in line with the application interface standards.
The application separates functionality into different application modules. This will ensure that extra overhead is not incurred for features not being deployed in your environment. The interface for turning modules on and off is found under the General | Server tab in the Web App Settings section.
The WordPress plugin includes a module for building SEO friendly web pages based on location data. The option is a checkbox to enable the Pages module . This can be found under the General | Server | Web App Settings section.
Enterprise / Premier Users
Enabling the Territory Bounds module has been moved from the General | Data tab to the General | Server | Web App Settings section.
A new URL Control module has been added to the application. Enabling this module will turn on the interface to allow additional data to be presented in a web page URL to impact how the locator behaves.
URL Control : Allow Location In URL
The first URL Control option is to pass a location ID in via a URL. Adding ?location=<id> to the end of a web page address that hosts the locator will cause the page to load with the specified location being highlighted as if the map marker was clicked. The default behavior is to show the info bubble for that location.
We need to filter our locations by brand. Does your plugin or an extension to your plugin have this feature?
Assigning Brands To Locations
Power is the right choice for doing that. The Power add-on allows for simple categories or complex parent/child relationships between categories. Locations can be assigned to one or more categories. Your users can then search for locations based on those categories.
The Power Add-on Import allows the administrator to schedule your Import process from a remote file retrieval to provide more control over recurring imports from a full url where you CSV file resides and allows flexibility for scheduling the time for daily imports. WordPress cron is not exact, it executes the next time a visitor comes to your site. WordPress times are UTC/GMT time NOT local time. Set to none and leave the URL blank to clear the cron job. Example: 14:25. (Default: empty = do not run daily cron)
Checking your server, PHP and MySQL to ensure the character set is correct will go a long way toward importing special characters like registration characters.
If you have the Poweradd on for WordPress or the Power / Professional / Enterprise level for MySLP you will see a header tab in your Store Locator Plus menu labeled Categories. This is where you can establish and manage settings and determine the categories you want to add in the form section of the user interface. The two sub sections under Categories is Settings and Taxonomy.
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.
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.
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.
The Power Add On includes basic search and results reports. When Power is installed you will see a new Report tab on the Store Locator Plus admin pages. This tab is where you can view and generate locator search reports. See what visitors are searching for and what results are being returned. Continue reading “Basic Search and Results Report”→