Skip to main content

Voyado Engage

Import reward vouchers

Reward vouchers can be imported via file (csv UTF-8).

The file

Column name

Description

MemberKey

Key (hard coded to attribute memberNumber)

PromotionName

Name of the campaign that the voucher might be part of.

CreatedOn

Creation date

ExpiryDate

Expiration date

ValidFrom

Valid from date, can differ from creation date.

BonusPoints

Amount of reward points that was converted.

Value

Value of the reward voucher. 

UniqueCode

The voucher's unique code, preferrably another series than what Voyado is using to prevent duplicates. If left blank Voyado will add a number from its own series.

Used

Binary indicator if the voucher has been used.

UsedBy

Optional field to comment who used the voucher.

UsedStoreId

Optional field to show which store received that voucher.

UsedByInvoiceExternalId

Optional field to specify what invoice the voucher was used on. 

Example

MemberKey

PromotionName

CreatedOn

ExpiryDate

ValidFrom

BonusPoints

201

Q1 bonus

2018-01-19 10:36:57.000

2018-07-19 10:36:57.000

2018-01-19 10:36:57.000

1000

16

Q4 bonus

2017-11-19 10:36:57.000

2018-05-19 10:36:57.000

2017-11-19 10:36:57.000

1000

Value

UniqueCode

Used

UsedBy

UsedStoreId

UsedByInvoiceExternalId

100

A0001

1

679

INVOICE-1

100

A0002

0

567

INVOICE-2

The file should then be placed on the clients ftp under a folder named BonusCheckImport.

File example

You can see an example of the correct format by downloading this example CSV file.

Here is the example of the format in Excel.

Starting the import

There is no scheduled job that can be executed in order to process the file. It is instead triggered manually by your Voyado team.

The result, including validation check, will be shown in the integration log under Data migration.