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:
All field names can drop the leading “sl_” for readability. For example sl_address can become address. The field names usually match the field label, for example the Experience add on can have “Featured” and “Rank” as import columns.
Whether doing a bulk import or adding locations by hand there are times when you will see a “location uncoded” or “cannot geocode” error message. This is always the result of an address that was sent to Google that cannot be processed in their address location system.
Some clients have datasets of 200,000 locations, none of which include latitude/longitude coordinates, only U.S. street addresses. Often customers want to know import limitations including Google’s limit. As of June 11, 2018 those geocoding limits will change. You will have a pay as you go billing requirement. You will need to reconsider how to import, how often to import , and whether to break the list into smaller chunks , or skip geocoding, or switch to the MYSLP SaaS managed service.
In order to perform bulk location imports with a CSV file for the WPSLP plugin you will need the Power add-on installed. WPSLP Power add-on does not alleviate the need for you to obtain your own API key. MySLP users do not need to obtain their own API keys but will need the Professional level plan or higher to import and may have limitations according to the plans.
Importing locations with territories follows the same procedure as importing a standard locations file. As with all location files the format must be a proper CSV file exported using the UTF-8 character set with no special or non-printable characters.
The Locations panel in Store Locator Plus is where you add, manage, edit and/or delete locations.
Actions and Filters
Under the Manage Locations panel there are drop down fields and filters that can be applied to display the pagination interface. If you have a large number of locations, bulk actions can be a very useful tool. If you have more locations than can fit on the display, you can set the display filter to show more locations. You may also use filters to display and manage non – geocoded locations, or show locations with certain properties. The display can be adjusted to suit your needs but configuration constraints and/or server constraints may effect your outcome.
Not all Bulk actions will appear if you have only the base plugin installed. Bulk action filters for removing Tags, performing Exports, geocoding all uncoded, and bulk categorize certain locations will be shown if you have the WPSLPPower add-on or Power level Plan for MySLP
The default number of locations that will be displayed on the admin user Interface is 10. Selecting a large number to display can be useful to view or manage but if your server capacity cannot handle it or changes and you go back to manage locations months or years later and try to access your locations panel, you may see no locations panel. If you see the wheels churning on your computer with no results this could be the reason. If you are not sure of the capabilities of your server, browser and various other factors that effect memory, and inhibit loading and displaying fields, err on the side of caution and set the Filter Display locations back to a manageable size before leaving the panel. If you are migrating servers from a “heavy duty” server to a less robust server, or if your memory becomes an issue you will need to reset the display to a manageable number. If you do not take this precaution , the only way to reset the display field is by using Janitor. See Troubleshooting for more info.
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.
Associating Store Locator Plus locations with WooCommerce products is a new feature provided by the Premier plugin for Store Locator Plus. The Premier plugin is an add-on that is available exclusively to Premier Subscription holders.
In order to activate the WooCommerce product mapping features of the Premier add-on, you will need to WooCommerce installed and activated on your site. When WooCommerce is installed the WooCommerce modules are automatically activated within the Premier add-on. You should activate WooCommerce before importing locations with WooCommerce product relations.