How can I fill in the Franchisee Unified Onboarding file correctly?

Column name

Explanation

Example

Merchant code

Merchant account code following naming convention.

JB_1234_Chicago

Owner user name

Username for partner/franchisee used to log in to their customer area. The email is a unique identifier. Please use the same email as the ‘owner email’.

jane.doe@janeburgers.com

Legal entity name

Official name of registration of the legal entity.

Jane’s Burgers LLC

Legal entity address

Street + house number of registration of the legal entity.

1725 Slough Avenue

Legal entity postal

Postal code of registration of the legal entity.

18540

Legal entity 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. 

jane.doe@janeburgers.com

Sales channel

The payment type that is processed. Separate them with a comma.

ECOM,POS,MOTOECOM,MOTOPOS

Store country

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 phone number(for POS or MOTOPOS)

Phone number of the store, with the country code (e.g. +31612345678). Make sure there is a ‘+’ in front of the country code.

+14083063478

Store description(for POS or MOTOPOS)

Store description can be easy if you have multiple stores, and to easily distinguish between them.

Chicago Store - Cafe

Shopper statement(for POS or MOTOPOS)

The name which will show up on the transaction details of the shopper’s bank statement. 

Jane’s Burgers - Chicago

Store address(for POS or MOTOPOS)

The street name and number of your store.

17 Charing Cross Rd

Store postal code(for POS or MOTOPOS)

The postal code of your store.

60007

Store city(for POS or MOTOPOS)

The city or town where your store is located

Chicago

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.

Store time zone(for POS or MOTOPOS)

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.

Location

Matching Time zone code

Alabama (AL), Arkansas (AR), Illinois (IL), Iowa (IA), Kansas (KS), Louisiana (LA), Minnesota (MN), Mississippi (MS), Missouri (MO), Nebraska (NE), North Dakota (ND), Oklahoma (OK), South Dakota (East) (SD), Tennessee (West) (TN), Texas (TX), Wisconsin (WI)

US/Central

Arizona (AZ), Colorado (CO), Idaho (ID), Montana (MT), New Mexico (NM), South Dakota (West) (SD), Utah (UT), Wyoming (WY)

US/Mountain

California (CA), Nevada (NV), Oregon (OR), Washington (WA)

US/Pacific

Connecticut (CT), Delaware (DE), District of Columbia (DC), Florida (FL), Georgia (GA), Indiana IN), Maine (ME), Maryland (MD), Massachusetts (MA), Michigan (MI), North Carolina (NC), New Hampshire (NH), New Jersey (NJ), New York (NY), Ohio (OH), Pennsylvania (PA), Rhode Island (RI), South Carolina (SC), Tennessee (East) (TN), Vermont (VT), Virginia (VA), West Virginia (WV)

US/Eastern

Alaska (AK)

US/Alaska

American Samoa (AS)

US/Samoa

Guam (GU)

Pacific/Guam

Hawaii (HI)

US/Aleutian

Puerto Rico (PR)

America/Puerto_Rico

British Columbia (BC), Yukon (YT)

Canada/Pacific

Alberta (AB), Northwest Territories (NT)

Canada/Mountain

New Brunswick (NB), Nova Scotia (NS), Prince Edward Island Labrador (PE)

Canada/Atlantic

Saskatchewan (SK), Manitoba (MB_

Canada/Central

Québec (QC), Ontario (ON), Nunavut (NU)

Canada/Eastern

Newfoundland (NL)

Canada/Newfoundland

Arab Emirates (AE)

Asia/Dubai

Austria (AT)

Europe/Vienna

Switzerland (CH)

Europe/Zurich

Germany (DE)

Europe/Berlin

Denmark (DK)

Europe/Copenhagen

Estonia (EE)

Europe/Tallinn

Finland (FI)

Europe/Helsinki

Great Britain (GB)

Europe/London

Croatia (HR)

Europe/Zagreb

Italy (IT)

Europe/Rome

Lituania (LT)

Europe/Vaduz

Myanmar (MM)

Asia/Kuala_Lumpur

Norway (NO)

Europe/Oslo

Netherlands (NL)

Europe/Amsterdam

Poland (PL)

Europe/Warsaw

Portugal (PT)

Europe/Lisbon

Romania (RO)

Europe/Bucharest

Sweden (SE)

Europe/Stockholm

Belgium(BE)

Europe/Belgium