> ## Documentation Index
> Fetch the complete documentation index at: https://docs.gameball.co/llms.txt
> Use this file to discover all available pages before exploring further.

# How Do I Import My Customers From Other Loyalty Programs to Gameball Using a CSV File?

> Your existing customers deserve to be on the Gameball loyalty program too! Import your registered customers' data with a few clicks.

After integrating Gameball with your platform, you can import the data of the previously existing customers to Gameball in a few easy steps.

***

## Step 1: Export Old Rewards Program Data

All you need to do is head to your current rewards program and ask for your customers' export files.

It is preferable that you collect the following information for every customer:

<Tabs>
  <Tab title="Shopify">
    | Field                      | Required  |
    | -------------------------- | --------- |
    | Customer Email             | Mandatory |
    | Birthday                   | Optional  |
    | Customer Points            | Optional  |
    | Required Tier Name (Level) | Optional  |
  </Tab>

  <Tab title="Non-Shopify">
    | Field                                | Required  |
    | ------------------------------------ | --------- |
    | Customer ID (could be email address) | Mandatory |
    | Customer Email                       | Optional  |
    | Birthday                             | Optional  |
    | Mobile Number                        | Optional  |
    | Customer Points                      | Optional  |
    | Required Tier Name (Level)           | Optional  |
  </Tab>
</Tabs>

Pause your current loyalty program on the old platform, and follow the next step to complete the migration process.

***

## Step 2: Migrate to Gameball

<Steps>
  <Step title="Go to the Importing Page">
    From **Gameball Admin Dashboard**, go to **Customers > Customers Tab > More > Update/Migrate Customers**.

    <Frame>
      <img src="https://mintcdn.com/gameball/Qqba4gmzc_M6HaMy/images/product-docs/guides-strategies-faqs/navigate-update-migrate-customers.png?fit=max&auto=format&n=Qqba4gmzc_M6HaMy&q=85&s=337826ec576cfa378fb7820f0553ee1e" alt="Navigate to Update/Migrate Customers" width="3036" height="1592" data-path="images/product-docs/guides-strategies-faqs/navigate-update-migrate-customers.png" />
    </Frame>
  </Step>

  <Step title="Upload Your CSV File">
    Choose **CSV** as data source.

    <Tabs>
      <Tab title="Shopify">
        <Frame>
          <img src="https://mintcdn.com/gameball/7dwj4uKg5t78O1BR/images/product-docs/guides-strategies-faqs/shopify-csv-upload.png?fit=max&auto=format&n=7dwj4uKg5t78O1BR&q=85&s=ae03b2058d7656f77c33048ec722449a" alt="Shopify CSV Upload" width="2550" height="1410" data-path="images/product-docs/guides-strategies-faqs/shopify-csv-upload.png" />
        </Frame>

        Click on **"CSV."**
      </Tab>

      <Tab title="Non-Shopify">
        Click on **"Click to upload."**

        <Frame>
          <img src="https://mintcdn.com/gameball/Qqba4gmzc_M6HaMy/images/product-docs/guides-strategies-faqs/non-shopify-csv-upload.png?fit=max&auto=format&n=Qqba4gmzc_M6HaMy&q=85&s=968911aaf43d131511f9f5f8cc7ed4a7" alt="Non-Shopify CSV Upload" width="3030" height="1616" data-path="images/product-docs/guides-strategies-faqs/non-shopify-csv-upload.png" />
        </Frame>
      </Tab>
    </Tabs>
  </Step>

  <Step title="Upload Your Extracted Customers File">
    Choose the downloaded CSV file and click **Open**.

    <Frame>
      <img src="https://mintcdn.com/gameball/7dwj4uKg5t78O1BR/images/product-docs/guides-strategies-faqs/select-csv-file.png?fit=max&auto=format&n=7dwj4uKg5t78O1BR&q=85&s=f9b836b295a68af64be403ce5dc8ed3c" alt="Select CSV File" width="3034" height="1618" data-path="images/product-docs/guides-strategies-faqs/select-csv-file.png" />
    </Frame>

    Once the file is read by Gameball, click **Continue**.

    <Frame>
      <img src="https://mintcdn.com/gameball/Qqba4gmzc_M6HaMy/images/product-docs/guides-strategies-faqs/csv-file-read-continue.png?fit=max&auto=format&n=Qqba4gmzc_M6HaMy&q=85&s=0174cf323c87620aee2578a1de959ac8" alt="CSV File Read Continue" width="2386" height="1446" data-path="images/product-docs/guides-strategies-faqs/csv-file-read-continue.png" />
    </Frame>
  </Step>

  <Step title="Map Your Attributes">
    In order for Gameball to correctly place the customers' data into their corresponding attributes, you will have to map the CSV file headers with Gameball's requested attributes.

    For example: if the CSV file has a column titled "Email address," then select this header under **Your File Attribute**, right beside **"Customer Email."** This way Gameball will understand that data under the "Email Address" column should be placed in the **Customer Email** attribute.

    <Frame>
      <img src="https://mintcdn.com/gameball/Qqba4gmzc_M6HaMy/images/product-docs/guides-strategies-faqs/map-attributes.png?fit=max&auto=format&n=Qqba4gmzc_M6HaMy&q=85&s=d688344260715be9cdd98f9462458990" alt="Map Attributes" width="3038" height="1620" data-path="images/product-docs/guides-strategies-faqs/map-attributes.png" />
    </Frame>

    <Note>The only mandatory data/customer attribute is the **Customer Identifier**, which could be placed with the email address if no unique ID/number is assigned to each customer.</Note>

    Choose the Tiering-up Recalculation Method by clicking on the **Edit Icon** under **"Tier Name"**:

    <Frame>
      <img src="https://mintcdn.com/gameball/7dwj4uKg5t78O1BR/images/product-docs/guides-strategies-faqs/tier-recalculation-method.png?fit=max&auto=format&n=7dwj4uKg5t78O1BR&q=85&s=7196b9e812a7300cc1d6c11c92bca265" alt="Tier Recalculation Method" width="2384" height="1248" data-path="images/product-docs/guides-strategies-faqs/tier-recalculation-method.png" />
    </Frame>

    | Option                     | Description                                                                                              |
    | -------------------------- | -------------------------------------------------------------------------------------------------------- |
    | Re-evaluate on next cycle  | Customers will be re-evaluated with the next recalculation cycle based on your tier expiry configuration |
    | Place in tier forever      | Customers are placed into this tier forever with no later evaluation                                     |
    | Place in tier until a date | Customers are placed into this tier until a specific date                                                |

    If you are adding customers' birth dates, choose the date format under **Date of Birth** that matches the format in the CSV file:

    <Frame>
      <img src="https://mintcdn.com/gameball/Qqba4gmzc_M6HaMy/images/product-docs/guides-strategies-faqs/date-format-mapping.png?fit=max&auto=format&n=Qqba4gmzc_M6HaMy&q=85&s=deb28a236f71ed8c4542038db939e79d" alt="Date Format Mapping" width="2454" height="1446" data-path="images/product-docs/guides-strategies-faqs/date-format-mapping.png" />
    </Frame>

    Supported formats: `YYYY-MM-DD`, `MM-DD-YYYY`, `DD-MM-YYYY`, `YYYY/MM/DD`, `DD/MM/YYYY`, `MM/DD/YYYY`

    Click **Import**.

    <Frame>
      <img src="https://mintcdn.com/gameball/Qqba4gmzc_M6HaMy/images/product-docs/guides-strategies-faqs/click-import-button.png?fit=max&auto=format&n=Qqba4gmzc_M6HaMy&q=85&s=104dd0cf0693a4eb984a5d7a01cfb36b" alt="Click Import Button" width="2844" height="1610" data-path="images/product-docs/guides-strategies-faqs/click-import-button.png" />
    </Frame>
  </Step>

  <Step title="Review Your Errors">
    If the CSV file you uploaded has unmatching data that doesn't comply with the original format, Gameball will show you the errors that need to be fixed for a successful migration.

    <Frame>
      <img src="https://mintcdn.com/gameball/7dwj4uKg5t78O1BR/images/product-docs/guides-strategies-faqs/review-errors.png?fit=max&auto=format&n=7dwj4uKg5t78O1BR&q=85&s=9a716c05c2fb254b553524080bb20699" alt="Review Errors" width="3036" height="1622" data-path="images/product-docs/guides-strategies-faqs/review-errors.png" />
    </Frame>

    <Note>If there are more than 10 errors in the file, you will need to **download** the error sheet to check all your errors, as you will not see all the errors on the reviewing page.</Note>

    After fixing all the errors on the sheet, click **re-upload**. If you find that the addressed errors will not cause a problem, click **Submit**.
  </Step>

  <Step title="Submit the File to Complete the Migration">
    If you have fixed all your errors, you can submit your file.

    You will then be redirected to the Customers page, where you will find the list of the new customers added, as well as a sheet of all the existing errors to be downloaded.

    <Note>An email will be sent with the errors sheet to the admin account's registered email.</Note>

    <Frame>
      <img src="https://mintcdn.com/gameball/Qqba4gmzc_M6HaMy/images/product-docs/guides-strategies-faqs/migration-complete.png?fit=max&auto=format&n=Qqba4gmzc_M6HaMy&q=85&s=0f4c946404e8821281f4b13db9071081" alt="Migration Complete" width="3032" height="1602" data-path="images/product-docs/guides-strategies-faqs/migration-complete.png" />
    </Frame>

    The migration/customer update process is now over, and the new customers are now part of your Gameball loyalty program.

    <Warning>
      * If you are a Shopify user, you can only update the information of existing customers from your customer list that was automatically migrated to Gameball during the integration process. As for non-Shopify users, by following this process, you will be able to migrate your customers or update the information of existing ones.
      * In the case of updating the data of an existing customer, any value in the migration sheet overrides what exists in the system. Example: if the customer has 300 points in the system and the sheet value for the same customer is 100, the customer's balance will be 100 after the successful migration. If the customer has 0 points on the sheet, the customer's balance will be 0 after migration. If the points cell is empty, the customer balance will be 300.
    </Warning>
  </Step>
</Steps>

***

## How to Migrate Guests (Customers Who Are Not Registered)

When migrating your customers from other loyalty programs or through a CSV file, some of the customers' data might not be registered. If you still want these customers to be part of your loyalty program, you will have to enable guest customers to integrate them with your loyalty program. [Learn how to integrate your guest customers into your rewards program](/product-documentation/guides-strategies-faqs/supportive-guides/integrate-guest-customers).

***

## How to Extract Your Current Customer Data

<Steps>
  <Step title="Go to the Customers Section">
    Navigate to your **Customers section** on the **Gameball Admin Dashboard**.
  </Step>

  <Step title="Export Your Data">
    On the top right of the page, click **More**, then **Extract**.

    <Frame>
      <img src="https://mintcdn.com/gameball/Qqba4gmzc_M6HaMy/images/product-docs/guides-strategies-faqs/extract-customers-data.png?fit=max&auto=format&n=Qqba4gmzc_M6HaMy&q=85&s=656f8c4f89923a492326d9cf8a0cb879" alt="Extract Customers Data" width="3030" height="1604" data-path="images/product-docs/guides-strategies-faqs/extract-customers-data.png" />
    </Frame>
  </Step>
</Steps>

***

## Related Articles

<CardGroup cols={2}>
  <Card title="Introduction to Customers on Gameball" icon="users" href="/product-documentation/understanding-your-customers/gameball-customers/introduction-to-customers-on-gameball">
    Learn more about how customer data is managed in Gameball.
  </Card>

  <Card title="Common Customer Update/Migration Errors" icon="triangle-exclamation" href="/product-documentation/guides-strategies-faqs/supportive-guides/customer-update-migration-errors">
    Troubleshoot errors that may occur during the customer migration process.
  </Card>
</CardGroup>
