Manually Reward Customers via CSV Upload

Connor Johanning Updated by Connor Johanning

Overview

Use the Manual Reward Upload tool to grant loyalty points to customers for activities that occur outside of Friendbuy’s automatic tracking - for example, leaving a product review on a third-party platform, visiting a physical store, completing an offline engagement, or issuing a one-time points push to accelerate a product launch. This feature allows Friendbuy Admins to reward any customer action that isn’t automatically tracked in another platform by uploading a structured CSV file directly within the earning event settings.

This feature ensures every meaningful customer interaction can be recognized, even when it occurs outside of Friendbuy's ecosystem.

When to Use Manual Reward Upload

Use this upload flow when:

  • You need to award points for a custom earning event not automatically tracked by Friendbuy.
  • You want to process a batch of manual rewards at once.
  • You need to associate rewards with specific customers using their Customer ID or Email Address.
Note: Only Admin users can upload manual rewards.
Manual Reward notifications Friendbuy does not send notifications to customers when rewards are granted manually.
Reward removal limitations Manual rewards cannot be removed or undone because retroactive reward reversal is not supported.

Requirements

Your CSV must include column headers. Accepted columns:

Column

Required?

Description

Email Address

Required

Customer email (used as secondary identifier)

Customer ID

Required

Primary loyalty identifier for the customer

De-duplication ID

Optional

Used to prevent issuing a reward twice for the same row

Date Completed

Optional

ISO date representing when the customer completed the activity

Important: Each upload applies to one earning event only.

How to Reward Customers via CSV Upload

Step 1: Navigate to the Earning Event

  1. Go to Loyalty → Earning Events in your Friendbuy dashboard.
  2. Select the Custom Earning Event or + Add Earning Event for the event you want to award rewards for.
Note: If creating a new Custom Earning Event, you must Save & Activate the event before the option to upload a CSV is available.
  1. Scroll down to the Manual Reward Upload section.

Step 2: Download the Example CSV (Optional)

Click Download example CSV to get a template pre-filled with:

  • Email Address
  • Customer ID
  • De-duplication ID (optional)
  • Date Completed (optional)

Step 3: Prepare Your CSV

Make sure each row includes:

  • A valid Customer ID
  • A valid Email Address
Note: Rows missing required fields will fail during processing.

Step 4: Upload the CSV

  1. Drag and drop your CSV into the upload area or click Select file.
  1. After upload, Friendbuy validates & processes the file structure.

Step 5: Review Processing Results

Once the file is processed, Friendbuy will send an email summarizing:

  • Total rows processed
  • Successful reward applications
  • Failed rows (with up to 10 example errors)

FAQ

Q: Can I upload rewards for multiple earning events at once?

A: No. Each upload applies to one earning event.

Q: Are there limits on upload size?

A: Not currently. Extremely large files may take longer to process.

How did we do?

Understanding the Loyalty Analytics

Rolling Points Expiration Reminder Emails

Contact