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.

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.

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

Location Imports

Location Imports are handled via a CSV file for users that signed up for the MySLP Power service or are using the WPSLP Power Add On.

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.

Continue reading “Location Imports”