If you have the Power add-on using the import function and your csv file is incorrect, or your header rows are not accurate, or they have wrong field names, the columns may be misaligned and the data field for an address could not import and/or does not geocode. Check your import message log.
Google does not recognize an address. See FAQ post
This section pertains to the WordPress Store Locator Plus plug-in. If you are a subscriber to MySLP, our SaaS service, you can ignore this page.
Before you get started you will need to get a Google Maps API Key. UPDATE TO INSTRUCTIONS: Please note, there are some misleading instructions in the Google developer console telling you to create a browser-restricted API key when you move your site to production. You do not need to do that. Keep the same API key and do not add any restrictions unless you are adding HTTP referrer restrictions and obtaining a Geocoding key.
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 should determine how to import, whether to break the list into smaller chunks 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. MySLP users will need the Power level plan or higher. The following constraints can keep the locations from loading completely or cause slower processing.
If checked , use the faster MySQL Load Data method of file processing. Only base plugin data can be loaded, see the approved field name list.
This feature uses the MySQL Load Data command and is much faster than WordPress / PHP CSV file parsing, with the typical Google Geocoding limitations on performance and record counts (if you are not supplying, filling in the latitude/longitude data fields). This feature will only import basic location data. It does not import extended data fields or category data. If you use this along with per-entered latitude and longitude values you can import 100,000 locations in less than 10 minutes on a basic web server. The column headers must be included in the file and must match the basic fields. You do NOT need to include all columns.
Before you get started you will need to get a Google Maps API Key. Please note, there are some misleading instructions in the Google developer console telling you to restrict your API key when you move your site to production. The recommended way to do this for the majority of our WP SLP customers is to add HTTP referrer and add a geocoding key. The two key approach is available for version 4.9.15.