POS Integration - Sales Uploader

The sales uploader is a tool to upload sales manually into flaik from a spreadsheet for POS types that do not have an integration built.

Uploader (Scheduling -> Tasks)

The link to upload the .csv file is found in the Scheduling area of your flaik website.

Data Format

The data in the .csv spreadsheet must be formatted according to the Sale Uploader Specifications.

Field Name	Field Type	Required	Format
OrderId	String	TRUE
OrderLine	String	TRUE
StartDateTime	DateTime	TRUE	YYYY-MM-DDTHH:MM:SS
EndDateTime	DateTime	TRUE	YYYY-MM-DDTHH:MM:SS
BookingDate	Date	TRUE	YYYY-MM-DD
PrimaryPrivateOrderLine	String	FALSE
ProductCode	String	TRUE
IsTransaction	Boolean	TRUE
IsCancelled	Boolean	TRUE
Comments	String	TRUE
IsRequestPrivate	Boolean	FALSE
SaleLocationCode	String	FALSE
AssignedInstructorIdentifier	String	FALSE
RequestedInstructorIdentifier	String	FALSE
LessonDisciplineCode	String	FALSE
LessonAbilityLevelCode	String	FALSE
LessonLocationCode	String	FALSE
PersonIdentifier	String	TRUE
FirstName	String	TRUE
LastName	String	TRUE
PreferredName	String	FALSE
PersonDateOfBirth	Date	FALSE	YYYY-MM-DD
Email	String	FALSE
GenderCode	String	FALSE
PrimaryPassId	String	FALSE
SecondaryPassId	String	FALSE
TertiaryPassId	String	FALSE
Medication	String	FALSE
FoodAllergy	String	FALSE
DrugAllergy	String	FALSE
SpecialCondition	String	FALSE
PrimaryEmergencyContactName	String	FALSE
PrimaryEmergencyPhone	String	FALSE
SecondaryEmergencyContactName	String	FALSE
SecondaryEmergencyPhone	String	FALSE
TertiaryEmergencyContactName	String	FALSE
TertiaryEmergencyPhone	String	FALSE

Sample File / Template

1KB

Sale_Guest upload template - Sale Upload Example.csv