Import reward vouchers
Reward vouchers can be imported by file (CSV, UTF-8).
Note
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 |
*BonusPoints | Amount of reward points converted |
*Value | Value of the reward voucher |
*UniqueCode | The voucher's unique code, preferrably another series than what Engage is using to prevent duplicates. If left blank, Engage will add a number from its own series |
*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 | 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 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.