> ## 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, 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**           | **RewardVoucherValues** | **BonusPoints** | **Value** | **UniqueCode** | **Used** | **UsedBy** | U**sedStoreId** | **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**.