Importing reward vouchers

Reward vouchers can be imported by file (CSV, UTF-8).

Each import file should not contain more than 20,000 rows.

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
*RewardVoucherValues	Defines how a check amount is converted into the currencies that the customer currently uses
*BonusPoints	Amount of reward points converted
*Value	Value of the reward voucher
*UniqueCode	Voucher’s unique code, preferably using another series than what Engage is using, to prevent duplicates
*Used	If the voucher has already been used (1 or 0)
UsedBy	Field to say who used the voucher (optional)
UsedStoreId	Field to show which store received the voucher (optional)
UsedByInvoiceExternalId	Field to specify which invoice the voucher was used on (optional)

Mandatory fields are marked with *.

Example

MemberKey	PromotionName	CreatedOn	ExpiryDate	ValidFrom	RewardVoucherValues	BonusPoints	Value	UniqueCode	Used	UsedBy	UsedStoreId	UsedByInvoiceExternalId
201	Q1 bonus	2018-01-19 10:36:57.000	2018-07-19 10:36:57.000	2018-01-19 10:36:57.000	SEE NOTE	1000	100	A0001	1		679	INVOICE-1
16	Q4 bonus	2017-11-19 10:36:57.000	2018-05-19 10:36:57.000	2017-11-19 10:36:57.000	SEE NOTE	1000	100	A0002	0		567	INVOICE-2

The values for RewardVoucherValues will be something like:

[{"Currency":"EUR","Amount":5.00},
{"Currency":"NOK","Amount":50.00},
{"Currency":"SEK","Amount":50.00}]

The file should then be placed on your client FTP inside a folder named “BonusCheckImport”. File example You can download examples as CSV and Excel on the example files page. Starting the import There is no scheduled job to process the file. It must instead be triggered manually by your Voyado team. The result, including the validation check, will be shown in the integration log under Data migration.

Importing historical contacts Importing historical transactions

⌘I

Importing historical data

Data import by file

Data export by file

Importing reward vouchers

The file

Example

​The file

​Example

The file

Example