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 Power add-on, you can output the data in the map info bubble or results layout, by using the following shortcode:
[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
Slug: id Data field: sl_id Type: integer (auto-assigned)
Slug: store Data field: sl_store Type: string up to 255 characters
Slug: address Data field: sl_address Type: string up to 255 characters
Address Line 2
Slug: address2 Data field: sl_address2 Type: string up to 255 characters
Slug: city Data field: sl_city Type: string up to 255 characters
Slug: state Data field: sl_state Type: string up to 255 characters
Slug: zip Data field: sl_zip Type: string up to 255 characters
Slug: country Data field: sl_country Type: string up to 255 characters
Slug: latitude Data field: sl_latitude Type: string up to 255 characters
Slug: longitude Data field: sl_longitude Type: string up to 255 characters
Slug: tags Data field: sl_tags Type: Text up to 4096 characters
The Pro Pack tags field. Requires Pro Pack for full functionality.
Slug: description Data field: sl_description Type: Long text, as determined by your MySQL settings. More than 4096 characters.
Slug: email Data field: sl_email Type: string up to 255 characters
Slug: url Data field: sl_url Type: string up to 255 characters
Slug: hours Data field: sl_hours Type: string up to 255 characters
Slug: phone Data field: sl_phone Type: string up to 255 characters
Slug: fax Data field: sl_fax Type: string up to 255 characters
Slug: image Data field: sl_image Type: string up to 255 characters
An fully qualified image URL, http:: with a full domain.
Slug: private Data field: sl_private Type: A single character string.
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.
Slug: neat_title Data field: sl_neat_title Type: string up to 255 characters
May be used in the future as an alternate store name or subtitle.
Linked Post ID
Slug: linked_postid Data field: sl_linked_postid Type: integer, auto-assigned
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.
Slug: pages_url Data field: sl_pages_url Type: string up to 255 characters
The relative URL for the Store Pages linked post ID. Provides a processing shortcut for the Store Pages add-on pack.
Slug: pages_on Data field: sl_pages_on Type: a single 1|0 character
Used with Store Pages to determine which locations have been populated with Store Pages template content.
Slug: option_value Data field: sl_option_value Type: text up to 4096 characters
A serialized JSON data object which can store extra location data. Slower and less direct than extended data fields.
Slug: lastupdated Data field: sl_lastupdated Type: timestamp
A date and time MySQL timestamp indicating the last time the main data for the location was updated.
Slug: initial_distance Data field: sl_initial_distance Type: A float.
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
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.
Table: slp_tagalong field: sl_id = the store id field: term_id = the WordPress taxonomy id
Power Add On : Pages Data
SEO pages follows a different format.
To add Social media data:
shortcode is: [storepage field=socialiconarray]
On SEO pages all data fields must start with storepage field = in the shortcode.