> ## Documentation Index
> Fetch the complete documentation index at: https://developer.voyado.com/llms.txt
> Use this file to discover all available pages before exploring further.

# Importing reward vouchers

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

> [!TIP]
>
> 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 Customer Engagement 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 |

> [!TIP]
>
> The values for `RewardVoucherValues` will be something like:
>
> ```json theme={null}
> [{"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](https://developer.voyado.com/docs/file-based-transfer/example-files.md).

**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](https://developer.voyado.com/docs/file-based-transfer/integration-log.md) under **Data migration**.


This documentation is built and hosted on [Mintlify](https://mintlify.com), a developer documentation platform.