CSV Data Import

Upload CSV File

Select your latest CSV file. This operation will preserve all your current data and only add new records.

Expected CSV Format:

  • Column 0: Customer ID (membership_details.membershipkey)
  • Column 1: Phone Number (membership_details.phonenumber)
  • Column 2: First Name (membership_details.firstname)
  • Column 3: Last Name (membership_details.lastname)
  • Column 4: Staff Assigned (membership_details.employee)
  • Column 5: Staff Served (purchases.employee)
  • Column 6: Branch ID (purchases.branchid)
  • Column 7: Created At (purchases.createdat)
  • Column 9: Order Amount (purchases.sales)