Example CSV Import Files

CSV Imports are the most-used feature for our MySLP Professional users and for our WordPress  SLP self managed DIY customers that purchased the Power add on.

Learn about CSV Import formatting and other import notes.

Below files are examples only, you will need to set up your own import files to add your locations.

Example CSV Import Files

9 Restaurants Basic CSV Import

We consider this the simplest usable format for most businesses.  It includes the Store Name (Store), Address, City, State, and Zip columns.

You can download our example on our server here

9 Restaurants Full Address

A full address format of the 10 Restaurants Basic CSV Import format.  It includes the Store Name (Store), Address, Address 2, City, State, and Zip, and Country columns.

https://drive.google.com/open?id=1jE_BZTGpHrAuZzYy-K7CwLcFanPzKGC9

9 Restaurants With Latitude and Longitude

The same 9 places with full address and latitude and longitude.   Including latitude and longitude gets the locations online and active on the site faster.  This was created from an Export CSV of the above Full Address file when we stripped the sl_id column and all the blank columns at the end, relabeled the header row to be user friendly.

https://drive.google.com/open?id=1jkfRlY4K2retNGFaRVcW17WSLi_tfRmj

Remote file Retrieval; (Currently being patched )

One quick way to tell if your file is accessible is to put the URL you are using for your imports into your browser. Does it download a CSV file you can open with a text editor? If No; It isn’t a “vanilla” CSV file readable by the “Internet”.

This is the link you can use to see if remote file retrieval is working

For example — if you go HERE
https://demo.storelocatorplus.com/wp-content/uploads/2020/04/9-Restaurants-With-Lat-Lng-Cat.csv

you see an option to download a file

But if you go here :
https://demo.storelocatorplus.com/9-restaurants-with-lat-lng-cat/

it shows you a web page. That second link above from our demo site is NOT a valid remote CSV file URL

Google changed how share links on drives are working and we have found no way to get to the raw CSV file with any links they provided to us.

So Google Drive hosted CSV files is likely never going to work again.   Just one more way for them to track everything you do online by using an embed object vs. a flat CSV that they give you access too.

Info Tab: How to use WPSLP

INFO TAB

You will find useful links to our documentation site as well as news and posts about releases, technical information and an overview of the plugin.

How to Use Guide and Getting started links

 

 

 

Plug-in environment

 

What is meant by the  Plugin Environment.

The plugin environment shows the versions of Store Locator Plus, and any active SLP add-ons you have installed, as well as the WordPress version, php version, MYSQL , the domain name and other useful data

This information is required when posting in forums. You can find the release versions under your account Downloads List, and/or review the Release details to see if you have the most recent version of Store Locator Plus and the various add-on packs.

 

Location Imports

Location Imports are handled via a CSV file for users that signed up for the MySLP Professional service or are using the WPSLP Power Add On. With MYSLP the import feature is under the StoreLocatorPlus sidebar/locations as shown in screenshot. If you are using WPSLP self managed and have the Power add-on it will look similar.

CSV Import Format

Getting the proper CSV format can be a challenge when using spreadsheet apps like Excel or Numbers.  Here are some tips to getting a valid CSV format out of a spreadsheet app:

  1. Make sure you always have a header row.  That tells the import process what data is in each column.   The column headers have meaning, so be precise.
  2. When a cell is a text field that STARTS WITH A LEADING ZERO, make sure you explicitly mark the cell as text.   The easiest way to do this is to type a single apostrophe then the number when adding data to the cell as in ‘01886 for the zip code 01886.
  3. Always export with UTF-8 support enabled.
  4. Export to a CSV format.  Comma delimited not tab delimited and quoted strings if given the option.

Check out the Example CSV Imports post to get some usable import files you can play with.

Search Panel Settings

How SLP Search Works

Store Locator Plus searching can operate in radius or discrete search mode.  The default mode is radius based and is the premise behind much of the operational aspects of the Store Locator Plus plugin.  Additional search features and settings can be obtained through the  Experience Add-on or Professional subscription suite and/or  the Premier /Enterprise Subscription (see below).