Skip to main content

How to Import Customer Birthday Data

Updated over a week 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 Loloyal, 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 from your previous app or platform in CSV format. Make sure to include Email and Birthday fields in the export.

Step 2: Log in to your Loloyal Admin account and 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, Loloyal 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?