All Questions

Design a Custom Ticket Template Using Design Pro

This article will guide you through the steps to create a customised ticket template.

Before starting, you will need to make sure that Design Pro and Hardware Connect have been installed on the computer, for instructions on how to set these up, refer to How to install Avery Design Pro for Shelf Tickets and How to Set Up Hardware Connect.

Creating the ticket template measurements

In the example below we will be creating a 32up ticket template with two prices 1st & 2nd price.

  1. Open Design Pro
  2. Select Design from Scratch
  3. Select Custom
  4. Enter the Item Number, eg; 32up
  5. Enter the number of panels vertically and horizontally
  6. Enter the measurements in millimetres for the page and panel measurements

  7. Select OK
  8. Select File
  9. Select Save As
  10. Select the C:\Tickets location and name the file. If this location does not exist then you should review the How to Set Up Hardware Connect article.

Adding the Ticket Fields to the ticket template

Now that the template has been sized up, it's time to add the relevant fields to the ticket template, as mentioned previously, in this example we will be adding the first and second price to the template. You will need to first export a product from your tickets page in Shopfront.

  1. From the Shopfront tickets page export one or multiple products for further information see How to Export and Print Shelf Tickets
  2. Your file explorer should now open the C:\Tickets folder
  3. Open the template previously saved into this folder
  4. Select Database > Open > Open Database > navigate to C:\Avroposwin and select the file named POSLABELNEW.dbf
  5. You should now be presented with a box showing Database Options Select Cancel

    To add the relevant fields, to the ticket template see How to Edit Shelf Tickets Templates and refer to the Everyday Tickets table.

  6. We will now be adding the product name to the template, select Database > Insert Field
  7. For the full product name select the field named LONGDESC and select Insert > Close
  8. Click anywhere on the field description and size it into the area you want the product name to be displayed


  9. To add the first price, click outside the LONGDESC field and repeat step 6
  10.  Select the field called PRICEN (the actual first price) and drag this template into the area you want the first price to be displayed, you will likely want to add a dollar sign before the field name so that the text shows $PRICEN
  11. Optionally select insert and select Text, drag the text just above PRICEN and type the name of the first price, we will call this Single
  12. To add the second price, click outside the PRICEN field and repeat step 6
  13. Select the field called LBLPRICE1 (the actual second price) and drag this template into the area you want the second price to be displayed, you will likely want to add a dollar sign before the field name so that the text shows $LBLPRICE1
  14. To show a quantity indicator above the price, repeat step 6 and select the field PRICE_IND1 this is the quantity related to the second price, in this example we have added the word 'for' at the end of the field
  15. Now that you have the fields created and displayed in the right area, you may want to adjust the size and the font of the fields
  16. Select Save As
  17. Navigate to the C:\Tickets folder and name the template, in this case, we will name the template 32up 1st & 2nd Price


Now that we have created our first ticket template, you can follow these steps to create different sizes of templates and add different pricing combinations.