Reply To: Branches not appearing in search results

Home Forums Store Locator Plus Branches not appearing in search results Reply To: Branches not appearing in search results

#29064

Lance Cleveland
Keymaster

Is bearwood showing in the right location on the map?

This is what is coming back from that search at:
http://www.thesouthernco-operative.co.uk/food/co-op-store-finder/

(BTW, always try to post a clickable URL so we can test.)

SELECT *,( ‘3959’ * acos( cos( radians(‘52.4768152’) ) * cos( radians( sl_latitude ) ) * cos( radians( sl_longitude ) – radians(‘-1.9698994000000312’) ) + sin( radians(‘52.4768152’) ) * sin( radians( sl_latitude ) ) ) ) AS sl_distance FROM wp_store_locator LEFT JOIN wp_slp_extendo USING(sl_id) WHERE sl_latitude REGEXP ‘^[0-9]|-‘ AND sl_longitude REGEXP ‘^[0-9]|-‘ AND ( NOT sl_private OR sl_private IS NULL) HAVING (sl_distance < 25.000000) OR (sl_distance IS NULL) ORDER BY sl_distance asc LIMIT 25 count: 0 response: [] This is telling me that you do not have any locations with 25 miles of bearwood. Google things bearwood is at 52.4768152 latitude , 1.9698994 longitude. If you do not have any locations within 25 miles of that point on the map they will not be returned by the search. When I search within 500 miles the locations are returned. Try increasing your default radius.