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 download examples as CSV and Excel on the example files page.
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.