Sorting Ticket Types in CRM

Lisa 2 · January 2010

Is there a way to change the display order of the ticket types in an event listing. It appears the default is to list them by ticket cost in an ascending order. In my situation, this does not make sense. Thanks in advance.

Noah Cooper · January 2010

There is a Site Option, CAL_TICKET_CLASS_SORT_ASC, which controls whether to sort in ascending (TRUE) or descending (FALSE) order by price. Note that changing this Site Option will affect all Events across your site.

Lisa 2 · January 2010

Noah Cooper:
There is a Site Option, CAL_TICKET_CLASS_SORT_ASC, which controls whether to sort in ascending (TRUE) or descending (FALSE) order by price. Note that changing this Site Option will affect all Events across your site.

Is there a way to sort it by the ordered they were created in and not by price.

If you look at my event, you can see why the price ordering structure doesn't make sense:

https://secure3.convio.net/ttor/site/Ticketing?view=Tickets&id=101281&JServSessionIdr004=64l9r2bqa4.app331a

Noah Cooper · January 2010

Lisa :
Is there a way to sort it by the ordered they were created in and not by price.

If you look at my event, you can see why the price ordering structure doesn't make sense:

https://secure3.convio.net/ttor/site/Ticketing?view=Tickets&id=101281&JServSessionIdr004=64l9r2bqa4.app331a

Unfortunately, no -- Ticket Classes can only be sorted by price. There is a feature request open with Convio's Product Management team to add the ability to sort the tickets in any order. For now, the only possibility for re-sorting the Ticket Classes would be to use JavaScript to move the table rows around once the page has loaded. If you can tell me the order you'd like the tickets to appear, I should be able to help write such a script.

Noah Cooper · January 2010

Noah Cooper:
Unfortunately, no -- Ticket Classes can only be sorted by price. There is a feature request open with Convio's Product Management team to add the ability to sort the tickets in any order. For now, the only possibility for re-sorting the Ticket Classes would be to use JavaScript to move the table rows around once the page has loaded. If you can tell me the order you'd like the tickets to appear, I should be able to help write such a script.

Here's an example of some JavaScript that should do the trick. You can drop this in an HTML Caption question on the Event. Change the order as you see fit (in this example, it's in the order 7, 5, 6, 3, 4, 1, 2).



<script type="text/javascript">
addOnLoadHandler(function(){
     var i;
     var allTables=document.getElementsByTagName('table');
     for(i in allTables){
          if(allTables.className&&allTables.className=='lc_Table')
               //re-sort ticket classes in order 7, 5, 6, 3, 4, 1, 2
               //row 0 will always be first, and row 8 will always be last
               reSortTicketClasses(allTables,'7','5','6','3','4','1','2');     
     }
});
function reSortTicketClasses(ticketClassTable,a,b,c,d,e,f,g){
     var ticketClassRows=ticketClassTable.getElementsByTagName('tr');
     var ticketClassRow1=ticketClassRows;
     var ticketClassRow2=ticketClassRows;
     var ticketClassRow3=ticketClassRows;
     var ticketClassRow4=ticketClassRows;
     var ticketClassRow5=ticketClassRows;
     var ticketClassRow6=ticketClassRows;
     var ticketClassRow7=ticketClassRows;
     if(ticketClassRows)
          var ticketClassRow8=ticketClassRows;
     ticketClassTable.appendChild(ticketClassRow1);
     ticketClassTable.appendChild(ticketClassRow2);
     ticketClassTable.appendChild(ticketClassRow3);
     ticketClassTable.appendChild(ticketClassRow4);
     ticketClassTable.appendChild(ticketClassRow5);
     ticketClassTable.appendChild(ticketClassRow6);
     ticketClassTable.appendChild(ticketClassRow7);
     if(ticketClassRows)
          ticketClassTable.appendChild(ticketClassRow8);
}
</script>

Lisa 2 · January 2010

Noah Cooper:

Here's an example of some JavaScript that should do the trick. You can drop this in an HTML Caption question on the Event. Change the order as you see fit (in this example, it's in the order 7, 5, 6, 3, 4, 1, 2).



<script type="text/javascript">
addOnLoadHandler(function(){
     var i;
     var allTables=document.getElementsByTagName('table');
     for(i in allTables){
          if(allTables.className&&allTables.className=='lc_Table')
               //re-sort ticket classes in order 7, 5, 6, 3, 4, 1, 2
               //row 0 will always be first, and row 8 will always be last
               reSortTicketClasses(allTables,'7','5','6','3','4','1','2');     
     }
});
function reSortTicketClasses(ticketClassTable,a,b,c,d,e,f,g){
     var ticketClassRows=ticketClassTable.getElementsByTagName('tr');
     var ticketClassRow1=ticketClassRows;
     var ticketClassRow2=ticketClassRows;
     var ticketClassRow3=ticketClassRows;
     var ticketClassRow4=ticketClassRows;
     var ticketClassRow5=ticketClassRows;
     var ticketClassRow6=ticketClassRows;
     var ticketClassRow7=ticketClassRows;
     if(ticketClassRows)
          var ticketClassRow8=ticketClassRows;
     ticketClassTable.appendChild(ticketClassRow1);
     ticketClassTable.appendChild(ticketClassRow2);
     ticketClassTable.appendChild(ticketClassRow3);
     ticketClassTable.appendChild(ticketClassRow4);
     ticketClassTable.appendChild(ticketClassRow5);
     ticketClassTable.appendChild(ticketClassRow6);
     ticketClassTable.appendChild(ticketClassRow7);
     if(ticketClassRows)
          ticketClassTable.appendChild(ticketClassRow8);
}
</script>

Thank you so much for your help on this. I will give it a try. Thanks again.

Lisa

Lisa 2 · January 2010

Lisa :
Thank you so much for your help on this. I will give it a try. Thanks again.

Lisa

Hi Noah,

I have added another ticket type and therefore, the javascript you created will need to be changes. I tried to alter it but, it doesn't seem to be working. I guess I am not sure what the numbers are referring to. Thanks

Lisa

Noah Cooper · January 2010

Lisa :
Hi Noah,

I have added another ticket type and therefore, the javascript you created will need to be changes. I tried to alter it but, it doesn't seem to be working. I guess I am not sure what the numbers are referring to. Thanks

Lisa

Lisa,

Can you tell me the order you want the tickets in?

Lisa 2 · January 2010

Noah Cooper:
Lisa,

Can you tell me the order you want the tickets in?

For this form, I would like it in this order:

https://secure3.convio.net/ttor/site/Ticketing?view=Tickets&id=101401

Camper Registration - Trustees Member

Second Camper Registration - Trustees Member

Camper Registration - Nonmember

Second Camper Registration - Nonmember

Deposit only

Before Childcare

Trustees Family Membership

For this form: https://secure3.convio.net/ttor/site/Ticketing?view=Tickets&id=101441

Camper Registration - Trustees Member

Second Camper Registration - Trustees Member

Camper Registration - Nonmember

Second Camper Registration - Nonmember

Deposit only

Before and After Childcare

Before or After Childcare

Trustees Family Membership

Thank you so much!

Lisa

Noah Cooper · January 2010

Lisa :
For this form, I would like it in this order:

https://secure3.convio.net/ttor/site/Ticketing?view=Tickets&id=101401

Camper Registration - Trustees Member

Second Camper Registration - Trustees Member

Camper Registration - Nonmember

Second Camper Registration - Nonmember

Deposit only

Before Childcare

Trustees Family Membership

For this form: https://secure3.convio.net/ttor/site/Ticketing?view=Tickets&id=101441

Camper Registration - Trustees Member

Second Camper Registration - Trustees Member

Camper Registration - Nonmember

Second Camper Registration - Nonmember

Deposit only

Before and After Childcare

Before or After Childcare

Trustees Family Membership

Thank you so much!

Lisa

Lisa,

I went ahead and updated the JavaScript on these two events. The numbers in the reSortTicketClasses function refer to the original position of the rows in the table. So on https://secure3.convio.net/ttor/site/Ticketing?view=Tickets&id=101441 I've set it to:


reSortTicketClasses(allTables,'7','5','8','6','3','2','1','4');

Lisa 2 · January 2010

Noah Cooper:
Lisa,

I went ahead and updated the JavaScript on these two events. The numbers in the reSortTicketClasses function refer to the original position of the rows in the table. So on https://secure3.convio.net/ttor/site/Ticketing?view=Tickets&id=101441 I've set it to:
reSortTicketClasses(allTables,'7','5','8','6','3','2','1','4'); 

Thanks for your help. It looks great on the forms that I sent you but, now the original form:

https://secure3.convio.net/ttor/site/Ticketing?view=Tickets&id=101521

Seems to have changed.

I guess this is a case when you fix oen thing, it breaks another.

Noah Cooper · January 2010

Lisa :
Thanks for your help. It looks great on the forms that I sent you but, now the original form:

https://secure3.convio.net/ttor/site/Ticketing?view=Tickets&id=101521

Seems to have changed.

I guess this is a case when you fix oen thing, it breaks another.

Can you tell the order for this form?

Lisa 2 · January 2010

Noah Cooper:
Can you tell the order for this form?

It is the same as the others. Thanks

Noah Cooper · January 2010

Lisa :
It is the same as the others. Thanks

The reason it wasn't working on this Event was that the "Include this Question" checkbox on the HTML Caption was unchecked. I checked it and it's working. Note that all of the other questions on that Event are unchecked as well.

Lisa 2 · January 2010

Noah Cooper:
The reason it wasn't working on this Event was that the "Include this Question" checkbox on the HTML Caption was unchecked. I checked it and it's working. Note that all of the other questions on that Event are unchecked as well.

Thanks for your help. I have activated those questions now. Thanks again.

Lisa

Lisa 2 · February 2010

Lisa :
Thanks for your help. I have activated those questions now. Thanks again.

Lisa

Hi Noah,

I have 2 more quick questions in regards to this posting. Is there anyway to have the table below this one match the same order and it appears the color banding is off in the top table since we resorted the rows? Thanks again.

Lisa

Sorting Ticket Types in CRM

Comments

Categories