Learning Shopfront

Lotto Integration

Shopfront allows you to automatically apply a price for Lotto prizes and sales. This requires setting up barcode templates in Shopfront. Each lotto ticket printed from your Lotto terminal has a barcode that contains the product ID and price. 

Lotto Barcode Template

After enabling and creating a template following the linked article How to Configure Barcode Templates, you will need to configure the format specifically for lotto use. 

Type the code "2874XX$$$CC?" into the template text field. This code breaks down into the segments outlined below. 

2874 The leading 4 digits in this template are the specific lotto code
XX

Followed by placeholders for the individual product identifiers, the Product ID codes 

$$$

Followed by dollar amount place holders, this will be specified by the barcodes upon scan

CC

The number of cents

? Any unknown character

Lotto Product Setup

Once the lotto barcodes are enabled and created, it's time to set up the Lotto products to sell and redeem prizes by linking the barcode templates. 

Depending on how detailed you would like your sales report to be, products can be set up individually for each Lotto product sale and prize, eg, Lucky Lotteries Mega Jackpot, Oz Lotto, Lotteries Prize Payment or you can set up one product named Lotto Sales and another name Lotto Prizes and include each Lotto product ID as shown in the images below.

  1. Navigate to Menu > Stock Management > Products
  2. Either Create a New Normal Product or modify an existing product by searching for it and clicking Edit to the right of the description
  3. Name the product and enter a Case Quantity of 1
  4. Scroll down to Sell & Cost Prices and toggle on Cost is a percentage of sell price, the cost percentage amount should be changed to 100 (this ensures for reporting purposes the cost of goods sold will be equal to the revenue)
  5. Enable the Use Barcode Templates toggle
  6. Scroll down to the Barcodes Section
  7. For Lotto sales enter the barcode Quantity with a positive 1 and a negative value of -1 for the prizes Lotto products
  8. Add the corresponding Product ID (see Product ID List) for product codes
  9. Select the lotto barcode template from the Template drop-down menu (this will be the name of your Lotto template, there should only be one Lotto option to choose from)
  10. Scroll down to Inventory and turn off Track Inventory (this is recommended for products that don't have physical inventory)
  11. Finalise by clicking Save

Product ID List

Enter the corresponding ID Code for the lotto product you wish to create. These codes are supplied by Lotto to distinguish the type of Lotto sale.

ID Code Product
00 Syndicates Shares
60 Syndicates Shares (Paid with the Pay In-store Functionality)
01 Saturday Gold Lotto (GC), TattsLotto (Tatts), Saturday X Lotto (SAL), Saturday Lotto (NSWL)
61 Saturday Gold Lotto (GC), TattsLotto (Tatts), Saturday X Lotto (SAL), Saturday Lotto (NSWL) (Paid with the Pay In-store Functionality)
02 Oz Lotto
62 Oz Lotto (Paid with the Pay In-store Functionality)
04  Super 66 (GC, Tatts & SAL Only)
64 Super 66 (GC, Tatts & SAL Only) (Paid with the Pay In-store Functionality)
06 Monday & Wednesday Lotto (Tatts & NSWL) Monday & Wednesday Gold Lotto (GC) Monday & Wednesday X Lotto ( SAL)
66 Monday & Wednesday Lotto (Tatts & NSWL) Monday & Wednesday Gold Lotto (GC) Monday & Wednesday X Lotto ( SAL) (Paid with the Pay In-store Functionality)
07 Lucky Lotteries Super Jackpot
67 Lucky Lotteries Super Jackpot (Paid with the Pay In-store Functionality)
08 Lucky Lotteries Mega Jackpot
68 Lucky Lotteries Mega Jackpot (Paid with the Pay In-store Functionality)
09 Lotto Strike (NSWL Only)
69 Lotto Strike (NSWL Only) (Paid with the Pay In-store Functionality)
11 Keno (SAL Only)
71 Keno (SAL Only) (Paid with the Pay In-store Functionality)
12 Keno Coin Toss (SAL Only)
71 Keno Coin Toss (SAL Only) (Paid with the Pay In-store Functionality)
13 Set For Life
73 Set For Life (Paid with the Pay In-store Functionality)
52 Powerball
63 Powerball (Paid with the Pay In-store Functionality)
20 Card Activation (SAL Only)
21 Card Renewal (SAL Only)
22 Membership Reimbursements (Excluding SAL) (Negative value)
30 Instant Scratch –Its Sales
40 Lotteries Prize Payment
41 Instant Scratch-Its Prize Payment

 

Examples

To set up Lucky Lotteries Mega Jackpot, enter the code '08' (based on the table above) into the barcode code and select the Lotto template. 

mceclip0.png

To set up Lotteries Prize Payment and Instant Scratch-Its Prize Payment, enter the code, 40 and 41, with the quantity of each set to negative one.

mceclip1.png

The essential difference between lotto ticket and lotto prize product setup is that the code Quantity needs to be set to negative one for the prizes.  

 

Note: Refer to How to Show the Sales Value for Specific Products on a Register Closure, this allows the total value of lotto sales and prizes to display on the register closure report.