Support

Home Forums Event Espresso Premium Update price automatically at certain date

Update price automatically at certain date

Posted: November 13, 2013 at 4:56 pm

Viewing 15 reply threads


L33tdawg

November 13, 2013 at 4:56 pm

Hi guys,

We have a question relating to multiple price options that update base on registration date:

i.e.

early registration (before a certain date) == price 1
normal registration (after early but before late) == price 2
late registration (any date after the normal rate ends) == price 3
onsite registration (on event dates) == price 4

How do we set something like that up?


Tony

  • Support Staff

November 14, 2013 at 3:20 am

Hi,

Currently Event Espresso 3.X does not support multi date price discounts.

We have an ‘Early Registration Discount’ option which allows you to input a discount which will end on a certain date but this only allows for one date at a time so in effect you would need to update this manually for each price change.


L33tdawg

November 14, 2013 at 4:23 am

Thanks for the quick reply. So what happens in this sort of situation:

Attendee registers during early or normal period but doesn’t pay.
We change the pricing to late rate in the system. The user logs back in to make payment – how much would they have to pay? The original amount or the new amount? Is this done ‘automatically’ for unpaid reg’s?


Tony

  • Support Staff

November 14, 2013 at 7:04 am

They would pay the amount that was active at their time of registration.

So if they registered when an early discount was active, then paid 3 days after the early registration date ended. The payment amount due would still be the discounted amount.


L33tdawg

November 14, 2013 at 7:20 am

Is there a way to set it to the current price so they would have to pay the new rate when they come to retrieve their details? I’m guessing if they paid 30 days after registering, they would pay the price they received when registering? Is there a way to ‘invalidate’ unpaid invoices and generate a new invoice for registrants if they haven’t paid after a certain number of days?


L33tdawg

November 14, 2013 at 7:24 am

It doesn’t make much sense to have an ‘early bird discount’ if all that means is that people will register early but pay later especially if they STILL get the savings offered despite missing the early payment date. Where is the incentive for registrants to pay up early?


Tony

  • Support Staff

November 14, 2013 at 8:58 am

You can manually adjust the amount due for each attendee but currently there is no way to automatically adjust the amount owed at the end of the early payment date.

The other other option is to delete all Incomplete registrations on the date the discount finishes, which will result in a blank ‘Thank You’ page when the user tries to view the invoice.


L33tdawg

November 14, 2013 at 4:50 pm

If we manually adjust the amount for each attendee directly in MySQL by setting ‘amount due == new price where status == unpaid’, when attendees log back in, would they see the new amount in their invoice? Doing it via the admin interface one at a time is going to be a royal pain.


L33tdawg

November 14, 2013 at 4:53 pm

Does Event Espresso have an option of sending reminder emails to unpaid registrants? I.e. 48 hours before early registration ends (and early payments are due), an email can be sent to unpaid regs to remind them to make payment or they will be re-invoiced with the new amount?


Tony

  • Support Staff

November 15, 2013 at 5:09 am

Unfortunately not, Event Espresso 3.X does not currently offer Email Reminders, however it is possible to do this through the MailChimp Add-On and setting up a campaign to go out on that specific date.

You could update the payment status through MySQL, although there are 2 values you will need to change. Likely through 2 seperate queries.

Within the *prefix*_events_attendee table, the original ticket price is stored under ‘orig_price’ the discounted ticket would be ‘final_price’ and then there is also ‘total_price’ which is final_price multiple by the quantity field.

‘final_price’ would need to be modified to equal ‘orig_price’ then ‘total_price’ modified to match new price using either orig_price or final_price * the quantity field WHERE the event id == *event id* AND payment_status == ‘Incomplete’


L33tdawg

November 15, 2013 at 5:45 am

Thanks Tony – Can MailChimp be configured to send out reminders on a specific date to ONLY unpaid regs?


Tony

  • Support Staff

November 15, 2013 at 5:53 am

That’s a good point.

No it can not. It would send out an email to all users on that list/group, you can setup groups for specific events but that doesn’t take into account the payment status for the attendee so would likely not be useful in this case.


L33tdawg

November 15, 2013 at 6:06 am

Ahhhh okay – Are there any plans to add this features in? Things like price by date, invalidating invoices, sending payment reminders at a specific date etc etc?

It looks like we’re going to have to write up some ‘helper scripts’ to get the functionality we need in the meantime :\


Tony

  • Support Staff

November 15, 2013 at 6:44 am

Currently we are working on EE4 which is a major re-write of the plugin which will include new features and improvements.

Unfortunately I can’t comment on specific features at this time.


L33tdawg

November 15, 2013 at 6:56 am

Great. Any indication on when EE4 will be released?


L33tdawg

November 15, 2013 at 6:56 am

I’m guessing there’ll be a clear upgrade path for those moving from version 3 right?


Josh

  • Support Staff

November 15, 2013 at 11:18 am

Hi there,

We will announce a release timeframe when it’s close to being ready, and there will be an update path from 3.x.

Viewing 15 reply threads

The support post ‘Update price automatically at certain date’ 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