The cafe at our museum is changing operator and my CFO is asking if there is anyway to integrate cafe sales data with Tessitura. The only ecosystem partner for POS currently is SalesVu, which won't be used. Does anyone import this kind of data regularly? I can see setting up performances for items -- but do you need to set them up daily? What do you do if the menu changes regularly? Does anyone use a stored procedure to automate the import? Or is this a manual import every day? or week? Any insight would be appreciated.
Cross posting in Database Administrator's Forum.
Thanks!Anne RobichauxCRM AdministratorThe Historic New Orleans Collection.
Anne, does your cafe software have an api? If so, you can have TN consulting set up a process that pulls the data from the cafe system into the impresario database. Then you could set up a SQL agent job to run nightly to execute the stored procedure that gets the data. So, not manually, but you would definitely need to invest in some consulting.
We sell popcorn and concessions for our movie theater in Tessitura via one large general admission performance (per item... a popcorn performance, a soda performance, a candy performance. It's inelegant for sure.) You could do something similar, and use zones to itemize types (large vs medium vs small soda, for example).
We don't operate the cafe and we are between operators at the moment (it is closed). I think this question has come up as they work on finding a new tenant. I'm not entirely sure what info the CFO is looking for, since it isn't our money. But that's a good idea and when I talk to him next week I'll bring it up as a potential -- but costly -- solution. Thank you!