Over Query Limit

Thank you for the information. You should add this information to your plugin before someone decides to purchase.

Can you please let us know if you found another solution? or a cheap hosting alternative?

Thank you.
P.

What about adding fields to the bulk upload that allows you to enter the lat & lon coordinates yourself?

Our database of stores already has the locations, but best I can tell it is choking on the limits.

Is there any way to just feed the coordinates to the database using the bulk upload without having Google do the Geolocating?

Thank you for all the help

As a follow up, after all the testing yesterday I of course ran over the limits pretty quickly for a 24 hour period.

The biggest problem I was having was during the import I was getting MANY that either came back as ‘could not geolocate’ for an address, or it was on about 50% of the bulk upload items putting the phone number in the email field (but only on half the entries, and they were all in the same column. Was a very weird problem.

So I broke up the full import into three separate files of 500 stores each and it solved all the problems with the import.

Out of 1449 total stores we only had 7 that couldn’t geolocate, and of course that is probably just bad data that needs to be fixed, and I didn’t run into any of the phone numbers ending up as email addresses.

I broke up a file with about 2500 stores into 4 .csv files with Retries set to 5 and just uploaded the first one with only 2 missing geocodes and no over limit messages. I plan to upload each of the 3 others one per day. (When I first tried uploading all 2500 stores about half got over limit messages.)

My question is: Are the geocodes required for Store Locator to include stores in the search?

If I enter locations manually, geocodes aren’t needed and it still works. But the first time I used the bulk upload, with all 2500 stores, the ones that weren’t geocoded didn’t show up in the search results, even when searching for the specific zip code (and checking that the zip code was accurate).

This time, though, the 2 with missing geocodes do seem to show up.

If it isn’t needed for Store Locator to work, why use Google Geocodes at all?

thanks,
Pat

I’m confused because I don’t know what Google Maps API key is or does and so I haven’t used it in SLP.

But since manually entered store data (we don’t have lat/long data) seems to work, maybe SLP gets the geocodes some other way, or the way you described (which I didn’t understand)?

Because another clue – for you, not me, since it’s working for me now, so far – is that for one of the two stores that turned up “uncoded” with a red highlight, the store actually shows up in search results. And when I clicked the edit button to add lat/long, those data were already there!

No need to respond to this message or educate me on Google Maps API key; I’m just hoping my (admittedly clueless) clues help you decide whether to remove the troublesome Google Maps API key in the next release.

Meanwhile, I’m also hoping my plan to upload 25% of the total store locations a day (roughly 650/day) continues to work. The data is very simple (4 columns), very complete, and very clean.