• Replies 9 replies
  • Subscribers 416 subscribers
  • Views 220 views
  • Users 0 members are here
Related

Ticketmaster Order Reconciliation

Maery Simmons (Past Member)
$organization

Do you sell via Ticketmaster (or another third party)? How do you get those sales into Tessitura and report back on them? How often do you do the import? How do you handle returns/reselling? I want to hear as much as you're willing to tell me.

Parents
  • $organization

    Hi Maery

    I guess it depends on what sort of reporting you need. I've done this a couple of times - at a previous organisation and at my current one. A (very) brief overview of the 2 scenarios:

    1.  I was able to negotiate with Ticketmaster for them to provide the data in (basically) the right format to be able to use the Order Import utility. There was a little manual manipulation needed but, as a DBA, I used to import the data into a staging database, run a script and then import it into Tessitura.
    2. Our current 3rd party vendor won't do this but I am able to get a sales report that I can import into a local table

    Obviously, any reporting has to be custom. Sadly, there is no "out of the box" or elegant way of doing this. Oh, for me, this was a daily task.

    Feel free to email me directly for more information if you'd like it.  martin.keen@nida.edu.au

    Martin

Reply
  • $organization

    Hi Maery

    I guess it depends on what sort of reporting you need. I've done this a couple of times - at a previous organisation and at my current one. A (very) brief overview of the 2 scenarios:

    1.  I was able to negotiate with Ticketmaster for them to provide the data in (basically) the right format to be able to use the Order Import utility. There was a little manual manipulation needed but, as a DBA, I used to import the data into a staging database, run a script and then import it into Tessitura.
    2. Our current 3rd party vendor won't do this but I am able to get a sales report that I can import into a local table

    Obviously, any reporting has to be custom. Sadly, there is no "out of the box" or elegant way of doing this. Oh, for me, this was a daily task.

    Feel free to email me directly for more information if you'd like it.  martin.keen@nida.edu.au

    Martin

Children