• Replies 6 replies
  • Subscribers 416 subscribers
  • Views 109 views
  • Users 0 members are here
Related

Selling Gift Shop Merch. using Tessitura

Sean Rector
$organization

Hello Fellow Tessitura Network people;

I just realized this is my 1st post in the forums, so I'll introduce myself while I'm here.  I'm Sean Rector, the IT Manager for Virginia Opera Association in Norfolk, VA.

We would like to use Tessitura to sell merchandise in our Gift Shop.  We haven't purchased hardware yet, nor have we set anything up in Tessitura; we're looking at starting from the ground floor on this project.  We'd ideally like to have it up and running by September.  I'm envisioning the use of a touch-screen PC w/ a limited interface & card-swipe for credit card processing.

Your recommendations are greatly appreciated.

Sean

Parents
  • $organization

    Thanks for your post, Jen.  We’re considering using something like Quickbooks POS, have it export the daily sales reports for importing into Dynamics GP – it’s just that we have a stored procedure set up for doing that for the GL Exports from Tessitura…

     

    Luckily, we don’t have thousands of products – just hundreds…

     

    Sean Rector, MCSE

     

    From: Tessitura Ticketing Forum [mailto:forums-ticketing@tessituranetwork.com] On Behalf Of Jennifer Buzzell
    Sent: Thursday, May 05, 2011 10:52 AM
    To: Sean Rector
    Subject: RE: [Tessitura Ticketing Forum] Selling Gift Shop Merch. using Tessitura

     

    Hi – We use Tessy completely to run our online gift shop system http://www.strathmore.org/shop/, but don’t use it in person.  I imagine though it would not be too difficult, but I don’t know if it would do stuff like scan bar codes.  If you only have a few products like t-shirts, mugs and hats it would probably work OK.

     

    Ours is just too large (thousands of products), so we use a POS system in person that scans in manufacturer bar codes and creates bar codes for our hand made products that don’t have any. We considered using our POS system to run the online shop too, but it would have required two separate log in and carting processes for our patrons, and they would never be able to add merch onto a ticket order.

     

    Best,

    Jen

     

    From: Tessitura Ticketing Forum [mailto:forums-ticketing@tessituranetwork.com] On Behalf Of Sean Rector
    Sent: Wednesday, May 04, 2011 11:55 AM
    To: Jen Buzzell
    Subject: [Tessitura Ticketing Forum] Selling Gift Shop Merch. using Tessitura

     

    Hello Fellow Tessitura Network people;

    I just realized this is my 1st post in the forums, so I'll introduce myself while I'm here.  I'm Sean Rector, the IT Manager for Virginia Opera Association in Norfolk, VA.

    We would like to use Tessitura to sell merchandise in our Gift Shop.  We haven't purchased hardware yet, nor have we set anything up in Tessitura; we're looking at starting from the ground floor on this project.  We'd ideally like to have it up and running by September.  I'm envisioning the use of a touch-screen PC w/ a limited interface & card-swipe for credit card processing.

    Your recommendations are greatly appreciated.

    Sean




    This message was sent automatically to you by www.tessituranetwork.com because you subscribed to the Tessitura Ticketing Forum. You may reply to this message to post to the Ticketing forum or visit the site to search, read and post to the forums. In the interest of keeping the forum posts from becoming cluttered, we encourage you to delete previous message text from your reply before sending. Thank you!



    --
    View this message online at http://www.tessituranetwork.com/COMMUNITY/forums/p/4485/14799.aspx#14799 or reply to this message
    --
    This message was sent automatically to you by www.tessituranetwork.com because you subscribed to the Tessitura Ticketing Forum. You may reply to this message to post to the Ticketing forum or visit the site to search, read and post to the forums. In the interest of keeping the forum posts from becoming cluttered, we encourage you to delete previous message text from your reply before sending. Thank you!

    Information Technology Manager
    Virginia Opera Association

    E-Mail:         sean.rector@vaopera.org
    Phone:        (757) 213-4548 (direct line)
    {+}

    On Sale NOW 2011-2012 Subscriptions featuring four NEW Productions
    Aida | Hansel And Gretel | Orphée | The Mikado
    Visit us online at www.VaOpera.org or call 1-866-OPERA-VA

    The vision of Virginia Opera is to enrich lives through the powerful integration of music, voice and human drama.

    This e-mail and any attached files are confidential and intended solely for the intended recipient(s). Unless otherwise specified, persons unnamed as recipients may not read, distribute, copy or alter this e-mail. Any views or opinions expressed in this e-mail belong to the author and may not necessarily represent those of Virginia Opera. Although precautions have been taken to ensure no viruses are present, Virginia Opera cannot accept responsibility for any loss or damage that may arise from the use of this e-mail or attachments.

    {*}

Reply
  • $organization

    Thanks for your post, Jen.  We’re considering using something like Quickbooks POS, have it export the daily sales reports for importing into Dynamics GP – it’s just that we have a stored procedure set up for doing that for the GL Exports from Tessitura…

     

    Luckily, we don’t have thousands of products – just hundreds…

     

    Sean Rector, MCSE

     

    From: Tessitura Ticketing Forum [mailto:forums-ticketing@tessituranetwork.com] On Behalf Of Jennifer Buzzell
    Sent: Thursday, May 05, 2011 10:52 AM
    To: Sean Rector
    Subject: RE: [Tessitura Ticketing Forum] Selling Gift Shop Merch. using Tessitura

     

    Hi – We use Tessy completely to run our online gift shop system http://www.strathmore.org/shop/, but don’t use it in person.  I imagine though it would not be too difficult, but I don’t know if it would do stuff like scan bar codes.  If you only have a few products like t-shirts, mugs and hats it would probably work OK.

     

    Ours is just too large (thousands of products), so we use a POS system in person that scans in manufacturer bar codes and creates bar codes for our hand made products that don’t have any. We considered using our POS system to run the online shop too, but it would have required two separate log in and carting processes for our patrons, and they would never be able to add merch onto a ticket order.

     

    Best,

    Jen

     

    From: Tessitura Ticketing Forum [mailto:forums-ticketing@tessituranetwork.com] On Behalf Of Sean Rector
    Sent: Wednesday, May 04, 2011 11:55 AM
    To: Jen Buzzell
    Subject: [Tessitura Ticketing Forum] Selling Gift Shop Merch. using Tessitura

     

    Hello Fellow Tessitura Network people;

    I just realized this is my 1st post in the forums, so I'll introduce myself while I'm here.  I'm Sean Rector, the IT Manager for Virginia Opera Association in Norfolk, VA.

    We would like to use Tessitura to sell merchandise in our Gift Shop.  We haven't purchased hardware yet, nor have we set anything up in Tessitura; we're looking at starting from the ground floor on this project.  We'd ideally like to have it up and running by September.  I'm envisioning the use of a touch-screen PC w/ a limited interface & card-swipe for credit card processing.

    Your recommendations are greatly appreciated.

    Sean




    This message was sent automatically to you by www.tessituranetwork.com because you subscribed to the Tessitura Ticketing Forum. You may reply to this message to post to the Ticketing forum or visit the site to search, read and post to the forums. In the interest of keeping the forum posts from becoming cluttered, we encourage you to delete previous message text from your reply before sending. Thank you!



    --
    View this message online at http://www.tessituranetwork.com/COMMUNITY/forums/p/4485/14799.aspx#14799 or reply to this message
    --
    This message was sent automatically to you by www.tessituranetwork.com because you subscribed to the Tessitura Ticketing Forum. You may reply to this message to post to the Ticketing forum or visit the site to search, read and post to the forums. In the interest of keeping the forum posts from becoming cluttered, we encourage you to delete previous message text from your reply before sending. Thank you!

    Information Technology Manager
    Virginia Opera Association

    E-Mail:         sean.rector@vaopera.org
    Phone:        (757) 213-4548 (direct line)
    {+}

    On Sale NOW 2011-2012 Subscriptions featuring four NEW Productions
    Aida | Hansel And Gretel | Orphée | The Mikado
    Visit us online at www.VaOpera.org or call 1-866-OPERA-VA

    The vision of Virginia Opera is to enrich lives through the powerful integration of music, voice and human drama.

    This e-mail and any attached files are confidential and intended solely for the intended recipient(s). Unless otherwise specified, persons unnamed as recipients may not read, distribute, copy or alter this e-mail. Any views or opinions expressed in this e-mail belong to the author and may not necessarily represent those of Virginia Opera. Although precautions have been taken to ensure no viruses are present, Virginia Opera cannot accept responsibility for any loss or damage that may arise from the use of this e-mail or attachments.

    {*}

Children
  • $organization in reply to Sean Rector

    Hello

    We have just set up our online shop selling merchandise by setting them up as 'performances'. Our web company has customised the order screen so that the 'seat' and 'date' and 'venue' dont appear. However they do in the confirmation email which comes from Tessitura. Has anyone else found a solution or had anything written to suprress this (as i don't want to confuse our ticket/merchandise buying public)

     

    Thanks

    Cait, Live Theatre Newcastle

  • $organization in reply to Cait Read

    Hi Cait,

    We also sell merchandise with is setup as a 'performance' in Tessitura:  http://www.abbeytheatre.ie/shop/

    We customised the XSL for the confirmation email to put the merchandise items in a separate section.

    The coding for this basically involved putting "facility_desc='Merchandise'" in the merchandise section and putting "facility_desc!='Merchandise'" in all the other sections.

    I've pasted a larger excerpt of the code at the end of this post but I can email you the full XSL file and an example of the confirmation if you want.

    cheers, Dara

     

     

     

     

     

     

     

     

     

    <!--

     

     

     

    MERCHANDISE HANDLING

    -->

    <

     

     

     

    xsl:if test="count(//GetOrderDetailsInfoResults/LineItem[facility_desc='Merchandise']) &gt; 0"

    >

    <

     

     

     

    xsl:variable name="thisTotal" select="sum(//GetOrderDetailsInfoResults/SubLineItem[pkg_no=0 and li_seq_no=(//GetOrderDetailsInfoResults/LineItem[pkg_no=0 and facility_desc='Merchandise']/li_seq_no)]/due_amt)"

    />

    <

     

     

     

    tr

    >

    <

     

     

     

    td align="left" valign="top" colspan="2" style="color: #000000;"

    >

    <

     

     

     

    b>Merchandise:</b

    >

    </

     

     

     

    td

    >

    </

     

     

     

    tr

    >

    <

     

     

     

    tr

    >....etc.