The WPSLP Power Add On or MySLP/Professional plan allows you to import CSV files with several options. View the information under SLP/Locations/Import . You have various options to consider when determining how to update locations that match your pre-existing locations.
Options available on how to handle duplicates: Choose to Add, Skip, and /or Update.
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:
- 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.
- 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.
- Always export with UTF-8 support enabled.
- 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.