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 a base Store Locator Plus import file should look like this:

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.

Add ons for Store Locator Plus can extend the fields that can be imported.  The field names usually match the field label, for example the Experience add on can have “Featured” and “Rank” as import columns.

To import files you must have the Power add on for WordPress plugins or be using the Power , Professional, or Enterprise level of service for MySLP.

Example CSV Import Files

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

Learn about CSV Import formatting and other import notes.

 

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.

https://drive.google.com/open?id=1L-vS5U9Db737x92O-qmecsAFqFd0CQBe

 

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, relabelled the header row to be user friendly.

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