CSV Upload

CSV upload lets you reward many customers at once by uploading a file from your dashboard. No development work is required. Whether a Seller supports CSV upload is shown in your active partnership.

1. Where to Upload

1. Go to Integration in your dashboard.
2. Select the partnership you want to reward from.
3. Download the CSV template.

2. File Format

One row per customer, up to 1,000 rows per file:

1. Email – required
2. Amount – required, whole number of loyalty currency units
3. Loyalty account number – optional
4. Booking reference – optional, your own reference for reconciliation
5. Meta information – optional free text
6. Credit date – optional, format YYYY-MM-DD; schedules the reward for a future date

3. How Rows Are Processed

• Valid account number → the reward is credited (or scheduled if a credit date is set).
• No account number → the customer receives an email asking them to claim the reward by entering their account number.
• Invalid account number → the same claim email is sent automatically.

Individual customers are informed by email; you will not receive a per-row summary.

4. Before Uploading

• Make sure your balance covers the total amount in the file.
• Use UTF-8 encoding and keep the column order of the template.
• Do not upload the same file twice; each row creates a new reward.

If your file is rejected, see My CSV Upload Was Rejected.

Need help? Submit a support ticket or email pei@qiibee.com.