Recording unique voucher codes - and then searching for them

Hi

We are looking at running a promotion through one of the group buying sites (such as Groupon or Keynoir) and I have a worry about it.

Basically, the customer is issued with a voucher which contains a voucher code, they then call the box office to redeem their voucher for a ticket. The customer can purchase more than one voucher, all of which have a unique ID. I would like some way of searching to see if the code has already been used, and then recording it on the customer's account. Unfortunately we do not get the customer's details and associated voucher code in advance of them calling us.

I've thought about using Attributes as these are eary to search on, but it seems you can't free type into the Attribute Value cell, just pre-fill the T_KWCODED_VALUES table to select from a drop down. This is not workable for us. Please do correct me if I'm wrong.

I've also thought about creating a custom tab but as far as I can tell, there's no way to search these from the Constituent search screen. Again, please correct me if I'm wrong.

I did consider creating a report that allows searching for the voucher code, but I feel this would be too time consuming for the box office at point of sale.

 

Can anyone think of a way to do this that allows for searching and free-typing, and is not going to be time-consuming for the box office?

Thanks

Siobhan

Parents
  • I’m looking into using Groupon as well and have had similar fears about madness ensuing at the ticket office with regards to redemption. As part of my research, I spoke to a colleague at the Milwaukee Symphony Orchestra who has used Groupon and she advised us to use just one performance and seat everyone—not worrying about the redemption part. What she did was just seat everyone under a “Groupon” constituent record and make a special Will Call table for Groupon recipients.

     

    ANYWAY—to get to your actual question, you *can* free-type into an attribute value. Looks to me like you want to leave the following columns blank in T_KEYWORD:

    Ref Tbl

    Ref Idcol

    Ref Desccol

    Ref Where

    Ref Sort

    …and then not do anything in T_KWCODED_VALUES.

     

    -p.

     

    PATRICK SCHLEY | Marketing & Sales Manager | Milwaukee Repertory Theater
    Patty & Jay Baker Theater Complex | 108 East Wells Street | Milwaukee, WI 53202
    414.290.0710 tel | 414.224.9097 fax | pschley@milwaukeerep.com
    Website: www.milwaukeerep.com | Facebook: www.facebook.com/milwrep | Twitter: twitter.com/milwrep

     

    On stage at The Rep...

    CABARET | September 14-October 24 | Quadracci Powerhouse

    LAUREL AND HARDY | September 24-November 14 | Stackner Cabaret

    MY NAME IS ASHER LEV | September 29-November 14 | Stiemke Studio

    Buy tickets today! Visit www.milwaukeerep.com or call 414.224.9490.

  • Hi Patrick - I've done everything you suggested and it's still not allowing me to free-type anything. Anything I might have missed?

Reply Children