Table of Contents
Raffle Ticket Export #
Creation Date: October 29, 2021
Created By: Andrew Skattebo
Access the Serial Numbers Module #
1. Click on Serial Numbers > Tools #
2. Click on Export #
3. Select “Sold” from Status Dropdown #
It is important to change this to SOLD so that refunded and cancelled tickets are not exported.
Also, there is a new checkbox to limit to sold. This should be checked as well.
4. Click on Search product by name (Optional) #
If you want to export just a single raffle at a time, select it here. This is totally optional.
5. #
#3 All fields will be selected by default. You can ctrl-click any field you don’t want to deselect it. #
# 4 Click Export #
7. Save file to convenient location #
This will export a csv that is viewable in Excel or Google Sheets.
You can use a random generator to select tickets if you put different tickets on different sheets or filter by the beginning of the ticket ID.
- Each ticket will then have a row number attached to it.
- You can go to https://www.random.org/ and put in 1- the last row# of the spreadsheet and it will generate a random row number for you. Select the winner from that. No printing required.
(If you need more order detail, you can export orders and re-link those #s to the ticket #s)