> ## 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.
</Tip>

### 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               |

<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}]
  ```
</Tip>

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](/docs/file-based-transfer/example-files).

**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](/docs/file-based-transfer/integration-log) under **Data migration**.