CSV File Import Header

All Store Locator Plus CSV files must start with a file import header that indicates what data is in each column.

The first row of a base Store Locator Plus import file should look like this:

Please see the Example CSV files post for a sample base file with a header.

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:

  • sl_address
  • sl_city
  • sl_state
  • sl_zip

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.

To import files you must have the Power add on for WordPress plugins or be using the Power , Professional, or Enterprise level of service for MySLP.

Pro Pack Legacy Add-on not compatible with SLP version 4.8

Pro Pack Features

If you want to keep the legacy add-on, ProPack,  do not upgrade the base plug-in to version 4.8.   All individual legacy add-ons have been phased out over the past 2 years.  Please follow the SLP news feeds for important information.

Upgrades to SLP are optional.  We do not auto-update.  Unfortunately, if you already updated and now try to roll back SLP to pre – 4.8 version in order to retain the Legacy add-on functionality,  you would also need to rollback WordPress.   The SLP author does not recommend rolling back versions of any software or WP.   This is time consuming and messy, requires technical savvy, not to mention, you will miss  important security patches.     If you are confident that you know what is entailed and are willing to take the risk;  absolutely use a back-up service such as  Vault Press or Jet Pack. 

You may opt to take the worry out of updating with a My SLP plan.  Check out the Power and import options under  MYSLP SAAS

 

Curly Quotes In WordPress Shortcodes

WordPress blog posts likes to use curly quotes instead of straight quotes whenever you write an article.     Our documentation site is built on WordPress which means many of our articles are replaced any quotes we type in an article with curly quotes.

The problem is that the WordPress shortcode processor does NOT like curly quotes.   If you use curly quotes in a shortcode attribute such as [slp_directory by=”city”] and those quotes are “curly”, WordPress treats the quotes as a plain-old alphabetic character just like the C-I-T or Y in “city”.   In other words WordPress things you mean “by quote-city-quote” not “by city”.

Why is that an issue?

If you copy-and-paste most examples from this documentation site WordPress will copy the “pretty curly quotes” into your shortcode.     If you paste that into your WordPress page it breaks.

Straight versus curly quotes when pasted into a page.

An example of how this can impact Store Locator Plus can be seen from my example where I pasted the slp_directory shortcode directly from the docs site into my test site.    I get an invalid data query because WordPress added curly-quotes to my data field name.    The SLP database does not have a field name quotesl_storequote but does have a field named sl_store.

The fix?

Make sure you re-type each quote manually.  Typing the ” in your blog instead of copy-and-paste will ensure you are getting “straight quotes” in your shortcode attributes not curly quotes.

This is how the example looks now that the curly quotes have been replaced with straight quotes.

Store Locator Plus 4.7.9

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.

All Users

“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.

Upgraded Accounts

Enabling Modules

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.

Power Users

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.

URL Control

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.

 

Upgrading from Legacy add-ons to Power add-on

Return customers who have upgraded to the newer add-ons will notice a change in the location of some of the functionality/features  that were part of the separate legacy add-ons ,  now available in the Power add-on. (see Legacy to feature add-ons)

Legacy Add-on Tagalong = Categories on the header tab in the Store Locator Plus User Interface.

Legacy Pages = General / Data /Enable Pages.  To use the SEO Pages you must first “enable Pages” under this setting.

Legacy Contact Extender = General/Data/Enable Contact fields.

Legacy ProPack = Various fields and functions

  •  Import Under Locations/Import
  •  Location sensor checkbox is located under the General/User Interface tab.

 

 

 

Q. How do I remove or delete multiple tags that are associated with the locations?

A.  With the Power add-on you will find additional Bulk Actions under the Locations/Manage panel.  There is a  drop down menu under the Bulk actions tab that can be utilized to remove many, some or all tags associated with the location data.  Check off which locations you want to remove the tags from, or you may check off all and select the filter to “Apply to all”

Bulk Action with Power allows you to remove tags

Power (WPSLP) / Power (MySLP) Overview

The Power add on for WordPress Store Locator Plus and the Power level for MySLP product line share similar features and functionality.  Whereas they are similar, they are not interchangeable.  For instance, you cannot use the MySLP Power level service plan to export your WordPress location data and vice versa.  Note: where the WP symbol appears below, those features are built into the WordPress SLP Power add-on only.

Categorization

Assign categories to your locations that allow users to pick a category and show only those locations.  Great for showing service versus retail centers or locations that carry specific products.
Continue reading “Power (WPSLP) / Power (MySLP) Overview”

What To Buy: Filter By Brand

Question

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.

Add a category for each brand you offer and your users will be able to filter locations showing only those that offer specific brands.
Continue reading “What To Buy: Filter By Brand”

Import remote file retrieval

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)

Power 4.6 import back end

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.

Additional Import Data field headers

If you have the Power add-on you will have the ability to import data fields via a properly formatted csv file.  All columns MUST have a header row with the  field name. All fields are short text fields, up to 255 characters, unless otherwise noted.  The header text is NOT case sensitive.

If you are using the category (aka tagalong) functionality of Power you may want to import and assign a category slug on the fly.  The header field name is:

category (or plural categories).

If you wish to import and assign more than one category  per location , you will need to use a comma-separated list for the data field  (category).  Example: My location has more than one category associated with it, I want to indicate it is a hotel,restaurant, and has music.  Category  for that location would show under the column with the header row “category”…. hotel,restaurant,music

Alternatively, to define parent/child relationships , i.e.  hierarchical categories , use a double colon as the separator Example the Parent is Facility, the child is showroom.

Facility::Showroom.