---
title: "Import data into referral lists"
url: "https://docs.adyen.com/development-resources/migrating-payment-data/import-data-into-referral-lists"
source_url: "https://docs.adyen.com/development-resources/migrating-payment-data/import-data-into-referral-lists.md"
canonical: "https://docs.adyen.com/development-resources/migrating-payment-data/import-data-into-referral-lists"
last_modified: "2020-05-01T11:32:00+02:00"
language: "en"
---

# Import data into referral lists

[View source](/development-resources/migrating-payment-data/import-data-into-referral-lists.md)

You can import referral data into the Adyen payments platform to be placed on several [referral lists](/risk-management/configure-standard-risk-rules/referral-rules) used for fraud checks.

This bulk import of referral data is different from uploading items to a block or trust list using a CSV file in the Customer Area.

The CSV file that contains the referral data for the bulk import must be encrypted, and uploading the file requires our [Support Team](https://ca-test.adyen.com/ca/ca/contactUs/support.shtml?form=other).

## Input file format

1. Create a file in CSV (Comma Separated Values) format as per RFC 4180. These are the requirements:

   * Prefix each line with a supported fixed value field, either the payment method or the type of referral list. See the different types of referrals on this page for the details.
   * Each line contains the fields for a single referral item. In other words: each referral is on a separate line.
   * Multi-line fields are not allowed. You can use a variable number of fields per line.
   * A header is not allowed.
   * The maximum number of lines per file is 100.000 (if file size permits).

2. Save the file in [UTF-8](https://en.wikipedia.org/wiki/UTF-8) format (to support non-western characters).

3. Encrypt the file using the PGP public key provided to you by either our [Support Team](https://ca-test.adyen.com/ca/ca/contactUs/support.shtml?form=other), or your Adyen contact.

   For more information, see our [PGP encryption documentation](/development-resources/pgp-encryption).

4. Send the file to Adyen.

## Card

For card referrals the following columns are required:

| Field                   | Required                                                                                    | Description                                                                          |
| ----------------------- | ------------------------------------------------------------------------------------------- | ------------------------------------------------------------------------------------ |
| **Fixed value: `card`** | ![-white\_check\_mark-](/user/data/smileys/emoji/white_check_mark.png "-white_check_mark-") | Record type identifier.                                                              |
| `merchantAccountCode`   | ![-white\_check\_mark-](/user/data/smileys/emoji/white_check_mark.png "-white_check_mark-") | The merchant account name.                                                           |
| `cardNumber`            | ![-white\_check\_mark-](/user/data/smileys/emoji/white_check_mark.png "-white_check_mark-") | The card number.                                                                     |
| `description`           | ![-white\_check\_mark-](/user/data/smileys/emoji/white_check_mark.png "-white_check_mark-") | A description of the item, for example a transaction ID of the original transaction. |
| `flag`                  | ![-white\_check\_mark-](/user/data/smileys/emoji/white_check_mark.png "-white_check_mark-") | You can perform the following actions:- trust
- block
- delete                       |

## SEPA

For SEPA referral data the following columns are required:

| Field                   | Required                                                                                    | Description                                                                          |
| ----------------------- | ------------------------------------------------------------------------------------------- | ------------------------------------------------------------------------------------ |
| **Fixed value:** `sepa` | ![-white\_check\_mark-](/user/data/smileys/emoji/white_check_mark.png "-white_check_mark-") | Record type identifier.                                                              |
| `iban`                  | ![-white\_check\_mark-](/user/data/smileys/emoji/white_check_mark.png "-white_check_mark-") | IBAN of the bank account.                                                            |
| `merchantAccountCode`   | ![-white\_check\_mark-](/user/data/smileys/emoji/white_check_mark.png "-white_check_mark-") | The merchant account name.                                                           |
| `description`           | ![-white\_check\_mark-](/user/data/smileys/emoji/white_check_mark.png "-white_check_mark-") | A description of the item, for example a transaction ID of the original transaction. |
| `flag`                  | ![-white\_check\_mark-](/user/data/smileys/emoji/white_check_mark.png "-white_check_mark-") | You can perform the following actions:- trust
- block
- delete                       |

## Shopper name

For shopper name the following columns are required:

| Field                          | Required                                                                                    | Description                                                                          |
| ------------------------------ | ------------------------------------------------------------------------------------------- | ------------------------------------------------------------------------------------ |
| **Fixed value: `shopperName`** | ![-white\_check\_mark-](/user/data/smileys/emoji/white_check_mark.png "-white_check_mark-") | Record type identifier.                                                              |
| `merchantAccountCode`          | ![-white\_check\_mark-](/user/data/smileys/emoji/white_check_mark.png "-white_check_mark-") | The merchant account name.                                                           |
| `shopperName`                  | ![-white\_check\_mark-](/user/data/smileys/emoji/white_check_mark.png "-white_check_mark-") | Name of the shopper.                                                                 |
| `description`                  | ![-white\_check\_mark-](/user/data/smileys/emoji/white_check_mark.png "-white_check_mark-") | A description of the item, for example a transaction ID of the original transaction. |
| `flag`                         | ![-white\_check\_mark-](/user/data/smileys/emoji/white_check_mark.png "-white_check_mark-") | You can perform the following actions:- trust
- block
- delete                       |

## Shopper email

For shopper email referrals the following columns are required:

| Field                           | Required                                                                                    | Description                                                                          |
| ------------------------------- | ------------------------------------------------------------------------------------------- | ------------------------------------------------------------------------------------ |
| **Fixed value: `shopperEmail`** | ![-white\_check\_mark-](/user/data/smileys/emoji/white_check_mark.png "-white_check_mark-") | Record type identifier.                                                              |
| `merchantAccountCode`           | ![-white\_check\_mark-](/user/data/smileys/emoji/white_check_mark.png "-white_check_mark-") | The merchant account name.                                                           |
| `shopperEmail`                  | ![-white\_check\_mark-](/user/data/smileys/emoji/white_check_mark.png "-white_check_mark-") | The shopper's email address.                                                         |
| `description`                   | ![-white\_check\_mark-](/user/data/smileys/emoji/white_check_mark.png "-white_check_mark-") | A description of the item, for example a transaction ID of the original transaction. |
| `flag`                          | ![-white\_check\_mark-](/user/data/smileys/emoji/white_check_mark.png "-white_check_mark-") | You can perform the following actions:- trust
- block
- delete                       |

## Shopper IP

For shopper IP referrals the following columns are required:

| Field                        | Required                                                                                    | Description                                                                          |
| ---------------------------- | ------------------------------------------------------------------------------------------- | ------------------------------------------------------------------------------------ |
| **Fixed value: `shopperIp`** | ![-white\_check\_mark-](/user/data/smileys/emoji/white_check_mark.png "-white_check_mark-") | Record type identifier.                                                              |
| `merchantAccountCode`        | ![-white\_check\_mark-](/user/data/smileys/emoji/white_check_mark.png "-white_check_mark-") | The merchant account name.                                                           |
| `shopperIP`                  | ![-white\_check\_mark-](/user/data/smileys/emoji/white_check_mark.png "-white_check_mark-") | The IP address the shopper used to carry out the transaction.                        |
| `description`                | ![-white\_check\_mark-](/user/data/smileys/emoji/white_check_mark.png "-white_check_mark-") | A description of the item, for example a transaction ID of the original transaction. |
| `flag`                       | ![-white\_check\_mark-](/user/data/smileys/emoji/white_check_mark.png "-white_check_mark-") | You can perform the following actions:- trust
- block
- delete                       |

## Shopper reference

For shopper reference referrals the following columns are required:

| Field                               | Required                                                                                    | Description                                                                          |
| ----------------------------------- | ------------------------------------------------------------------------------------------- | ------------------------------------------------------------------------------------ |
| **Fixed value: `shopperReference`** | ![-white\_check\_mark-](/user/data/smileys/emoji/white_check_mark.png "-white_check_mark-") | Record type identifier.                                                              |
| `merchantAccountCode`               | ![-white\_check\_mark-](/user/data/smileys/emoji/white_check_mark.png "-white_check_mark-") | The merchant account name.                                                           |
| `shopperReference`                  | ![-white\_check\_mark-](/user/data/smileys/emoji/white_check_mark.png "-white_check_mark-") | A shopper's reference, which is the unique identifier for a shopper.                 |
| `description`                       | ![-white\_check\_mark-](/user/data/smileys/emoji/white_check_mark.png "-white_check_mark-") | A description of the item, for example a transaction ID of the original transaction. |
| `flag`                              | ![-white\_check\_mark-](/user/data/smileys/emoji/white_check_mark.png "-white_check_mark-") | You can perform the following actions:- trust
- block
- delete                       |

## Shopper address

For shopper address referrals the following columns are required:

| Field                             | Required                                                                                     | Description                                                                          |
| --------------------------------- | -------------------------------------------------------------------------------------------- | ------------------------------------------------------------------------------------ |
| **Fixed value: `shopperAddress`** | ![-white\_check\_mark-](/user/data/smileys/emoji/white_check_mark.png "-white_check_mark-")  | Record type identifier.                                                              |
| `merchantAccountCode`             | ![-white\_check\_mark-](/user/data/smileys/emoji/white_check_mark.png "-white_check_mark-")  | The merchant account name.                                                           |
| `street`                          | ![-white\_check\_mark-](/user/data/smileys/emoji/white_check_mark.png "-white_check_mark-")  | Street name.                                                                         |
| `houseNumberOrName`               | ![-white\_check\_mark-](/user/data/smileys/emoji/white_check_mark.png "-white_check_mark-")  | House number or name.                                                                |
| `city`                            | ![-white\_check\_mark-](/user/data/smileys/emoji/white_check_mark.png "-white_check_mark-")  | Name of the city                                                                     |
| `postalCode`                      | ![-white\_check\_mark-](/user/data/smileys/emoji/white_check_mark.png "-white_check_mark-")  | Postal code.                                                                         |
| `stateOrProvince`                 | ![-white\_check\_mark-](/user/data/smileys/emoji/white_check_mark.png "-white_check_mark-")  | State or province name.                                                              |
| `countryCode`                     | ![-white\_check\_mark-](/user/data/smileys/emoji/white_check_mark.png "-white_check_mark-")  | Country code                                                                         |
| `description`                     | ![-white\_check\_mark-](/user/data/smileys/emoji/white_check_mark.png "-white_check_mark-")  | A description of the item, for example a transaction ID of the original transaction. |
| `flag`                            | ![-white\_check\_mark-](/user/data/smileys/emoji/white_check_mark.png "-white_check_mark-")  | You can perform the following actions:- trust
- block
- delete                       |

## Shopper phone number

For shopper phone number referrals the following columns are required:

| Field                                 | Required                                                                                    | Description                                                                          |
| ------------------------------------- | ------------------------------------------------------------------------------------------- | ------------------------------------------------------------------------------------ |
| **Fixed value: `shopperPhoneNumber`** | ![-white\_check\_mark-](/user/data/smileys/emoji/white_check_mark.png "-white_check_mark-") | Record type identifier.                                                              |
| `merchantAccountCode`                 | ![-white\_check\_mark-](/user/data/smileys/emoji/white_check_mark.png "-white_check_mark-") | The merchant account name.                                                           |
| `phoneNumber`                         | ![-white\_check\_mark-](/user/data/smileys/emoji/white_check_mark.png "-white_check_mark-") | The phone number                                                                     |
| `description`                         | ![-white\_check\_mark-](/user/data/smileys/emoji/white_check_mark.png "-white_check_mark-") | A description of the item, for example a transaction ID of the original transaction. |
| `flag`                                | ![-white\_check\_mark-](/user/data/smileys/emoji/white_check_mark.png "-white_check_mark-") | You can perform the following actions:- trust
- block
- delete                       |

## Example file

The following is an example file with several lines of referral data:

```text
card,YourMerchantOrCompanyAccount,4111111111111111,"Example description",block
shopperName,YourMerchantOrCompanyAccount,"S. Hopper","Example description",trust
shopperEmail,YourMerchantOrCompanyAccount,s.hopper@example.com,"Example description",trust
shopperIp,YourMerchantOrCompanyAccount,8.8.8.8,"Example description",block
shopperReference,YourMerchantOrCompanyAccount,YourMerchantReference,"Example description",delete
shopperAddress,YourMerchantOrCompanyAccount,StreetName,58,Amsterdam,2116 E,AMS,NL,"Example description",trust
shopperPhoneNumber,YourMerchantOrCompanyAccount,0123456789,"Example description",block
```
