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
  • Why Use Imports for Unit Transfers
  • Prerequisites
  • Understanding the Import File
  • How to Import Unit Transfers
  • Troubleshooting and Common Issues
  • Best Practices

Was this helpful?

  1. Main Features
  2. Wallets
  3. Unit Transfers

Importing Unit Transfers

In this article, you’ll learn how to import unit transfers into Open Loyalty.

Last updated 3 months ago

Was this helpful?

Importing allows you to bulk-upload multiple unit transfers at once, making it easier to manage units on loyalty accounts. This is especially handy when you have a large volume of transfers—saving you time and ensuring accuracy.

Why Use Imports for Unit Transfers

When working with many transfers (e.g., manual corrections, adjustments, or data from external systems), entering them one by one into the system can be time-consuming. Importing unit transfers via supported file types simplifies this process and reduces the chance of human error.

  • Faster processing of large datasets

  • Consistency in data updates

  • Reduced manual input errors


Prerequisites

Before you begin, make sure you have the following:

  1. OpenLoyalty Admin Access You must be logged into the Admin Panel with permission to import data.

  2. Correct File Format: JSON or XML Only JSON and XML are accepted by OpenLoyalty for importing unit transfers.

  3. Sample File Structure Review the structure of JSON and XML files provided below to understand how to format your adding or spending (deducting) transfers. You can find these files under the link below.


Understanding the Import File

OpenLoyalty supports two key scenarios when importing unit transfers:

  1. Adding Units (e.g., awarding units)

  2. Spending or Deducting Units (e.g., redeeming units)

Your JSON or XML file needs to include fields such as:

  • Customer ID (required) The unique identifier of the loyalty account to which the transfer applies.

Use the identifier generated by Open Loyalty.

First, you might need to match your internal identifier (such as email, phone number, or loyalty card number) to the corresponding member ID in Open Loyalty.

  • Units (points) (required) The number of units that need to be added or deducted.

  • Wallet (walletTypeCode) (required) The code of the wallet the units need to be added to or deducted from.

  • Date (registeredOn) (optional) The date of the transfer, typically in YYYY-MM-DD HH:mm:ss format. If not specified, the registeredOn date will be saved as the date of unit transfer creation.

  • Expire Date (optional)

    You can define the expiry date for units in two ways:

    • expireAt: Specifies the exact date and time of expiry.

    • expiresInDays: Indicates how many days from the registration date the units will remain available.

  • Pending Date (optional)

    You can define the pending (lock) date for units in the following way:

    • lockedUntilDays: Indicates how many days from the registration date the units will remain pending (locked).

  • Comment (optional) Any additional text or comments about this unit transfer.

For detailed structures, please refer to the JSON and XML example files above.


How to Import Unit Transfers

Below is a step-by-step guide on how to import your unit transfers:

1. Navigate to the Import Section

  1. In the OpenLoyalty Admin Panel, go to Wallets, then Unit transfers.

  2. Select the down arrows next to the Unit transfers and select the relevant Import transfers option.

  1. Click Click to upload or drag and drop a file.

  2. Click on Import units transfers.

2. Check the Import Results

  1. You can find the list of imported files under Imports / Exports menu option, in the Imports tab.

  2. If there are errors, you can filter them out and validate the results.


Troubleshooting and Common Issues

  • Invalid File Format If you attempt to upload a non-supported file type (like CSV), the system will likely reject it. Make sure you only upload JSON or XML.

  • Date/Time Format Ensure your dates are in a format OpenLoyalty accepts (often YYYY-MM-DD HH:mm:ss).

  • Invalid Account IDs The import will fail if an account ID doesn’t exist in the system. Make sure the correct accounts are set up, or update your file to reflect valid IDs.

  • Insufficient Permissions Only users with the right roles (e.g., Admin or specific Import/Export permissions) can perform imports. Check your user role if you don’t see the import option.


Best Practices

  1. Review the JSON/XML Examples Ensure your file’s structure matches the Adding.json, Adding.xml, Spending.json, or Spending.xml formats before uploading.

  2. Test with a Small Sample Before importing a large file, test with a small subset of data to ensure everything processes correctly.

  3. Keep a Backup Maintain a copy of your original JSON or XML files. This way, if anything goes wrong, you can quickly revert.

Sample Import Files