If your club has offline yearly sales paid via cash, cheque or Direct Debit, the ClubZap support team can import these players into our platform so they coexist with players who purchase lotto online directly via ClubZap.
This feature simplifies the management of external members and offline players by ensuring all entries are integrated into the system and searchable online.
If you are selling tickets offline they would normally have to be checked manually but these can be imported on once off occasions by emailing lottoimports@clubzap.com at least 1 business day before your draw. Please do not include any other email address in this submission.
For best results, ensure the file is prepared with consistent placeholders for purchase date and time, and double-check for accuracy before submission.
Please complete the following import file and sent to lottoimports@clubzap.com
Ensure all required fields are completed accurately, and use consistent placeholders for unknown values to streamline the process.
File: Download here
Details
Identifier: this field can be left blank
First Name: Name of person who this entry will be recorded against
Last Name: Surname of person who this entry will be recorded against
Email: Address for the player to receive weekly results and reminders when subscription is about to expire
Phone Number: Contact details for the lotto player
Purchase Date: Date of signup - if unknown use todays date
Purchase Time: Time of signup - if unknown use current time
Amount Paid: Cost of purchase - if unknown set to 10 (Note: This value must be > 5)
Draw Count: Number of draws to be assigned to this player
Finish Time: Date of expiry - if unknown set it to 1 year from today
Numbers: selection choice for the draw in a format such as 1-2-3-4 with a dash separating the number choice.
For unknown values, use consistent placeholders such as the current date for purchase date and 11:00 for purchase time to maintain uniformity.
Note: If a player has multiple lines they will require a dedicated row in the import file per number choice.
For players with recurring entries, ensure each line is entered on a separate row with unique lotto numbers to avoid errors.
Note: It is mandatory to have an email address and/or phone number for each entry being imported.
For imports please give at least 24 hours working day notice for the draw you would like your entries added to.
Common issues to watch for include missing entries, import errors due to incorrect file formats, and duplicate rows. Double-check the spreadsheet before submission to avoid these problems.