Support

Home Forums Event Espresso Premium Updating Multiple Events with Early Discount

Updating Multiple Events with Early Discount

Posted: September 11, 2012 at 7:58 pm

Viewing 4 reply threads


scrair

September 11, 2012 at 7:58 pm

Can I update all my events within a certain date range (going forward from today) to include the early bird discount? I saw in the DB that the events_details table has the 3 fields to be updated, but wasn’t sure if there were additional tables it is hitting so I didnt want to attempt without asking first. If you have an easy way for me to do this, I would appreciate it. Thanks.


Dean

September 12, 2012 at 5:41 am

Hello

The best I can advise currently is that it wont work by just simply updating those three fields. It is linked elsewhere to actually enforce the deduction.

I will get back to you on this.


scrair

September 12, 2012 at 9:56 am

Thanks for the reply. I look forward to hearing if you have any options for me.


Dean

September 13, 2012 at 11:43 pm

Just to let you know, I havent forgotten you, I’m in discussion with the devs at the moment, will get back to you as soon as I get a response.


Dean

September 17, 2012 at 7:12 am

Hi,

I got a response from the devs on this.

It is possible to update it the fields in the database. You will need
to modify the wp_events_detail table though. Here is a screenshot of
the fields and format in PHPMyAdmin:
http://www.screencast.com/t/rTdt3lgmm93

Here is some SQL code that will update the entire database with the
data in the screenshot. The data should be changed to reflect their
needs: UPDATE wp_events_detail SET early_disc = ’50’,
early_disc_date = ‘2012-09-28’, early_disc_percentage = ‘Y’ WHERE
early_disc_date = ”

If they only want to update certain events, they use this for each
event. Just change the id field to the event id: UPDATE
wp_events_detail SET early_disc = ’50’, early_disc_date =
‘2012-09-28’, early_disc_percentage = ‘Y’ WHERE id = ‘2’

Hope that makes some sense and can help out a bit

Viewing 4 reply threads

The support post ‘Updating Multiple Events with Early Discount’ 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