Top

Your CSV File and What You Need to Know about It

When building your CSV file for upload to Store Locator, there are a few things you should know:

The CSV file should be populated with at the very least the required info. "What is the required info?" you say. Well, it's Name, Address, Address 2 (if necessary, I'll explain more later), City, Province/State, Country, Postal/Zip Code. This info MUST be there for your upload to work.

Here is a little more on what is expected in each field (in Excel or whatever you are using - each field is its own column):

1. Address: should be simple and should be the physical location. This means that it should look like 123 Easy Street (123 Easy St. is also acceptable) and have no other info in it (other info = BAD). Examples of other info:

  • PO Box addresses will not work as they are mailing addresses not physical locations and you need a physical location to have that location appear on a map.
  • Locations that are in malls/shopping centres should just be the Mall address, no need to get complicated here.
  • Addresses that look like "At the corner of _____ and _____" will not work either.
  • Make sure you have the correct address. Just because the location has their address on their site, make sure to confirm it either by plugging it into Google maps or by contacting them to make sure.
  • NO SPECIAL CHARACTERS. I can't emphasize this enough. Having special characters in the address or in any field, can often cause issues in the geolocation of the stores. Special characters include: !@#$%^&*()_+=-<>{}[]. This can sometimes unfortunately affect other languages which use non-Latin characters. However, we are working on this so hopefully in the future this will be resolved.
  • Online only stores should be excluded from your CSV as online stores do not have physical locations and no physical location = no pin on a map. To address this, most people include these location in the footer below the map (see footer section in your display settings). Any text added into this area will appear below the map.

2. Address 2: This is used for including things like unit number, buzzer codes, other useful information that would not be considered address info but is still pertinent to accessing/finding the location.

3. City, Province/State, Country: Pretty self explanatory, but MUST, MUST, MUST be there, so don't forget to add this info. Best practice when entering these in is to use the full spelling of each, it makes things easier.

  • There is one exception to this rule: If the location you are entering is part of a country that doesn't have or use provinces/states then just leave this spot blank. I know it sounds counter-intuitive, but do not put anything in, the app will figure things out.

4. Postal/Zip Codes: Make sure you have the correct one for each address. There is also formatting you can set (in most software) for this column so it retains the Postal Code or Zip Code format correctly. You do not want to include any other text or anything at all for that matter in this section.

5. All other info is not required as it will not affect the geolocation of the store, but don't let that stop you from filling it in. Please pay attention to what is inputted though as customers will notice and will let you know when the phone number (for example) for a location is wrong.

 Here is an example of what this all should look like:

Name Address Address 2 City Province/State Country Postal/Zip Code
Bold HQ 50 Fultz Blvd   Winnipeg Manitoba Canada R3Y 0L6
Guy's House of Hair  123 Fake St Unit 10 Beverly Hills California USA 90210

 

Now with all this amazing info populated in the CSV you want to save that file. Make sure that you save as CSV and not other formats. Once saved, you can start the upload from in the app, one thing though, there is a limit of 1,000 stores geolocated per day. So this means that if you have 3,000 stores in your file, it will take about 3 days or so to geolocate all the stores. If for some reason there are problems you will be emailed a list of the stores that failed (more details below). 

Failed Geolocations: if this happens(hopefully it doesn't, But...), you will be emailed a list of locations that failed to geolocate. With this info, you will need to start checking the address info, etc of these locations. If for some reason the address info is correct but the location either is in the wrong place or near Africa(weird I know, but it happens), check out this FAQ article on how to fix

Of course, should you have any questions at all we are always here to help! :-)

Contact our Support Wizards here and we will do our best to help. 

Have more questions? Submit a request