How can I fill in the franchisee migration file correctly?

Franchisee bulk migration file fields

When onboarding multiple franchisees at the same time, you will need to upload a Franchisee Migration File. It is important for each field to be filled in correctly and according to a specific format

The below table provides an explanation of each field with a corresponding example.

Column name

Explanation

Example

Merchant Code

Merchant account code following naming convention.

UO_AD_1234_Amsterdam

Store Code

Store number or code

1234

Description

A description of the store, can be the franchise name but NOT a generic value such as "Store"

Jane’s Burgers - Chicago

Legal name

Official name of registration of the legal entity.

Jane’s Burgers LLC

Registration address

Street + house number of registration of the legal entity.

1725 Slough Avenue

Registration postal code

Postal code of registration of the legal entity.

18540

Registration city

City or Town of registration of the legal entity.

Scranton

Owner first name

First name of the owner operator.

Jane

Owner last name

Last name of the owner operator.

Doe

Owner email

E-mail of the owner operator to send the invitation. Should be the same as the owner username email.

jane.doe@janeburgers.com

Street

Address (street + number) of the store

17 Charing Cross Rd

Postal code

The postal code of your store.

60007

City 

The city or town where your store is located

Chicago

Country Code

The ISO country code of where the store is located. (e.g. US, CA, NL)

CA

See list below for all ISO country codes.

Store state

The state where your store is located. This field is mandatory for AU, BR, CA, CZ, CN, MX & US. Use the two letter abbreviation.

For CA: ON, QC, YT, e.g.

For US: IL, IN, KY, e.g.

See list below for all state abbreviations.

Phone number

Phone number of the store, with the country code (e.g. +31612345678).

+1 408 306 3478

Username

Username for partner/franchisee used to log in to their customer area.

JaneDoe

Timezone code

Timezone code of the store location.

  • For Europe and Asia, the format is ‘Continent/Country Capital’

  • For US and Canada, the format is ‘Country/matching timezone code’. See a list below for all matching time zones.

Europe/Amsterdam or  US/Central or

Canada/Eastern

See a list below for all matching time zones.