Bulk Import and Export Stores

Modified on Wed, 29 May at 6:07 AM

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

  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 (attached at the bottom of this guide).

    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.

Bulk Export

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

    SL select override email

  4. Select Export.

Update All Store Names At Once

  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

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.

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


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.

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?

That’s Great!

Thank you for your feedback

Sorry! We couldn't be helpful

Thank you for your feedback

Let us know how can we improve this article!

Select at least one of the reasons
CAPTCHA verification is required.

Feedback sent

We appreciate your effort and will try to fix the article