LogoLogo
HomepageCase studiesBook a demo
User Guide
User Guide
  • Welcome to Open Loyalty!
  • What's New
    • 2024
    • 2023
    • 2022
  • What's Next
  • Technical Guide
  • Main Features
    • Global Management
      • Analytics
      • Settings
      • Config Duplication
      • Usage
    • Dashboard
      • General Overview
      • Units Wallet Overview
      • Additional Metrics
      • Members by Tiers
    • Members
      • Member List
        • Configuration
        • Creating Members
        • Managing Members
        • Removing Members
      • Segments
        • Creating Segments
        • Managing Segments
        • Segment Conditions
      • Referred Members
    • Campaigns
      • Creating Campaigns
        • Return Campaign
        • Referral Campaign
        • Time-Based Campaign
        • Redemption Code Campaign
        • Internal event - Achievement progressed
        • Percent value distribution
      • Managing Campaigns
      • Campaign Simulation
      • Follow-up Campaigns
    • Custom Events
      • Custom Event Schemas
    • Transactions
      • Adding Transactions
      • Managing Transactions
      • Channels
    • Tiers
      • Adding Tiers
      • Managing Tiers
      • Tiers Configuration
      • Tier Benefits
    • Wallets
      • Wallet Types and Configuration
      • Unit Transfers
        • Creating Unit Transfers
        • Importing Unit Transfers
        • Managing Unit Transfers
    • Achievements
      • Creating Achievement
      • Managing Achievements
      • Follow up Achievements
    • Rewards
      • Reward List
        • Rewards Configuration
        • Creating Reward
        • Reward Types
        • Units Conversion Coupon
        • Adding Coupons
        • Reward Flow
      • Reward Fulfillment
      • Reward Categories
    • Webhooks
      • How to Configure a Webhook
      • What Triggers a Webhook
      • Expiring Notifications
    • Collections
    • Imports / Exports
      • Imports
        • Sample Import Files
      • Exports
        • UI Data Exports
        • Configuration Exports
        • S3 Bucket Exports
    • Settings
      • Roles
      • Admins
        • System Logs
      • Tenants
      • Translations
    • Expressions
      • Attributes List
      • Operators
      • Custom Functions
      • Expression Examples
      • Sample Use Cases
        • Using Member Custom Attributes
        • Complex Effects (if, else)
        • Excluding Members
        • Elapsed Time Conditions
        • Using Additional Dates for Calculations
        • Register on Birthday
        • Transaction on Birthday
        • Tier Upgrade or Downgrade
  • Sample Setups
    • Good Practices
    • Pay with Points
    • Promo and Discounts in Cart
    • Sample Campaigns
      • #1 Earn 1 point for every $1 spent
      • #2 Earn 2x points when shopping on Monday morning
      • #3 Earn 1 stamp for every transaction
      • #4 Buy product ACME 123 and earn 100 points
      • #5 Refer a friend and get 100 points
      • #6 Refer 5 friends and get a $50 off coupon for the next purchase
      • #7 Register to the program and get 50 bonus points
      • #8 Get 30 bonus points for your first transaction in the loyalty program
      • #9 Cashback campaign
      • #10 Product meets selected criteria
    • Sample Achievements
      • #1 Celebrate summer - Buy 5 times between June and August
      • #2 Place 10 Orders above 50€ - Complete 10 transactions, for more than 50€ each
      • #3 Ambitious player - Log in to the game 3 times per week for 8 consecutive weeks
      • #4 SKU 'ABC' configuration - Spend total of 100$ on products with SKU 'ABC132' in September
      • #5 Workout track -Track a workout of at least 30 minutes for 5 days in a row
      • #6 4 referees made the transactions for 2 consecutive weeks
      • #7 2 referees made a transaction configuration
  • FAQ
    • Configuration Migration
    • Custom Attributes
    • Achievements
    • GDPR
    • Opt-Out
    • Referral Programs
    • Returns and Cancellations
Powered by GitBook
On this page
  • Best Practices for Large-Scale Imports in Open Loyalty
  • 1. Start with Member Data
  • 2. Map Member IDs
  • 3. Import Unit Transfers
  • 4. Plan for Data Integrity
  • 5. Optional Imports
  • Enhanced Considerations for Large Databases
  • Test Migration on a Small Dataset First
  • Reserve Adequate Time for Each Import Type
  • Communicate with Open Loyalty Support

Was this helpful?

  1. Main Features
  2. Imports / Exports

Imports

Learn more about available import types the best practices on the import process.

Best Practices for Large-Scale Imports in Open Loyalty

When migrating data to Open Loyalty, careful planning and execution are essential to ensure accuracy and maintain the integrity of your loyalty program. This article focuses on the important considerations and recommended practices for large-scale imports.


1. Start with Member Data

The first step in any large import process is to migrate your member data. This step establishes member profiles in the system and provides the foundation for linking other data, such as transactions and unit transfers.

  • Why Start with Members?

    • Members are the core of your loyalty program.

    • Other imports, such as transactions or point transfers, require accurate member IDs to associate the data correctly.

  • Key Tip: If your focus is only on getting started quickly, migrating only member data is often sufficient. Transactions, unit transfers, and other optional imports can be added later.


2. Map Member IDs

After importing members, it is crucial to map their IDs accurately to ensure seamless data association for subsequent imports.

  • What is Mapping? Mapping ensures that every unit transfer corresponds to the correct member profile.

  • Risks of Skipping This Step:

    • Incorrect data association.

    • Discrepancies in member balances and loyalty program metrics.

You can add the following events using the external identifier (such as email, phone number, or loyalty card number):

  • Transactions

  • Custom Events

At the moment, the following events require member ID generated in Open Loyalty:

  • Unit Transfers


3. Import Unit Transfers

Once member IDs are mapped, proceed to import unit transfers. This step updates member balances with points (or other units) they’ve earned or spent.

  • Sequence Matters: Unit transfers rely on existing member IDs, so performing this step earlier could lead to errors or unlinked data.


4. Plan for Data Integrity

Adhering to the correct sequence—members first, followed by mapping, then transactions and unit transfers—ensures data integrity and avoids inconsistencies in your loyalty program.


5. Optional Imports

Remember that while transactions and unit transfers add value to your loyalty program, they are not mandatory to get started. Focus on migrating your core data (members) first and introduce other imports as your program scales.

The complete list of available import files can be found in the article below:


Enhanced Considerations for Large Databases

Test Migration on a Small Dataset First

Before migrating your entire database, conduct a test migration using a small subset of data in your stage environment.

  • Benefits:

    • Identifies potential errors early.

    • Ensures your data format and mapping are correct.

    • Validates system behavior under controlled conditions.

Reserve Adequate Time for Each Import Type

For large databases, allocate sufficient time for each type of data import.

For example:

  • A day for importing members.

  • Another day for transactions.

  • A separate day for unit transfers.

This approach minimizes pressure, reduces the risk of errors, and allows time to troubleshoot any issues.

Communicate with Open Loyalty Support

Please inform the Open Loyalty team of your migration schedule in advance. This will allow us to allocate the necessary resources, monitor the process closely, coordinate with you effectively, and provide timely feedback.

Last updated 4 months ago

Was this helpful?

Sample Import Files