In this article:

1. Introduction
2. Download import template
3. Fill in customer details
4. About membership tier calculation
5. About total spent and orders calculation
6. Import template to store
7. FAQ about cut-off date

1. Introduction

This guide will walk you through the steps to migrate your customer details from an external platform into EasyStore. By following these instructions, you’ll be able to seamlessly import customer information, ensuring a smooth transition and continued engagement with your customers on EasyStore.

2. Download import template

2.1 Log in to your EasyStore admin panel > Customers > 3 dots menu on the top right > Import customers.

2.2 Click on your preferred file format: .csv or .xlsx to download it to your device.

3. Fill in customers details

3.1 Open the file and fill in the customer details accordingly.

4. About membership tier calculation

4.1 System will assign customer to membership tier according to customer’s spending calculated based on formula below.

Max (A , B) + C + D

Where:

• A - 'Membership Spending Adjustment Legacy'
• B - Total spent of imported orders on and before 'Membership Adjustment Legact Cut-Off Date'
• C - Total spent of imported orders after 'Membership Adjustment Legacy Cut-Off Date'
• D - Total spent of EasyStore orders

Example:

Imported customer details:

Membership Spending Adjustment Legacy: RM400

Imported order history:

• 2025-02-01 : RM200
• 2025-07-31 : RM300 (cut-off date)
• 2025-08-01: RM100

Total EasyStore orders: RM800

The spending amount used to determine membership will be:

Max (400, 200+300) + 100 + 800

= 500 + 100 + 800

= 1400

5. About total spent and orders calculation

5.1 Each customer will have record of total spent and number of orders.

5.2 Similarly, system will set customer’s spending based on formula below:

Max (A , B) + C + D

Where:

• A - 'Total Spent Adjustment Legacy'
• B - Total spent of imported orders on and before 'Sales Adjustment Legacy Cut-Off Date'
• C - Total spent of imported orders after 'Sales Adjustment Legacy Cut-Off Date'
• D - Total spent of EasyStore orders

5.3 The same formula applies for orders:

Max (A , B) + C + D

Where:

• A - 'Total Orders Adjustment Legacy'
• B - Total of imported orders on and before 'Sales Adjustment Legacy Cut-Off Date'
• C - Total of imported orders after 'Sales Adjustment Legacy Cut-Off Date'
• D - Total of EasyStore orders

6. Import template to store

6.1 Once done filled up the template, go back to Customers > click on the 3-dot menu on the top right > Import customers > Choose file > select the file.

6.2 Double check that the fields and columns are matching > Import.

6.3 Customers are done imported to your store.

7. FAQ about cut-off date

7.1 Why do we need to separate legacy spending and orders before and after the cut-off date?

This is important when migrating and importing both customers’ data and order history into EasyStore, to prevent double counting.

Example:

• Legacy total (in customer data) = RM1,000 (already includes Jan–Jun orders).
• Imported total (in order history) = RM1,000 (Jan–Jun) + RM500 (Jul–Aug).

Without cut-off:

RM1,000 (Legacy) + RM1,500 (Imported) = RM2,500 ❌ (double counting Jan–Jun).

With cut-off:

Max (RM1,000 legacy, RM1,000 imported before cut-off) + RM500 after cut-off = RM1,500 ✅ (actual spending)

7.2 Which date should I use as the cut-off date?

It is recommended that the date of exporting customers’ data from the previous platform be used as the cut-off date.

Updated on: 03/10/2025