If your locations are showing up in the wrong place on the map, the issue is almost always with geocoding. Here's how to diagnose and fix it.
What is geocoding?
When you add a location, StoreRocket converts your street address into latitude/longitude coordinates using Google's Geocoding API. This is how the map knows where to place the pin. If the address is ambiguous or incorrect, the pin can end up in the wrong spot.
Common causes and fixes
Location appearing in the wrong country
The address might be ambiguous. "Portland" exists in both Oregon and Maine. "Springfield" exists in dozens of states.
Fix: Make sure the full address includes city, state/province, AND country. The more specific the address, the more accurate the geocoding.
Location at coordinates 0,0 (off the coast of Africa)
This means the location has no usable coordinates, so the pin sits at 0,0.
Fix: Open the location from Locations, check the address in the Location section for typos or missing information, and click Save. StoreRocket will re-geocode with the corrected address. If it still fails, manually enter the correct latitude and longitude: open Enter coordinates manually under the map, or drag the marker. You can find the coordinates by right-clicking on Google Maps and copying them.
Locations drifting after re-sync from Google Sheets
If you sync from Google Sheets regularly and notice locations moving, it's because their address in the sheet changed. StoreRocket places the pin again whenever an address changes, and a slightly different wording can land a little further along the street.
If the address is the same and the Lat and Lng cells are blank, StoreRocket keeps the pin the location already has.
Fix: If you have precise coordinates, add Latitude and Longitude columns to your spreadsheet. When these are provided, StoreRocket uses them directly instead of geocoding the address.
Imported locations scattered randomly
If a batch import placed locations all over the map seemingly at random, the address columns in your CSV might be misaligned. For example, city data ending up in the state column.
Fix: Open Location Data > Import and select Excel template or CSV template. Make sure your data lines up with the correct columns. Pay special attention to Address Line 1, City, State, Postcode, and Country.
When you upload a file, StoreRocket shows how it read each column before you publish. A column it doesn't recognize appears under To match, where you can choose the right field.
If your file has Latitude and Longitude columns, StoreRocket uses those numbers instead of the address. Clear them if you want the address used.
Manually setting coordinates
If geocoding can't get the right location, you can always set coordinates manually:
Go to Google Maps
Find the correct spot
Right-click and copy the coordinates
Open the location in StoreRocket from Locations
In the Location section, open Enter coordinates manually, paste the Latitude and Longitude, and click Save
These manual coordinates won't be overwritten unless you change the address and trigger a re-geocode.
Questions? Message us on live chat.