Bulk Import and Export Stores

Store Locator allows you to do a bulk export and import 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.

 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.

 


 

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 required.

 


 

  1. From within the Store Locator app, select Stores.
  2. Select Bulk Import.
  3. Create a CSV File with your store information like the Store Locator Import Template.

    SL create a CSV file

    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.

  4. Under Import, select Choose File.
  5. Use the file manager to navigate to your file, choose it, and select Open.
  6. Select Upload.
  7. Select the Store Attribute that matches each column.

    SL select store attribute

  8. Select Start Importing.

 


 

  1. From within the Store Locator app, select Stores.
  2. Select Bulk Export.
  3. Select Override Email and enter in a different email address. (optional)

    SL select override email

  4. Select Export.

 


 

  1. Bulk export your stores.
  2. Open the file in Excel (or a similar program).
  3. Update the information accordingly.
  4. Save the file as a CSV file (UTF-8).
  5. From within your Store Locator app, select Stores.
  6. Select Manage Locations.
  7. Select Delete All Stores.

    SL select delete all stores

  8. Select OK.
  9. Bulk import your stores back into the app.

 


 

FAQs

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.

Extra Field

The name of each Extra Field must be written as it appears within the Store Locator app admin under Settings > Extra Fields.

Extra Field Names

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.

Extra Field ImportExtra_Field_Dropdown.png

 


 

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.

Store Group

The name of each Store Group must be written as it appears within the Store Locator app admin under Settings > Store Groups.

Store Group Names

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.

Store Group ImportStore Group Dropdown

Was this article helpful?
0 out of 0 found this helpful