Skip to main content

How to Import Customer Birthday Data

Updated over 2 weeks ago

Introduction

Celebrate your customers on their special day by sending them personalized rewards! This guide will walk you through the simple steps to upload birthday data into TrustWILL Loyalty, whether you're transitioning from another platform or updating existing records.

Let's turn every birthday into a chance to boost loyalty and delight your customers!


How to Import Customer Birthday Data

Step 1: Export your customer list as a CSV file from your previous platform (include Email and Birthday fields).

Step 2: In TrustWILL Loyalty Admin, go to Preferences > Import Loyalty Data.

Step 3: Upload your CSV file using the correct format.


Tips for a Successful Upload

  • No blank cells are allowed in the Email or Birthday columns.

  • The email address must already exist as a customer in your Shopify store.

  • Use one of these date formats:

    • MM-DD (e.g., 07-23)

    • YYYY-MM-DD (e.g., 1995-07-23)

  • Valid date ranges:

    • Year: between 1900 and 2100

    • Month: between 01 and 12

    • Day: between 01 and 31

  • To prevent Excel from auto-formatting the date, pre-format the Birthday column as Text before saving the file.

Once imported, TrustWILL Loyalty will automatically recognize upcoming birthdays and trigger your birthday reward workflows, making it easy to surprise and delight your customers right on time! 🎁

Did this answer your question?