Search Results Out of Area

Please see this image in the link below for the results im speaking about. Also worth noting, it appears that the leading “0” for zip codes on the east coast of the USA is being dropped. Not sure if this has anything to do with it or not.

https://i66.tinypic.com/bharzt.png

The returned results are based on whether or not it falls within the search radius, not if the street / city contains the name of the searched location, in this case Portland.

The screenshot shows a search radius of 25 miles, and the first two results are 1.1, and 5.5 miles from the start point. So it returns the expected results.

What I think is going on here, is that the coordinates for the two locations are wrong. There is probably a ‘Portland Road’ and ‘Broadway St’ in Portland, and the Geocoder API picked the one in the wrong state.

If you open both locations in the editor and look at the preview map, are they placed in Portland or in another state?

I will try and add both locations to a map later today, and see where Google places them on the map.

It does look like the coordinates are off for these locations. I guess the next question is, how to I correct this? I have literally thousands of stores and not really a great idea of how many of them have bad coordinates. My client pointed out a few that he knows of but these are just the ones we know of.

Also, is there a way to import a CSV file. I’ve seen threads and replies which are really ambiguous about updating information vis CSV.

Ok…I figured out how to convert to the correct lat and long. Now I’m trying to import the CSV. I’m following a thread right now where it says to import the CSV into WP_WPSL_STORES table and I do not see this table listed under phpMyAdmin. How is this possible? Also, can I add fields for the lat and long to the CSV file and run the import to update these fields as well?

I have version 2.0.4

Really need some clear direction on this. Thank You

Really sorry here. I’m confused on this plugin. There’s addresses that the lat and long are auto found. Ok I get that.

But theres locations where the lat and long are off. I understand that but I don’t know how to find all of the locations where they are off. What do I do to fix this. Is this fixed with a CSV?

How did you initially enter the data for the two locations that have incorrect coordinates? Did you fill in the coordinates yourself, or did the plugin handled the geocoding?

The thread should mentions at some point that the wpsl_stores table was used before 2.0. This post shows you how to create it again. There are alternatives, but they won’t geocode the results for you.

Not sure what phpmyadmin does with existing fields if you import a CSV file.

Unfortunately the only way to find out if the lat / lng fields are correct is by checking it on the map.

But I think I found the problem. I added the first location from your image to a demo installation, and it geocodes it to Tennesse if I leave the lat lng fields empty and save the location. But if I then empty the lat / lng fields, and click ‘Preview Location’ then it does end up in Portland. So I guess you clicked ‘Preview Location’ before saving it?

I will look into this more later today, and see why it returns the incorrect location if you use the ‘Preview Location’ button.

You can try and use https://www.findlatitudeandlongitude.com/batch-geocode/ to geocode them before importing them?

So there is in this case indeed a difference between the Geocode results from the PHP request and the JS Geocode API request. No state is included in the previous data, but it does return the correct results.

If you fill in ‘304 S. Broadway St.,Portland,37148,United States’ in the geocode field on this page, and click ‘Geocode’ then it shows a different location, and also no state is included.

If you change the address to this ‘304 S. Broadway St.,Portland,TN,37148,United States’, so the state is included, then it does return the correct results.

The state is left out with both the PHP and JS Geocode request in the plugin, so I will include them in the next update, which will be out soon.

If you can’t wait for the update to be released, then you can email me at tijmen at wpstorelocator.co