Skip to main content

Data columns definition

Chiayee avatar
Written by Chiayee
Updated today

User Template

Settings Fields

Remarks

Skip

This field will be skip and not imported.

Custom Field

Addon profile data

First Name

First name profile data

Last Name

Last name profile data

Display Name

Display name profile data (Default will be First Name + Last Name)

Member Tier Id

Unique id of member tier

Phone

Primarily phone

Phone 2

Secondary phone

Phone Code

Phone country Iso, ex: SG for primary phone

Phone Code 2

Phone country Iso, ex: SG for secondary phone

Email

Primarily email

Email 2

Secondary email

Gender

Gender profile data M

External Member Id

Unique custom id profile data

Address

Address profile data

Points

Point balance profile data

Country

Country profile data

City

City profile data

Store Id

Unique sign up store id profile data

BirthDay

Day, Month and Year, birth date profile data

Birth Day

Day, birth date profile data

Birth Month

Month, birth date profile data

Birth Year

Year, birth date profile data

Company

Company profile data

Tags

User tag profile data.

Custom Created At

Member since profile data

Salutation

Salutation profile data

Member Tier Expiry Date

Expiry date profile data

Notification All

SMS & Email - transaction & promotion subscription status profile data

SMS News And Promotions

SMS - promotion subscription status profile data

Email News And Promotions

Email - promotion subscription status profile data

SMS Transactions

SMS - transaction subscription status profile data

Email Notifications

Email - transaction subscription status profile data

Nationality

Nationality profile data

Block

Block profile data

Postal Code

Postal code profile data

State

State profile data

Unit

Unit profile data

Initial Notify

Welcome activity message trigger status. 1

Anniversary

Day, Month and Year, anniversary date profile data

Transaction Template

Settings Fields

Remarks

Skip

This field will be skip and not imported.

Custom Field

Addon profile data (*applicable if you choose to create new user if no match)

Email

Primarily email (Identifier used to match with existing user)

Phone

Primarily phone (Identifier used to match with existing user)

Phone Code

Phone country Iso, ex: SG for primary phone

QR Code

Unique QR profile data (Identifier used to match with existing user)

External Member Id

Unique custom id profile data (Identifier used to match with existing user)

Read Only Transaction Date (UTC)

Secondary date for transactional data (UTC format)

Read Only Transaction Time (UTC) (append to Date)

Secondary time for transaction data (UTC format)

Type

Type of transaction entry. Adjusted

Sub Type

Sub type of transaction entry. Bonus

Tags

Tags for transactional data

Add Member Tags

User tag profile data

Display Name

Display name profile data (Default will be First Name + Last Name) (*applicable if you choose to create new user if no match)

First Name

First name profile data (*applicable if you choose to create new user if no match)

Last Name

Last name profile data (*applicable if you choose to create new user if no match)

Amount

Amount for transactional data, used for points calculation.

Points

Points for transactional data, no points calculation will be performed

Note

Note for transaction data

Transaction Number

Transaction number for transaction data

Notify

Received point activity message trigger status. 1

Custom Staff Id

Staff id for transaction data

Item Data

Item data for transaction data [ Item name

Store Id

Eber store Id for transaction data

Store Id Mapping

Custom store id <> Eber store id mapping for transaction data

Pax

Pax for transactional data

Create New Contact if No Match

Trigger status to create user for non matching identifier. 1

Created Date (UTC)

Primary date for transactional data (UTC format)

Created Time (UTC) (append to Date)

Primary time for transaction data (UTC format)

Created Date (Local Timezone)

Primary date for transactional data (Direct insertion with no GMT addition)

Created Time (Local Timezone) (append to Date)

Primary time for transaction data (Direct insertion with no GMT addition)

Read Only Transaction Date (Local Timezone)

Secondary date for transactional data (Direct insertion with no GMT addition)

Read Only Transaction Time (Local Timezone) (append to Date)

Secondary time for transaction data (Direct insertion with no GMT addition)

Member Created At (UTC)

Member since Date profile data (UTC format) (*applicable if you choose to create new user if no match)

Member Created Time (UTC) (append to Date)

Member since Time profile data (UTC format) (*applicable if you choose to create new user if no match)

Member Created At (Local Timezone)

Member since Date profile data (Direct insertion with no GMT addition) (*applicable if you choose to create new user if no match)

Member Created Time (Local Timezone) (append to Date)

Member since Time profile data (Direct insertion with no GMT addition) (*applicable if you choose to create new user if no match)

User ID

Unique Eber id (Identifier used to match with existing user)

Did this answer your question?