We're just beginning our first season build using v12.5.1 and I am now creating all 42 of our price templates. For those of you who have worked with Price Templates for a season build already, what did you use to proof the set up? Obviously because I'm typing in prices, I want a second set of eyes to look at everything to ensure that:
A) Each zone has a price or is disabled if there isn't
B) Comparing prices to the spreadsheet to ensure that the amounts are correct
C) All price types appear
D) Discounts (%age based) are calculated correctly off the base price
If anyone can point me in the proper direction for a report or even some SQL code you've used to proof that would be great.
Thanks all, but this is to proof pricing on performances and I want to proof at the Template level before they get onto performances. I'll have to create some code myself to pull. Thanks for your help! From: Aileen Duffy <bounce-aileenduffy6577@tessituranetwork.com> Sent: 9/29/2016 10:27:24 PM I just happened to have the file open! Price Proofing Report Guthrie Theater 6-Aug-2015 6-Aug-2015 This SSRS report simply presents all price types associated with a performance, by Zone, somewhat like the pricing setup screens in Ticketing Setup -> Performances -> Pricing. NO 348 From: Tessitura Ticketing Forum [mailto:forums-ticketing@tessituranetwork.com] On Behalf Of Michele Keutsch Sent: Thursday, September 29, 2016 4:25 PM To: Aileen Duffy <aileen@mos.org> Subject: Re: [Tessitura Ticketing Forum] Proofing Price Templates Christopher, If you could find the name or solution number, that would be so appreciated. I've looked through and the only one I could find is from Chris Jensen but it's based on a performance and I want to proof at the template set up before it gets to the performance level. Thanks, MK From: Christopher Cuhel <bounce-christophercuhel9903@tessituranetwork.com> Sent: 9/29/2016 3:02:38 PM Hi Michele, I believe there is a shared report on TASK for just this. I'm not sure the name in TASK but if we just adjusted a little for us, then it should be "Price Matrix Verification" It's an SSRS report. I didn't download it from the shared reports so I can't be certain of the actual name. It's been a savior when it comes to price grid checking. Christopher Cuhel, The 5th Avenue Theatre 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! 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!
Thanks all, but this is to proof pricing on performances and I want to proof at the Template level before they get onto performances.
I'll have to create some code myself to pull. Thanks for your help!
From: Aileen Duffy <bounce-aileenduffy6577@tessituranetwork.com> Sent: 9/29/2016 10:27:24 PM
I just happened to have the file open!
Price Proofing Report
Guthrie Theater
6-Aug-2015
This SSRS report simply presents all price types associated with a performance, by Zone, somewhat like the pricing setup screens in Ticketing Setup -> Performances -> Pricing.
NO
348
From: Tessitura Ticketing Forum [mailto:forums-ticketing@tessituranetwork.com] On Behalf Of Michele Keutsch Sent: Thursday, September 29, 2016 4:25 PM To: Aileen Duffy <aileen@mos.org> Subject: Re: [Tessitura Ticketing Forum] Proofing Price Templates
Christopher,
If you could find the name or solution number, that would be so appreciated. I've looked through and the only one I could find is from Chris Jensen but it's based on a performance and I want to proof at the template set up before it gets to the performance level.
Thanks, MK
From: Christopher Cuhel <bounce-christophercuhel9903@tessituranetwork.com> Sent: 9/29/2016 3:02:38 PM
Hi Michele,
I believe there is a shared report on TASK for just this. I'm not sure the name in TASK but if we just adjusted a little for us, then it should be "Price Matrix Verification" It's an SSRS report. I didn't download it from the shared reports so I can't be certain of the actual name. It's been a savior when it comes to price grid checking.
Christopher Cuhel, The 5th Avenue Theatre
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!
That would work too, but I was trying to find an easy way to export all the data into excel so that I can create formulas to find any errors in the pricing.
Also, we have 4 different venues, where 2 of them have 26 or more zones so scrolling becomes an issue and then there are over 42 different templates total, so having someone proof them in the client is going to make them cross-eyed.
Michele
Hi Michele
Did you ever figure out a way to export the pricing templates to excel?
ThanksJess LevySan Francisco Opera
No, I didn't figure it out. We manually proof, comparing our excel spreadsheets of pricing to the various templates. It's tedious, tiresome and downright horrible on the eyes but accuracy is important. In this day and age, it would seem that there should be a way to import a template from an excel spreadsheet - where at least you can easily proof things!
Michele,
Above you ask for some SQL code, and I think I have what you need. At least the main stuff. It has the prices and whether or not it is enabled arranged by price type down the left side and the price zones spread across to the right like it looks in Tessitura's set up for price templates based off of the template number. This code would need more work before it could be created as a report or if you were looking for additional or slightly different information, but it certainly is a place to start.
The big problem with it all was that it involved un-pivoting the initial information and then a dynamic pivot of the information based on the number of price zones, but with a little ingenuity, I was able to get something that works.
If you are still interested, please feel free to e-mail me, JMoskal@TheCenterPresents.org
John