Skip to content

Bulk import your locations ​

The bulk import feature lets you upload multiple locations at once using a CSV, XLSX, XLS, or ODS file (up to 1MB). Import only creates new locations — it does not update or merge with your existing ones. Import is a paid feature on eligible plans. This article covers how to prepare your file and complete the import process.

Step 1: File preparation ​

The instructions below are for CSV files. The same steps apply to all supported import file formats.

Preparing your spreadsheet ​

To prepare your spreadsheet, download the sample CSV file from the import screen, or create your own. Keep the following in mind:

  • Field names go in the top row and the values go in the rows underneath.
  • Columns named the way the sample file and the export name them (for example Location name, Postal/ZIP code, Province/State) are matched to their fields automatically. Matching ignores upper and lower case, and older names such as "Store Name" or "Zip Code" are still recognised, so a file you exported earlier imports without re-mapping. Any column that isn't matched can be mapped by hand when you upload the file.
  • If you are importing search tags or custom fields, they must already exist in Store Locator before the import. For example, before importing you would create the tags and custom fields referenced in your file — if they don't exist, the importer has nowhere to put the values.
  • For custom fields, you can enter any text that applies.
  • For search tags, name the column after the tag and enter a "Y" (for yes) if it applies to that location; otherwise leave the cell blank.
  • For location groups, use a single Location group column and enter the group's name in the cell.

Working hours ​

Working hours go in seven columns, one per weekday (Monday to Sunday), placed just before Latitude — the same layout the export uses. Each cell holds the whole day:

What you wantWhat to enter
Open, 24-hour format09:00-17:00
Open, 12-hour format9:00 AM-5:00 PM
Two periods in the same day09:00-12:00, 13:00-17:00 (separate them with a comma)
Closed that dayClosed

Keep the following in mind:

  • Use one format per row. A location stores either 12-hour or 24-hour times, so a row mixing both (for example 09:00-17:00 on Monday and 9:00 AM-5:00 PM on Tuesday) is rejected. The format you use becomes that location's display format.
  • Each start time must be before its end time, and periods in the same day can't overlap.
  • If you leave all seven weekday cells blank, the location gets your default working hours template instead. Imported hours are saved as custom hours for that location — to assign a template afterwards, use bulk edit.
  • Shops still using legacy working hours have a single Working hours column instead of the seven weekday columns.

Saving as a UTF-8 CSV file ​

Once your spreadsheet is ready, save it as a UTF-8 CSV file:

  1. Save your spreadsheet as a CSV.
  2. Close the file.
  3. Find the file in its folder, right-click it, select Open With, and choose Notepad.
  4. In Notepad, go to File > Save As. Near the Save button there is a dropdown labelled Encoding — select UTF-8.
  5. Make sure there is a .csv extension after the file name.
  6. Click Save. Your file is now ready for import.

WARNING

  • Longitude and Latitude are not required fields, but including them speeds up the import — without them, each address is geocoded automatically, which takes longer.
  • Write City, State/Province, and Country in full — abbreviations are not accepted.
  • Populate all 6 mandatory fields: Name, Address Line 1, City, State/Province, Country, Postal Code.
  • We can import a maximum of 1,000 locations per day.

Step 2: Import ​

  1. Go to Apps > Store Locator > Locations.
  2. Click the Import button.
  3. Drag and drop your file, or click Add file to browse (CSV, XLSX, XLS, or ODS, up to 1MB).
  4. Optionally check Replace all existing locations to delete all current locations before the new ones are imported.
  5. Click Next.
  6. Match columns by relating column names from your file to the standardized fields used within Store Locator.
  7. Click the Import button to confirm.
  8. The modal closes and the import runs in the background — track progress on the locations table. Once complete you will receive a confirmation email. If it doesn't arrive, check your spam/junk folder.

WARNING

  • If you didn't map all mandatory fields to columns in your file, the bulk upload is prevented.
  • Rows missing a mandatory field, or that duplicate an existing location, are skipped — the rest of the file still imports, and the confirmation email reports what was skipped.
  • Rows with working hours the importer can't read are also skipped. The email names the value and the day, for example Invalid working hours "9-5" on Monday., and lists the accepted working hours formats once at the bottom.
  • If any rows were skipped or couldn't be geocoded, the confirmation email includes an attached CSV file with every row from your import. It keeps your original columns and adds an Import status for each row (Imported, Failed, or Imported without coordinates), the field(s) affected, the reason, and what to do next. Correct the rows in that same file and re-upload it.
  • To remove all existing locations while importing new ones, check the Replace all existing locations option. Be aware this does not save an export of the existing locations first.
  • Sometimes geocoding fails to find a location and its pin appears in the middle of the ocean. This usually means the address isn't formatted the way the geocoding service expects. The email notification tells you which locations did not plot properly — drag those pins to the correct spots on the location editing page.