CSV Import Zip / Postal Codes formatting

Note: IMPORT requires  Power add-on for the stand alone WPSLP plugin  or if you are using MYSLP SaaS, the  Professional level or higher plan. 

When creating a CSV import file make sure the zip / postal code column is properly formatted as text so you do not lose leading zeros.

The column header for postal/zip codes is zip or sl_zip.

In the United States many northeastern postal codes start with zero.   Many sheets, Microsoft Excel in particular, LOVE to leave off the leading zero if you enter a zip code as 03907 and save as CSV.

Invalid Postal Codes
Invalid Postal Codes

In Excel, and many other apps, you can force a field where you are typing in numbers to be text by starting your entry with an apostrophe (‘).  Type ‘03907 when entering the data NOT 03907.

A good test to see if this is happening to you,  open your CSV file in Google Sheets and see what it looks like.  Does it look like the sheet above missing a zero and right aligned?

Another indicator that this column is set to a numeric type and not an text type is the data is on the RIGHT SIDE of the cell.  Text is left-justified (like sl_state) and numbers are right-justified.

MySLP SaaS: Deploying On WordPress

These instructions are for MySLP SaaS users only.  

MySLP is a monthly subscription service that allows you to deploy a locator map on ANY platform including WordPress.   It is a managed service where we handle the hosting of the locations, settings, and map software as well as handle the Google API key.   We keep the software updated so you don’t have to worry about it.

These instructions DO NOT APPLY to the stand alone, self managed WordPress plugin(s).

For our buy-it-and-own-it solution you will want to look at the WPSLP plugins instead of this page.

If you are NOT using My Store Locator Plus® you should think about it.

If you are using MySLP, read on…

You’ve already added your locations and generated your embed code per the instructions in our Getting Started post.  Now you are ready to deploy on your WordPress site.

Here we are going to deploy the script in a new page on our site.

MySLP : Deploying With Basic HTML

My Store Locator Plus can be deployed on any website technology that can publish basic HTML pages.   The functionality of the service depends more on the browser technology used by your site visitors than your web stack.

The most basic deployment is a local HTML file that is opened by your web browser.   Your desktop or laptop and even some mobile devices will allow you to create a basic HTML file on your device.   You can then open this file using that device’s web browser.

Deploying A SquareSpace Map

Deploying a SquareSpace map is a simple process that uses the SquareSpace embed block and a simple My Store Locator Plus (our SLP SaaS solution) JavaScript snippet.

Setting up a SLP  SaaS account, adding locations, setting up a SquareSpace account, adding the map, and deploying a site can take as little as 15 minutes.

Squarespace map.
Using Store Locator Plus to deploy a SquareSpace map.

Removing distance fields and editing Results

Settings > Results > Results Layout

Removing the distance from the results can be done by editing the Results Layout. You will see the results layout box if you have the Experience add-on for WPSLP or have the professional level plan or higher for MYSLP.

For MySLP go to Store Locator Plus > Settings > Results > Appearance
For WPSLP go to Store Locator Plus > Settings > Results > Appearance

With the Results Layout setting find the HTML span tag with the slp_location distance shortcode.

Delete that line.

Release Notes and Updates SLP 4.9.2 and above

Store Locator Plus 4.9.2  

Please check your versions on our Home site to ensure you are using the latest versions of the plug-in and add-ons.  A lot has changed since release 4.9.2.  See our News channel for latest information regarding WordPress, SLP, and Google changes. Changes to the terms for Google API  use went into effect or or about June 11, 2018.  This effected every plug-in that utilized Google APIs.  Newer Versions of  WPSLP  added fields for Google API key placement. This means, if you had been using older versions in order to keep legacy add-ons, and never added your Google MAP API key to SLP, your map will not display correctly. See News for current information

Our MySLP locator service  updates the versions for you and takes care of the Google Maps and geocode API s.  You add your locations and adjust your map look-and-feel settings– then when you are ready paste a JavaScript snippet into your website. It doesn’t even need to be running WordPress.

Store Locator Plus 4.8 and above updates will disable Legacy add-ons

Legacy Add-ons

The   auto-update of WordPress v 4.8.2 and above required a major update to the WP Store Locator Plus free base plug-in resulting in the end of compatibility with the popular Pro Pack , Tagalong and other Legacy add-ons.  The Legacy add-ons are no longer supported nor maintained and have been retired over the past two years as announced in news posts, blogs , changelogs, mail campaigns  and social media.  If you are not sure if your add-on is considered Legacy, see the FAQ comparison featured to Legacy add-ons

Time to invest in your future

Some of our customers were surprised by the change and retirement of the  Legacy Add-ons.  We tried to give as much of a heads up as possible using news blogs,  content news to the home site and reached out using a  Mail Chimp campaign for those most likely effected.   Ultimately, there is no sure fire method to reach the thousands of customers who may have had these older add-ons installed.  If there is one thing we know, change in the technical genre is inevitable.  The SLP support team will always endeavor to help our customers transition to the new age.  We pledge they will see real value-added from updating their site and software . Please take a moment to review the multiple benefits of utilizing the newer Experience add-onPower add-on.

Although downgrading to an earlier version of SLP is an option, you may note that changes to the WordPress code and their security patches may disable features. Before making any changes to your site you should ensure you are backing up your site WP database and files.  It is very important to take this step before you have issues or worse, site crashes.    WordPress security has become more robust over the years.

For more information please see this important message from the author:

Store locator Plus  updates and retired add-ons