Support

Home Forums Event Espresso Premium Early registration discounted price not showing on [EVENT_LIST] page

Early registration discounted price not showing on [EVENT_LIST] page

Posted: February 1, 2015 at 2:41 am


Lucinda Dalrymple

February 1, 2015 at 2:41 am

I have two almost identical events. I have a $30 discount for early registration. The discounted price shows up on the [ESPRESSO_EVENTS] page, but not on the [EVENT_LIST] page.

Is there a way to get it to display the discounted price?

Registration Page: http://summerfunseattle.org/registration
Password: nufremmus
Recently upgraded EE from 3.1.36.1.P to 3.1.36.6.P
Event Espresso version 3.1.36.6.P
WordPress version WP 4.1
Installed plugins:
Admin Color Schemes by WordPress Core Team version 2.0,
Advanced Code Editor by BaInternet version 2.2.6,
All In One SEO Pack by Michael Torbert version 2.2.5.1,
Anything Popup by Gopi Ramasamy version 5.6,
Conditional Widgets by Jason Lemahieu and Kevin Graeme (Cooperative Extension Technology Services) version 2.0.5,
Contact Form 7 – Dynamic Text Extension by Chris Mavricos, SevenSpark version 1.2,
Contact Form 7 Honeypot by Dao By Design version 1.6.2,
Contact Form DB by Michael Simpson version 2.8.28,
Contact Form 7 by Takayuki Miyoshi version 4.1,
Duplicator by LifeInTheGrid version 0.5.12,
Easy FancyBox by RavanH version 1.5.7,
Easy Privacy Policy by Kevin Sparrow version 1.02,
Event Espresso – Attendee Mover Tool by Event Espresso version 1.1.b,
Event Espresso by Event Espresso version 3.1.36.6.P,
Really Simple CAPTCHA by Takayuki Miyoshi version 1.8.0.1,
Remove Widget Titles by Stephen Cronin version 1.0,
Shockingly Simple Favicon by matias s version 1.8.2,
Spectacu.la Page Widget by James R Whitehead of Spectacu.la version 1.0.7,
Site Plugin for summerfunseattle.org by Sparrow Web Design version 1.0,
TC Comment Out by Tracy Rotton version 1.2,
UpdraftPlus – Backup/Restore by UpdraftPlus.Com, DavidAnderson version 1.9.50,
WP Mail From II by Ben Huson version 1.0.2

Thanks!


Sidney Harrell

February 2, 2015 at 11:48 am

There is, but it involves customizing the event_list.php template file. You’ll want to copy event_list.php and event_list_display.php from plugins/event-espresso/templates int uploads/espresso/templates. This makes sure that your customizations don’t get overwritten by an update to EE core.
The problem is that in event_list.php, the query to fetch the events from the db is written to go fast, and just get one line per event. You can see it attach the price to the event here:
$sql .= " LEFT JOIN " . EVENTS_PRICES_TABLE . " p ON p.event_id=e.id ";
But pricing data is more complex than that, because it is a many-to-one relationship, so the only thing to do would be to take that join out of the main query, and write a second query for each event, inside the loop over events, to get the price data, and then a little massaging of the output in event_list_display.php to deal with the more complex data.


Lucinda Dalrymple

February 16, 2015 at 3:30 pm

OK, not stuff I know how to do.

How about if, instead of us having to edit core files, Event Espresso handles that kind of thing. It could, cor example, automatically display the early registration price instead of the regular price during early registration (maybe even display the regular price with a slash through it with the early registration price next to it), or at least give us an option which price to display.

I don’t like to have to edit files and risk either a)having them overwritten when EE is updated or, b)having to edit “child” files and risk losing out on functionality when the parent file gets updated.

This feature seems like a no-brainer. Why are we required to edit files to get this obvious functionality to work.


Sidney Harrell

February 16, 2015 at 8:04 pm

It was a performance trade off. If you have many events, and they each have many prices attached, then you have to do many queries of the database for every load of the event list. If you only retrieve one price per event, then you can retrieve the event list in one query.
Is there a reason you are not using EE4 or our hosted EventSmart solution? There we have done a lot of under the hood optimization that eliminates a lot of these problems.


Lucinda Dalrymple

February 16, 2015 at 9:10 pm

I don’t want everything up in the cloud because I don’t have the kind of control over it that I want, and our site has a custom theme that I’m guessing we couldn’t install on your cloud site. Additionally, my clients have only 2 events per year, both one after the right other (I’m not Lucinda, I’m their web designer, Jerri) and wouldn’t want to pay for EE on a monthly basis.

I also don’t know what the differences are between EE3 and EE4, and can’t find a simple feature comparison chart. Does EE4 have waitlisting? Or the price modifier plugin functionality? Can attendees be moved between events and have their payment information modified? What features might I lose if I move to EE4? And can the site be automatically and seamlessly moved, either with a migrate tool or just by updating EE?

If you can answer those questions, or point me to where I can find the answers I’ll look the info over and make a recommendation one way or the other to my clients.

Thanks.


Dean

February 19, 2015 at 6:50 am

Hi,

You can find a EE3 vs EE4 chart here: https://eventespresso.com/differences-ee4-ee3/

Does EE4 have waitlisting?

Not currently.

Or the price modifier plugin functionality?

Not via questions, though you can modify the ticket prices with price modifiers so you could add X price to one ticket but not another.

Can attendees be moved between events and have their payment information modified?

No and yes.

What features might I lose if I move to EE4?

You would be best checking here: https://eventespresso.com/differences-ee4-ee3/

And can the site be automatically and seamlessly moved, either with a migrate tool or just by updating EE?

There is a migration tool, simply disable EE3, install and activate EE4 and follow the prompts (always back up first!!)

Also, regarding the Early Bird Pricing, I made this for some one a while back (2 years now!) https://gist.github.com/Apina/c203ea36cf9e300e2230

It should still work, and while it still needs inserting into a template file, it’s relatively easy to do so. Screenshot http://take.ms/slZFN

The support post ‘Early registration discounted price not showing on [EVENT_LIST] page’ 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.

Event Espresso