Adding order information to imported constituents

Hello,
Celebrity Series is a performance presentation company that uses several venues. We have our own box office and tickets we sell here, but we also give a portion of the tickets to sell at the venue, using their systems and ticket stock. After the performance we receive a list of patrons and their information (address, email, etc) from the venue, which we import using the Constituent Import Utility. However, the problem arises when we want to connect an imported patron with a particular performance. Order Imports have been ruled out because we get our financial information from the venue way before we get the list of patron names. I've considered using interests (which would have to be added manually,) attributes (which you can't have more than 1 of the same type), and lists (which you can't see on a patron profile.) Has anyone had any experience with third-party box office information? Help!

-Jane  

Parents
  • We use an attribute. You select the attribute type when running the report. Ours is the equivalent of “ticket sold at venue.” The value gets imported, so we list the fiscal year and title of show as the value to import.

     

    Lucie

     

    ______________________________
    Lucie Spieler
    IT Development and Training Manager

    FLORIDA GRAND opera

Reply
  • We use an attribute. You select the attribute type when running the report. Ours is the equivalent of “ticket sold at venue.” The value gets imported, so we list the fiscal year and title of show as the value to import.

     

    Lucie

     

    ______________________________
    Lucie Spieler
    IT Development and Training Manager

    FLORIDA GRAND opera

Children