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):

sl_store,sl_address,sl_address2,sl_city,sl_state,sl_zip,sl_country,sl_latitude,sl_longitude,category,sl_tags,sl_description,sl_email,sl_url,sl_hours,sl_phone,sl_fax,sl_image,sl_private,sl_neat_title

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. The field names usually match the field label, for example if you have  the Experience add on  or the Professional level or higher SaaS plan , you can have “Featured” and “Rank” as import columns.

Results Layout Shortcodes and Attributes

Changing the results layout is a feature provided for Professional level accounts. Users of the self-managed WordPress plugins will find this in the Experience add on.

Default Format

The default format for the results string uses the numerical encoding for the various data elements that can be rendered.   This default string format is present in the base Store Locator Plus plugin.  You can reset  to the default at any time by deleting the entry in the Results Layout field under  Settings/Results/Appearance and saving the settings.

Location Results Report

Location Results reports are included with the Professional or Enterprise plan. This report is designed to show the locations that were returned by users entering addresses on the search form when looking for locations. This can be useful for determining which locations are appearing most frequently for your site visitors.

To view this report you’ll need to turn on reporting features as outlined in the Reports documentation.

Location Results Report 2208.15+

This report will show up to the top 500 locations returned within the date range selected.

Location Search Report

Location Search reports are included with the Professional or Enterprise plan. This report is designed to show what addresses users are entering on the search form when looking for locations. This can be useful for determining areas where your site visitors are looking for your product or service.

To view this report you’ll need to turn on reporting features as outlined in the Reports documentation.

Location Search Report v2208.15+

This report will show up to the top 500 searches within the date range selected.

How To : Location Categories

Assumptions

WordPress environment is setup and configured including activation of the following plugins

  • Store Locator Plus®
  • SLP Power add on

In addition map service (Google API keys) should be in place and some locations should be added to the system.

A page has been created with the [slplus] shortcode present and the map is rendering properly.

Users are logged in as a WordPress administrator (the process will be slightly different for SaaS users).

Adding Categories To Locations

Objective

Create a location category and attach it to an existing location.

User Action: Add A Location Category

  1. Click on Store Locator Plus® | Categories in the WordPress sidebar menu.
  2. In the left “Add New Category Form”…
    1. Type a category name. (Restaurant)
    2. Click Add New Category
Result

The new category should appear on the category list on the page.

Category list after adding the restaurant category.

User Action: Attach Category To Location

  1. Click on Store Locator Plus® | Locations in the WordPress sidebar menu.
  2. Click the Edit action icon on the first location.
  3. Check off the box next to “Restaurants” in the Power | Categories section of the form.
  4. Click Save.
Result

The category is assigned to the location and appears on the location table.

The location with an assigned restaurant category. This view is showing fewer columns as the Screen Options was updated to removed unused columns from the table view.

User Action: Show Category Select On Front End

  1. Click on Store Locator Plus® | Settings in the WordPress sidebar menu.
  2. Change the Category Selector setting to “Single Drop Down”.
  3. Click Save
  4. On the front end, go to the page that has the [slplus] shortcode.
Result

The search form for the map should show a category drop down.

The front end page with the [slplus] shortcode, showing the category selection filter.

User Action : Filtering Locations With Category

  1. On the front end, go to the page that has the [slplus] shortcode.
  2. Enter an address, choose a category.
  3. Click “Find Locations”.

Locations Panel: Manage Locations

The Locations panel in Store Locator Plus is where you add, manage, edit and/or delete locations.

Bulk Actions and Filters

SLP Locations panel has a bulk  tab with drop down actions and  other filters that can be applied .   If you have a large number of locations, bulk actions can be a very useful tool. If you have more locations than can fit on the display, you can set the display filter to show more locations. You may also use filters to display and manage non – geocoded locations, or show locations with certain properties. The display can be adjusted to suit your needs but configuration constraints and/or server constraints may effect your outcome.

Not all Bulk actions will appear if you have only the base plugin installed.  Bulk action filters for removing Tags, performing Exports, geocoding all uncoded, and bulk categorize certain locations will  be shown only if you have  the WPSLP Power add-on or  Professional or Enterprise  level Plans for MySLP

The default number of locations that will be displayed on the admin user Interface is 10. Selecting a large number to display can be useful to view or manage but if your server capacity cannot handle it or changes and you go back to manage locations months or years later and try to access your locations panel, you may see no locations panel. If you see the wheels churning on your computer with no results this could be the reason. If you are not sure of the capabilities of your server, browser and various other factors that effect memory, and inhibit loading and displaying fields, err on the side of caution and set the Filter Display locations back to a manageable size before leaving the panel. If you are migrating servers from a “heavy duty” server to a less robust server, or if your memory becomes an issue you will need to reset the display to a manageable number.  See Troubleshooting for more info.

Map Settings for Store Locator Plus®

Under the menu for SLP / Settings /Map  :

The settings contained in the map panel will change the functionality of the map domain, center map, zoom and appearance.

The following settings are available to manage functionality for both WPSLP stand alone plug-in and MySLP SaaS managed service..

At Startup

  • Center Map:   This is where you enter an address, or a state, or a location or  a specific latitude and longitude to be displayed as the initial focus for the Map.   If nothing is entered in this box , the default will be the center of the United States .   Google map has determined the center of  United States to  be somewhere in Kansas.  Example:  See Google Localizing the Map:  The geocodes “Toledo” based on the default region (US) to “Toledo, Ohio”  or  one which biases results based on a region set to ES (Spain) to “Toledo, Spain.
  • Center Latitude Fallback: Center Longitude Fallback:  These are the latitude/longitude settings  that will be called if the Google server is “busy” or offline and not able to geocode or “call” to load your locations.  If you reset to blank it will fill in with the Center latitude/longitude of the map domain you have chosen.    You can have a different Lat/long fallback  then your map domain or center map if you  choose.    An image of your fallback will  be displayed