Having issues with “import and geocode” and troubleshooting steps

Steps to troubleshoot.

Firstly, it could be the limit that you’re IP address or server IP address is having from geo-coding, you may need to wait or try from another IP address. Also refer to the Geo Coding limit article available here.

The next important thing to do is to create and use the correct Google Geocoding API key

How to know if your Google API (Geocoding) key works?
Try to click this link https://maps.googleapis.com/maps/api/geocode/json?key=YOUR_API_KEY&address=5300+Sunset+Boulevard%2C+Lexington%2C+SC%2C+USA%2C+29072 and replace YOUR_API_KEY with your Google API key. You can see the details loaded if it’s successful. If it fails, (REQUEST DENIED) look back and follow the instructions to create the API key above.
If your Google API key works, proceed to the next step
Next, try the sample csv (available for download at the import/export page or Download Sample CSV),  if the sample works, follow the next steps for further troubleshooting.

A. If sample CSV works but yours does not

Edit your csv in Notepad++ instead of Excel/spreadsheet tool and make a comparison against the sample csv, you need to ensure that the format is the same i.e comma, quotes, etc and follow below criteria.

1) column with the store title must be populated with a name
2) columns must be in the exact order and quantity as in the sample CSV


Notice: If you’re using Mac, you can also refer to this articles below:

TextEdit has separate plain text and rich text modes. You’ll have to select Format > Make Plain Text or set the default format to plain text first.


Reference link:

1) https://s2member.com/kb-article/how-do-i-save-the-importexport-csv-with-excel-on-mac-os-x/

2) https://discussions.apple.com/thread/4431147?tstart=0

Google Docs

Alternative Tool that works is Google Docs (https://docs.google.com)

Finally, if you’re uploading a huge file, check on max_execution_time settings in your PHP server configuration if you’re facing timeout issues

B. If the sample CSV doesn’t work

Check the following with your server provider:

1. cURL library is turned on

2. Ensure that file_get_contents is turned on in server settings

3. /php/tmp folder on your server is writable


4. Check with your hosting provider on max_execution_time and max file upload size settings on your server

5. Check your addresses that are not successfully geocoded at http://www.latlong.net to see if the format is correct



Users who have LIKED this post:

  • avatar
  • Sofia Moss
  • avatar
  • avatar
  • Alex