Import Loyalty points from a CSV File

Import Loyalty points from a CSV File

Introduction

In this article, we'll delve into the process of importing Loyalty Data from a CSV file into AiTrillion. This feature facilitates the seamless transfer of customer loyalty data, ensuring that merchants can efficiently manage and update their loyalty programs.
โ€‹

Here are the steps to import Loyalty Data from CSV File -:

Step 1. Go to Loyalty Rewards > Members > Import Members.

Step 2. Click on the Download Sample CSV button.

Step 3. Fill the sample CSV with your data. Feel free to write in to support@aitrillion.com if you need help.

Note๐Ÿ“: If the customer have existing points and trying to import the new loyalty points then the Points spent and Available points will be added to the Lifetime points

In the CSV following calculations are performed -:

1.) Lifetime points + Points approved + Points spent

2.) Lifetime points - Points redeemed = Available points

Example -:

Before importing the points I have 20 Lifetime points and 10 Available points.


If we import the Point approved - 350 and Point spent - 1500 for this customer
โ€‹

The calculated points will be following -:

Step 4. Upload the CSV by clicking on the Upload CSV button.

    • Related Articles

    • Import your Customers using CSV file

      Introduction: If you have a customer list that you want to use in Shopify, then you can enter it into a customer CSV file, and then import the CSV file into your Shopify admin. This is a step to step guide to importing Customers using CSV. Process: ...
    • Ultimate Guide to AiTrillion's Loyalty Rewards Program

      Watch the 5-minute loyalty setup video: Introduction This guide walks you through setting up a Loyalty Rewards Program in AiTrillion, explaining how it works and how you can track campaign performance to boost customer retention and sales. Loyalty ...
    • Export loyalty points

      Introduction In this article, we'll explore the seamless process of exporting Loyalty Points data from your AiTrillion account. Whether you need to analyze customer engagement or integrate loyalty data with other systems, exporting Loyalty Points is ...
    • How To Import Bulk Members Through CSV On Recurring Membership Module?

      Introduction Membership module gives you an option to import bulk members through CSV on the membership plans. You can import the members into a free membership plan or a paid membership plan. When you import members in a paid plan. You need to add ...
    • Import members in Membership V2

      Introduction In this article, we will explore the process of importing members into Membership V2. Note: The members can only import into Manual renewal plan To create manual membership - Click here Here are the steps to import members in Membership ...