• Replies 4 replies
  • Subscribers 358 subscribers
  • Views 34 views
  • Users 0 members are here
Related

All Purchasers List

Rob Munday
$organization

Working for a ticketing agency that sells for external events, one of the most regular tasks I have to perform is pulling a list of all purchasers for that event. This list will always have to contain:

  1. Order No
  2. Constituent name
  3. Constituent address
  4. Performance Name
  5. Number of Seats
  6. Price Type (preferably the name instead of the code)

Currently, I am performing an extraction, saving the results to a list and using a custom output set to export the results as an excel file. However, the file usually contains the complete ticketing history of the constituents that have booked for this event, instead of just their bookings for this particular event.

I am obviously doing something wrong, as I feel in Tessitura this should be a pretty standard operation to perform, but as I'm fairly new to the system I am unsure of the best way to do this.

If anyone can offer any advice on the best way to perform a task like this, it would be most MOST appreciated.

thanks in advance.

Rob

  • $organization

    Would the single sale order listing work for you?  You can run it for a single performance date or a date range.

  • $organization in reply to Boann Petersen

    Thanks for your reply.

    I've tried the single sales order listing, but couldn't get exactly what I wanted. The closest I've been able to come to the list I want is the 'Performance Seating Book' list but this means I can only select a single performance and the 'price type' information doesn't display as I would like.

  • $organization in reply to Boann Petersen

    Thanks for your reply.

    I've tried the single sales order listing, but couldn't get exactly what I wanted. The closest I've been able to come to the list I want is the 'Performance Seating Book' list but this means I can only select a single performance and the 'price type' information doesn't display as I would like.

  • Former Member
    Former Member $organization

    Rob,

     

    Have you looked at the Order Export Utility?  This report has the information you listed below but provides perf code instead of perf name along with a myriad of other information.  If you were to run this report with a list saved from order search you may be able to pull the information you are looking for.

     

    Be well,

    Jean

     

    From: Tessitura Next Generation Forum [mailto:forums-nextgeneration@tessituranetwork.com] On Behalf Of Rob Munday
    Sent: Tuesday, August 09, 2011 1:32 AM
    To: jeanr@sjrep.com
    Subject: [Tessitura Next Generation Forum] All Purchasers List

     

    Working for a ticketing agency that sells for external events, one of the most regular tasks I have to perform is pulling a list of all purchasers for that event. This list will always have to contain:

    1. Order No
    2. Constituent name
    3. Constituent address
    4. Performance Name
    5. Number of Seats
    6. Price Type (preferably the name instead of the code)

    Currently, I am performing an extraction, saving the results to a list and using a custom output set to export the results as an excel file. However, the file usually contains the complete ticketing history of the constituents that have booked for this event, instead of just their bookings for this particular event.

    I am obviously doing something wrong, as I feel in Tessitura this should be a pretty standard operation to perform, but as I'm fairly new to the system I am unsure of the best way to do this.

    If anyone can offer any advice on the best way to perform a task like this, it would be most MOST appreciated.

    thanks in advance.

    Rob




    You were sent this message automatically by www.tessituranetwork.com because you subscribed to the Tessitura Next Generation forum email notifications. You may reply to this message or visit the site to reply to the post above. If replying via email, please consider deleting the previous message text before sending to help with readability on the site. Thank you!