CiviCRM Community Forums (archive)

We are using CiviEvents for a conference where we have 10 price fields (A to J) in the online registration form.  They are displayed on the registration page in order A through J, but when the selections are saved in the "Fee level" the order of the fields varies.  For example the order of the fields in 'Fee Level' in Peter's registration is ABCDEFGHIJ but for Mary's registration it is BACDFGHIJE and for John's registration it is BAFCDGHIJE.   About 95% of the registrations are saved in the order BACDFGHIJE which is the order the fields were created in.

The varying order makes life difficult if you want to export the participants with their fee levels and split the fee level field back into the price field components.  As the order of fields in  'Fee level'  seems to determine the order for both the on-line and off-line receipts, it is also confusing for registrants.

I have tried this out on the 3.4 demo site (as our website has a few peculiarities).  I created 5 price fields in order price 1 to price 5 then rearranged them in the price set to display in the registration form in order 13254.  I have registered 3 or 4 people so far and the 'Fee level' has the fields saved in the order 12345, ie the order they were created in, not the order they are displayed. Perhaps if I register more people I will get the irregularities I have seen on our website, but as it only happens on average once every 20 registrations I might have to register a lot of people to see it.

I think it would be best if the fields were saved in the order they are displayed, because presumably that is the logical way to present the data.  I could accept that they might have to be saved in the order they were created, but the irregular order of saving that is happening on our website is a real pain.  Has anyone else had this problem?

Thanks for your reply - not much that can be done if it is browser behaviour.

I don't have access to the tables directly.  I know I can get the detailed price set info through the custom search Price Set Details for Event Participants but that doesn't have any info on registration status (ie those who still haven't paid). 

We are in the process of moving from a proprietary CRM to CiviCRM.  Once the expense of the 'must-have' customisations is sorted, I am hoping we might have some money to be able to look at some "nice-to-have" additions to the report templates.