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
    • Timezones
Powered by GitBook
On this page
  • Member
  • Member Segments
  • Transactions
  • Transaction Matches
  • Coupons
  • Collections
  • Unit Transfers

Was this helpful?

  1. Main Features
  2. Imports / Exports
  3. Imports

Sample Import Files

Sample files for download

Last updated 1 day ago

Was this helpful?

Member

To add multiple members simultaneously, you can import an XML file containing member details. Ensure the file includes the information you need to migrate to Open Loyalty. A sample XML file for member import is available for reference.

When not using certain fields, e.g. address details or labels, remove them from the XML file instead of leaving them empty.


Member Segments

Static segments can be populated by importing a CSV file with a list of member identifiers. This method is useful for grouping members based on specific criteria. Ensure the CSV file retains the header column and lists the chosen identifiers.

To find out more, please refer to the article below:


Transactions

To record multiple transactions at once, you can import an XML file or a JSON file containing transaction details such as document number, purchase date, document type, SKU, name, quantity, transaction item value, and category.


Transaction Matches

If you have transactions that need to be associated with specific members, use the Match Import feature. This involves importing an XML file that includes both transaction and corresponding member data to establish the correct associations. A sample XML file is provided for this purpose.


Coupons

To add multiple coupons to your rewards system, import a CSV file containing coupon codes and related details. This streamlines the process of updating your coupon database.

Please refer to the Open Loyalty documentation for more detailed instructions on adding coupons.

To find out more, please refer to the article below:


Collections

Collections allow you to group values for use in campaign conditions. Import a CSV file with the desired values to create a collection. Ensure the CSV file contains at least three records.

To find out more, please refer to the article below:

Collections


Unit Transfers

To manage unit transfers, such as adding or deducting units, import XML or JSON files with the relevant details. Separate sample files are available for adding and spending units

Adding Units:

Spending (Deducting) Units:

Adding Coupons
Importing Custom Member List via CSV file to Static segment
625B
Member Import.xml
309B
Member Import Example.xml
87B
Member Segments.csv
5KB
Transactions Import.xml
4KB
Transactions Import.json
247B
Transactions Match Import.xml
288B
Coupons Import.csv
137B
Collections Import.csv
1KB
Adding.json
2KB
Adding.xml
383B
Spending.json
501B
Spending.xml