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, 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) |
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}]
