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 the Store Locator Plus import file should look like this, you do not need the (sl in front of the header name for the basic import function to work):

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.

Store Locator Plus Additional Functionality

Store Locator Plus .    Premier subscription holders with active subscriptions for WordPress  Store Locator Plus or are Enterprise level subscribers for MySLP have a module that adds URL control functionality.

 

Upgraded  Premium Features

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 was moved from the General | Data tab to the General | Server | Web App Settings section.

URL Control

A  URL Control module was been added to the application for Enterprise or premier subscribers.   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.

 

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 add-on for WPSLP (DIY)  or the Power level plan for MySLP is the right choice for doing that.  Power allows for simple categories or  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.

For more complex hierarchical functionality , button barshorizontal check-boxes for categories and more customized approaches you might want to check out our WPSLP Premier subscription or the MySLP Enterprise level subscription

Add a category for each brand you offer and your users will be able to filter locations showing only those that offer specific brands.

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)

 

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.

Categories taxonomy and settings

If you have the Power add 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 within the form section of the user interface.  The sub sections under Categories is Taxonomy  and Manager.