Skip to main content

Transferring Customers with Reward Balances

Learn how to migrate customers from other loyalty systems with balances intact. Step-by-step guide to importing customers, preserving stamps/points/rewards, and ensuring seamless transitions without reward loss.

Michael Francis avatar
Written by Michael Francis
Updated this week

Transferring Customers with Reward Balances

Overview

When migrating from another loyalty system, you can preserve your customers' existing rewards by importing them with their balances intact. This ensures a smooth transition with no disruption to customer loyalty—customers keep everything they've earned and can continue where they left off.

What you can transfer:

  • Stamp card balances (stamps earned)

  • Gift card balances (monetary value)

  • Cashback card balances (bonus points)

  • Reward card balances (points earned)

  • Discount card progress (spending totals)

  • Customer information and contact details

Benefits:

  • Zero reward loss for customers

  • Maintains customer trust

  • Seamless system transition

  • Immediate card installation with existing balances

  • No manual balance adjustments needed


Before you begin

What you'll need

  1. Customer data from your previous system:

    • Customer names

    • Contact information (phone/email)

    • Current reward balances

    • Any custom fields

  2. Import template downloaded:

    • Available in the Customers section

    • CSV format

    • Pre-formatted with required columns

  3. Card template selected:

    • Choose which loyalty card to issue during import

    • Configure card settings before importing

General import guidelines

File preparation:

  • Use the provided CSV template (don't modify column structure)

  • Leave blank fields empty (don't use "N/A" or placeholders)

  • Maximum 20,000 customers per file

  • Save as CSV format (not Excel .xlsx)

Balance column usage:

  • Enter rewards from previous system

  • Format depends on card type (see specific instructions below)

  • Numbers only (no currency symbols)

  • Leave blank if starting from zero


Importing by card type

Stamp cards

Stamp cards reward customers with stamps for purchases or visits. Transfer existing stamp counts so customers don't start from zero.

What to enter in Balance column: Number of stamps the customer has already earned.

Example:

  • Customer has 8 out of 10 stamps in old system

  • Enter: 8 in Balance column

  • Result: Customer sees 8 stamps immediately upon card installation

Step-by-step process:

  1. Download import template

    • Navigate to Customers section

    • Click Import

    • Download CSV template

  2. Select card template

    • Choose your Stamp Card template

    • This card will be issued to all imported customers

  3. Fill in customer details

    • Name (first and last)

    • Contact information (phone and/or email)

    • Date of birth (optional)

    • Balance: Number of stamps (e.g., 2, 5, 8)

  4. Upload file

    • Return to Import section

    • Select your completed CSV file

    • Choose the stamp card template

    • Click Import

  5. Verify import

    • Check customer profiles in Customer Base

    • Verify stamp balance appears correctly

    • Customer will see stamps immediately on card installation

Important: Customers will see their transferred stamps right away when they install the card—no waiting or manual adjustments needed.


Gift cards

Gift cards have a monetary or points balance that customers can spend on services. Transfer existing balances so customers can use their remaining value immediately.

What to enter in Balance column: Monetary value or points remaining on the gift card.

Example:

  • Customer has $15 remaining on old gift card

  • Enter: 15 in Balance column

  • Result: Customer sees $15 available balance upon card installation

Step-by-step process:

  1. Download import template

    • Navigate to Customers section

    • Click Import

    • Download CSV template

  2. Select card template

    • Choose your Gift Card template

    • Configure card settings if not already done

  3. Fill in customer details

    • Name (first and last)

    • Contact information (phone and/or email)

    • Date of birth (optional)

    • Balance: Amount customer can spend (e.g., 15, 50, 100)

  4. Upload file

    • Return to Import section

    • Select your completed CSV file

    • Choose the gift card template

    • Click Import

  5. Verify import

    • Check customer profiles

    • Verify gift card balance is correct

    • Balance represents spendable amount for services/products

Customer experience: When customers install the card, they immediately see their available balance and can use it for purchases at your business.


Cashback cards

Cashback cards award bonus points that customers can use for purchases. Transfer existing points so customers retain their accumulated cashback.

What to enter in Balance column: Number of cashback points (bonus points) the customer has earned.

Example:

  • Customer has 150 cashback points in old system

  • Enter: 150 in Balance column

  • Result: Customer sees 150 points available upon card installation

Step-by-step process:

  1. Download import template

    • Navigate to Customers section

    • Click Import

    • Download CSV template

  2. Select card template

    • Choose your Cashback Card template

    • Ensure tier structure is configured

  3. Fill in customer details

    • Name (first and last)

    • Contact information (phone and/or email)

    • Date of birth (optional)

    • Balance: Number of bonus points (e.g., 15, 150, 500)

  4. Upload file

    • Return to Import section

    • Select your completed CSV file

    • Choose the cashback card template

    • Click Import

  5. Verify import

    • Check customer profiles

    • Verify cashback point balance

    • Points represent bonus funds for purchases

Customer experience: Customers can immediately use their cashback points when they install the card and make purchases at your business.


Reward cards

Reward cards accumulate points that customers redeem for various rewards. Transfer existing point balances to preserve customer progress.

What to enter in Balance column: Number of reward points the customer has accumulated.

Example:

  • Customer has 1,250 points in old system

  • Enter: 1250 in Balance column

  • Result: Customer sees 1,250 points and can redeem available rewards

Step-by-step process:

  1. Download import template

    • Navigate to Customers section

    • Click Import

    • Download CSV template

  2. Select card template

    • Choose your Reward Card template

    • Ensure reward levels are configured

  3. Fill in customer details

    • Name (first and last)

    • Contact information (phone and/or email)

    • Date of birth (optional)

    • Balance: Number of points (e.g., 500, 1250, 3000)

  4. Upload file

    • Return to Import section

    • Select your completed CSV file

    • Choose the reward card template

    • Click Import

  5. Verify import

    • Check customer profiles

    • Verify point balance is correct

    • Available rewards display based on point total

Customer experience: Customers can immediately see which rewards they can redeem based on their transferred point balance.


Discount cards

Discount cards provide progressive discounts based on total spending. Transfer spending totals so customers maintain their tier status.

What to enter in Balance column: Total qualifying spend (NOT points or discount percentage)—the cumulative amount the customer has spent that determines their tier.

Example:

  • Customer has spent $3,500 total in old system

  • Silver tier starts at $3,000 (10% discount)

  • Enter: 3500 in Balance column

  • Result: Customer is automatically placed in Silver tier with 10% discount

How tier assignment works: The system uses the spend amount to assign the appropriate discount tier based on your configured thresholds:

  • If your tiers are: Bronze ($0-$999), Silver ($1,000-$2,999), Gold ($3,000+)

  • Customer with $3,500 spend → automatically assigned to Gold tier

Step-by-step process:

  1. Download import template

    • Navigate to Customers section

    • Click Import

    • Download CSV template

  2. Select card template

    • Choose your Discount Card template

    • Verify tier structure is configured correctly

  3. Fill in customer details

    • Name (first and last)

    • Contact information (phone and/or email)

    • Date of birth (optional)

    • Balance: Total spend amount (e.g., 1500, 3500, 7000)

  4. Upload file

    • Return to Import section

    • Select your completed CSV file

    • Choose the discount card template

    • Click Import

  5. Verify import

    • Check customer profiles

    • Verify customer is assigned to correct tier

    • Discount percentage matches their spending level

Important: Enter the total spend amount, not the discount percentage. The system automatically assigns the correct tier and discount based on your configured thresholds.

Placing customers on specific tiers: If you want to place a customer directly on a specific tier:

  • Find the minimum spend for that tier (e.g., Gold tier starts at $3,000)

  • Enter that amount or higher in Balance column

  • Customer will be assigned to that tier automatically


Membership cards

Membership cards provide tiered access and benefits. Importing with balances has specific considerations.

Balance recommendations: We recommend leaving the Balance column blank for membership cards.

Why?

  • Customers are automatically placed on the first tier upon import

  • The balance on the first tier becomes the customer's starting balance

  • This cannot be overridden by entering a different value in the CSV

What happens during import:

  • Customer receives membership card

  • Automatically assigned to first/lowest tier

  • Inherits that tier's limits and benefits

  • Can be manually upgraded after import if needed

Step-by-step process:

  1. Download import template

    • Navigate to Customers section

    • Click Import

    • Download CSV template

  2. Select card template

    • Choose your Membership Card template

    • Verify tier structure is configured

  3. Fill in customer details

    • Name (first and last)

    • Contact information (phone and/or email)

    • Date of birth (optional)

    • Balance: Leave blank

  4. Upload file

    • Return to Import section

    • Select your completed CSV file

    • Choose the membership card template

    • Click Import

  5. Adjust tiers after import (if needed)

For Membership v1 (free memberships): No tiers or limits exist, so Balance column is not applicable.


Coupon cards

Coupon cards are designed for customer acquisition, not for managing existing customers with balances.

Recommended approach: Do not import existing customers for coupon cards.

Why?

  • Coupons are typically distributed to attract new customers

  • The main purpose is new customer acquisition, not reward preservation

  • Coupon value is predetermined by card settings, not individual balances

  • Importing existing customers doesn't add value

If you still want to import:

The customer's coupon value is predetermined by the "Reward for first visit" field in your card settings and cannot be altered by entering a different amount in the CSV Balance column.

Process:

  1. Download import template

  2. Fill in customer details

  3. Leave Balance column blank

  4. Upload file and select coupon card template

  5. Click Import

Better alternatives for existing customers:

  • Issue stamp cards, reward cards, or membership cards instead

  • Use coupons for new customer acquisition campaigns

  • Save coupon cards for promotional distribution


Multipass cards

Multipass cards allow customers to pre-purchase multiple visits. Balance importing is not currently supported.

Current limitation: You cannot import multipass cards with existing visit balances.

How to add visits: Visits can only be added through:

  • Manual addition: In the customer's profile

  • Scanner: Recording visits when card is scanned

Workaround for migration:

  1. Import customers without balance

  2. Manually add visit balances in each customer profile

  3. Or: Record visits through scanner as they use services

For large-scale migrations: This manual process may be time-consuming for many customers. Consider:

  • Importing customers first

  • Adding visits to high-value customers manually

  • Recording visits naturally as customers use services

  • Offering promotional visits to compensate for migration


After importing

Verification checklist

Check customer profiles:

  • [ ] All customers appear in Customer Base

  • [ ] Contact information is correct

  • [ ] Balances transferred correctly

  • [ ] Card templates assigned properly

  • [ ] Tier assignments accurate (discount/membership cards)

Test with a sample customer:

  • [ ] Send installation link

  • [ ] Have someone install the card

  • [ ] Verify balance appears on card

  • [ ] Confirm rewards/tier show correctly

Communication with customers

Send installation instructions:

  1. Use bulk SMS or email from the system

  2. Include personalized installation link

  3. Explain the new loyalty system

  4. Highlight that their rewards were preserved

  5. Provide support contact for questions

Sample message template:

Great news! We've upgraded our loyalty program. Your rewards have been preserved - you still have [X stamps/points/balance]. Install your new card here: [link]. Questions? Contact us at [support info].

Next steps

For customers:

  1. Send installation links via SMS or email

  2. Provide setup instructions

  3. Confirm balances transferred correctly

  4. Answer questions about new system

For your team:

  1. Export customer list as backup

  2. Train staff on new system

  3. Monitor for import issues

  4. Adjust balances if needed

  5. Update marketing materials


Troubleshooting

Balance didn't transfer correctly

Issue: Customer balance shows zero or incorrect amount after import.

Solutions:

  • Verify Balance column was filled correctly in CSV

  • Check number format (no currency symbols, letters, or special characters)

  • Ensure card type matches the balance type (points for points cards, etc.)

  • Manually adjust balance in customer profile

  • Re-import if many customers affected

Customer assigned to wrong tier

Issue: Discount or membership customer in incorrect tier.

For discount cards:

  • Verify spend amount in Balance column

  • Check tier thresholds in card configuration

  • Manually adjust tier in customer profile

  • Ensure spend amount meets tier minimum

For membership cards:

  • All imports start at first tier by default

  • Manually upgrade to appropriate tier

  • Use bulk actions for multiple customers

Import file rejected

Issue: System won't accept import file.

Solutions:

  • Verify file is CSV format (not .xlsx)

  • Check file doesn't exceed 20,000 customers

  • Ensure all required columns present

  • Remove any added columns

  • Verify no special characters in data

  • Check file isn't corrupted

Customers can't see their balance

Issue: Customer installed card but balance doesn't appear.

Solutions:

  • Verify balance imported correctly in their profile

  • Check customer installed correct card

  • Have customer reinstall card using fresh link

  • Verify card template selected during import

  • Check card isn't expired


Best practices

Before importing

Plan your migration:

  • Test import with 5-10 customers first

  • Verify all card configurations before importing

  • Clean your data (remove duplicates, standardize formats)

  • Document current balances from old system

  • Prepare customer communication

Data preparation:

  • Export clean data from old system

  • Match balance formats to new system requirements

  • Standardize phone and email formats

  • Remove invalid or inactive customers

  • Back up original data

During importing

Import in batches:

  • Start with small test batch (10-20 customers)

  • Verify results before proceeding

  • Import in manageable chunks (1,000-5,000 at a time)

  • Monitor for errors after each batch

  • Take breaks between large batches

Quality control:

  • Check sample profiles after each batch

  • Verify balance calculations

  • Test card installation with sample customers

  • Document any issues immediately

  • Adjust remaining batches based on learnings

After importing

Customer support:

  • Prepare FAQ for customers

  • Train support team on new system

  • Monitor for customer questions

  • Have troubleshooting process ready

  • Offer migration assistance

System optimization:

  • Export updated customer list

  • Verify all data integrity

  • Set up regular backups

  • Monitor system performance

  • Gather customer feedback


Frequently asked questions

Will customers lose their rewards during migration? No, when you use the Balance column correctly, all rewards transfer to the new system. Customers see their full balance upon card installation.

Can I import balances after customers are already in the system? Balances should be imported during initial customer import. To add balances later, manually adjust each customer profile.

What if customers had rewards in multiple programs? Import separately for each card type. Customers can have multiple cards with different balances.

Do I need to notify customers before migrating? Yes, inform customers about the system change, explain they'll keep their rewards, and provide installation instructions.

Can I test the import without affecting live data? Yes, import a small test batch (5-10 customers) first, verify results, then proceed with full import.

What happens if I enter the wrong balance? You can manually correct balances in each customer's profile after import, or re-import the customer with correct data.

Will this work for customers from any loyalty system? Yes, as long as you can export customer data and balances from your old system, you can import them here with rewards preserved.

How long does the import process take? Small batches (under 1,000) complete in minutes. Larger imports may take 15-30 minutes. Process time varies by file size.

Can customers use their rewards immediately after installation? Yes, balances are available as soon as the card is installed. Customers can redeem rewards or use balances right away.

What if some customers don't want to switch to the new system? Import everyone first. Those who don't install cards simply remain as customer records. You can delete inactive profiles later if needed.

Did this answer your question?