Posted: August 31, 2023 at 8:58 am
I’ve got a custom summary page on my site that displays all the current available courses (events) we sell in a particular format. It’s working pretty well.
You can view it here: https://presencetraining.co.uk/courses/
The issue I’d now like to address is the “From £475+VAT” field, which is correctly picking up the lowest price ticket, but is failing to discount tickets that are no longer on sale.
My previous developers have coded the page to pull out the lowest price ticket for each course from the EE Database, but failed to filter out those tickets that have now expired.
I’d like to get a new developer to fix this issue, but I don’t know where to direct them to find the relevant data.
I.e. how can they find for each event I’m selling the lowest price ticket that currently still remains on sale (in other words ignoring tickets that are no longer on sale, or whose sale date has expired).
That way a customer can see at a glance what the lowest price ticket currently available is via my summary page.
Could anyone let me know where I can direct the developers to find this data please?
It depends on how the previous developer pulled in the tickets to display, if they used EE’s model system:
This should be relatively simple to do, if not, the new developers can follow the docs above to learn how the model system works (it allows you to pull in pretty much any data they may need and you can easily modify the query args to suit).
I remember seeing the code for that page but not the code itself, can you post it to a gist or pastebin? I’ll take a look.
You’re most welcome, Daniel 🙂
The support post ‘Displaying the price of the cheapest live ticket’ is closed to new replies.
Have a question about this support post? Create a new support post in our support forums and include a link to this existing support post so we can help you.