Overview
Store Locator Map now offers bulk import functionality for your stores, supporting multiple file formats like Xlsx, xls, odt, and CSV. Additionally, allows you to do a bulk export of your stores using a CSV file.
Bulk exporting your stores will send a zipped CSV file to your email, which allows to make changes to all of your stores in bulk. Then, you can bulk import your stores back into the app.
If you want to make bulk adjustments to other areas of your store, all that's needed is to export your stores from the app, make the necessary changes, then re-import the stores back into the Store Locator app.
In this example, we'll demonstrate how the process works using a CSV file, which can be applied to other supported file formats.
Pro-Tip
Need a hand with your import? We're here to help! Please reach out to our Merchant Success team here for further assistance.
CSV File Requirements
Note: Longitude & Latitude are not required fields; Google Map API must be setup prior to importing for addresses to be geolocated automatically during bulk Import
Store Name
This information is required.
Address
This information is required.
The physical address of the store.
- Locations within a mall or shopping center should only include the mailing address.
- Locations that are online only should be excluded.
Note: P.O. boxes are not supported.
Address 2
This information is not required.
The store's unit number, buzz code, or other information relative to the store's street address.
City
This information is required.
Note: City names must be written in full. Abbreviations will not be accepted.
IE. Winnipeg, Toronto, Chicago
Province / State
This information is required.
Note: Province and State names must be written in full. Abbreviations will not be accepted.
IE. Manitoba, Ontario, Illinois
Country
This information is required.
Note: Country names must be written in full. Abbreviations will not be accepted.
IE. Canada, United States
Postal / Zip Codes
This information is required.
Phone
This information is not required.
Bulk Import
- From within the Store Locator app, select Import and Export
- Create a CSV File with your store information like the Store Locator Import Template (attached at the bottom of this guide).
Note: When importing your CSV into the Store Locator app, all 6 fields are required. All addresses have to be full, and cannot be in short form. - Under Import, select Choose File.
- Use the file manager to navigate to your file, choose it, and select Open
- Select Upload
- Select the Store Attribute that matches each column
- Select Start Importing.
Bulk Export
- From within the Store Locator app, select the Import and Export and open Bulk Export tab
- Select Override Email and enter a different email address. (optional)
- Select Export
Update All Store Names At Once
- Bulk export your stores.
- Open the file in Excel (or a similar program)
- Update the information accordingly
- Save the file as a CSV file (UTF-8)
- Open Store Locator app
- Select Manage Locations
- Select the stores you want to delete and click on "Delete selected"
- Select OK.
- Bulk import your stores back into the app.
FAQs
How do I import a store with Extra Fields?
When importing a store with Extra Fields, a column for each extra field must be added to the .CSV file in order to be properly linked.
The name of each Extra Field must be written as it appears within the Store Locator app admin under Settings > Extra Fields.
During the import process, you will be prompted to match the column to the in-app field. Extra Field columns will appear as what was entered into the .CSV file, as seen below. Simply click the dropdown to the right of the column's name, then select the name of the column from the dropdown list.
How do I import a store within a Store Group?
When importing a store within a Store Group, a column for Store Group must be added to the .CSV file in order to be properly linked.
The name of each Store Group must be written as it appears within the Store Locator app admin under Settings > Store Groups.
During the import process, you will be prompted to match the column to the in-app field. Store Group columns will appear as Store Group, as seen below. Simply click the dropdown to the right of the column's name, then select the name of the column from the dropdown list.
Was this article helpful?
That’s Great!
Thank you for your feedback
Sorry! We couldn't be helpful
Thank you for your feedback
Feedback sent
We appreciate your effort and will try to fix the article