CSV Import Duplicates Handling

The WPSLP Power Add On  or MySLP/Professional plan   allows you to import CSV files with several options.     Under SLP/Locations/Import  options.  You select which option you wish to use when determining how to update  locations  that match pre-existing locations.

There are several options available for duplicates handling. They are  Add, Skip, and Update.

General Settings

There are settings under the General tab for Admin , User Interface, Server, and Data. This documentation has been updated to reflect the Google API changes

Admin

The Admin tab is where your SLP Premier subscription Accounts ID , Add-on packs User info , and Update Notices are located. There is also a Reset Manage Locations button available for use to reset the back end Manage Locations  display page to the default view (10 locations per  page view). This feature was previously only available with the free SLP  Janitor Add-on.
2016general-admin
There is also a Locations management option  to Highlight the locations that are not geo-coded on the Panel that displays your entered locations.

Legacy Add-ons not compatible with SLP version 4.8 and higher

 Legacy Add-ons

If you want to keep the legacy add-ons, do not upgrade the base plug-in to version 4.7 or above.   All individual legacy add-ons have been phased out and replaced over the past 2  plus years due to security patches, coding changes, WP updates, maintenance overhead and inefficiencies that were no longer viable to support.  To find the match to your Legacy Add-ons,  see FAQ: Legacy versus featured add-on

Please follow the SLP news feeds for important information about updates.

Even if you received a notice in your WordPress admin panel that an update to your base plug-in is available, you do not need to click the update button.  All version updates to SLP are optional.  We do not auto-update like WordPress does.

If  you already updated (most likely if you are reading this) and now try to roll back SLP to earlier version to o retain the Legacy add-on compatibility.

Note:  Due to the security patches required by Word Press  you may also need to rollback WordPress.  Before attempting to roll back or downgrade WordPress or any plugins , make sure you have a recent back-up of your site.  Do not attempt this on a live site.

The SLP author does not recommend rolling back versions of any software or WP.   This is time consuming and messy, requires technical savvy,  and you will miss  important security patches.     If you are confident that you know what is entailed and are willing to take the risk;  it is still recommended to use a back-up service such as  Vault Press or Jet Pack. 

P.S. If you do not want the headache of maintaining back-ups , updating, obtaining a new Google API, you may want to consider moving over to a My SLP plan.   See  MYSLP SAAS

 

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

 

 

 

Map display options

Map Display

The Experience add-on for the WP Store Locator Plus or the MySLP/Professional Plan  allows you to customize the way your Map  is displayed and behaves.

With the WPSLP Experience add-on installed and activated  go to Settings/Map.

  • Show Map (default)
  • Hide map until search
  • Image until search
  • Do not autozoom
  • Full Screen (With  WPSLP Experience add-on or Professional level MYSLP)

Appearance

Additional options  are available to change your  Map layout and appearance    with the WPSLP Experience Add-on.   If you do not have the Add-on or a corresponding MySLP plan,  the  optional settings will  NOT appear.   (Note: There is a sidebar menu with MySLP/Professional under Store Locator Plus. See Adjust Locator styling for more information)

The additional options with the above mentioned plans or add-ons allows you to  hide the map , change the map layout, change the map bubble display, and/or  hide the map info bubble.  The Plugin Style under View (WPSLP) may supersede these settings. Choose one that  will compliment your theme or utilizes the add-on features available to you.

Locator Data – The Field Names

Store Locator Plus includes a default set of data fields that is included with every installation as well as extended fields provided by add-on packs.

For  data fields, including those added with the Extended Data Manager, you can output the data in the map info bubble or results layout,  by using the following shortcode:

[slp_location data.<field_slug>]

For example:

[slp_location data.contact]

[slp_location data.facebook_custom_url] (for someone that added a field named Facebook Custom URL).

Both the default data and extended data can be displayed in the search results, (for SEO Pages some fields will be [storepage field=contact] for SEO-friendly details pages. Most of the tools provided by the various add-on packs work best when using the field slug. The slug is a unique name for the field that is similar-to, but not exactly the same as, the field name.

The slugs are used in the add-on packs such as the layout strings from the Experience Add On in as well as the column headers for CSV Import in the Power Add On.

Default Location Fields

ID

Name

Address

Address Line 2

City

State

Zip

Country

Latitude

Longitude

Tags

The Pro Pack tags field. Requires Pro Pack for full functionality.

Description

Email

Website

Hours

Phone

Fax

Image

An fully qualified image URL, http:: with a full domain.

Private

May be used in the future as a 1|0 value to determine if a location is to only appear on the admin interface and not front end searches.

Neat Title

May be used in the future as an alternate store name or subtitle.

Linked Post ID

The ID of the related store_page entry where extra taxonomy data and other location data is stored. Used with Store Pages and Tagalong. Should not be modified.

Pages URL

The relative URL for the Store Pages linked post ID. Provides a processing shortcut for the Store Pages add-on pack.

Pages On

Used with Store Pages to determine which locations have been populated with Store Pages template content.

Option Value

A serialized JSON data object which can store extra location data. Slower and less direct than extended data fields.

Last Updated

A date and time MySQL timestamp indicating the last time the main data for the location was updated.

Initial Distance

The initial distance calculated between your center map latitude/longitude and the location.

Add On Pack Import Fields

These fields appear in the extended data table, slp_extendo. The field metadata, used to manage the slp_extendo table, is store din the slp_extendo_meta table.

Power Add On : Contacts Enabled

Identifier a unique location identifier from an external database that can be used to update existing locations in Store Locator Plus

Contact

First Name

Last Name

Title

Department

Training

Facility Type

Office Phone

Mobile Phone

Contact Fax

Contact Email

Office Hours – long formatted text

Contact Address – long formatted text

Notes – long formatted text

Featured – valid values are “1” for featured and “0” (zero).

Rank – an integer from 1 (highest rank/top of list) to 999999. 0 = no rank.

Power Add On : Categories Data

Power categories utilize the built-in WordPress custom taxonomy system. Standard WordPress category IDs are kept in the term_relationships and term_taxonomy tables. The relationship between locations and categories is managed via the slp_tagalong table that maps the Store Locator Plus id field to the WordPress Taxonomy term_id.

 

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.

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.

Use Dial Link For Phone Setting

Included in MySLP Professional and WPSLP Experience.

Find it under Settings | Results | Results Interaction

When the Use Dial Link for Phone Setting is checked it will make the phone number in your locations results clickable to auto dial by adding a tel: based hyperlink.

The dial-ready hyperlink will be used wherever the [slp_location] shortcode is used.   This includes the results under the map, directory landing pages, and in Store Pages if the [slp_location] shortcode is used instead of the [storepage field=”phone”] shortcode.

Extensions Pause

Use along with the Phone Extension Delimiter setting to handle pauses for extensions.

 

Formerly labelled: Make a Dial Link Phone number (clickable)