|
Joe Tartaglione
|
February 9, 2015 at 11:27 am
I have an event with almost 100 people registered. They were never shown the price on the front end. Originally they registered for tickets that were set to $250 and now I need to change the price to $285 before approving them, so that when they pay, they pay the new amount. I changed the price in the ticket section but it just created a new ticket. The previous registrants still show the old price next to them.
How do I raise their ticket price?
EE4 version 4.4.8.p
Mailchimp & Stripe Add-on
Wordpress 4.1
|
|
Garth
|
February 9, 2015 at 10:44 pm
Hi Joe,
That’s correct. To ensure the proper accounting is recorded, you cannot change the price of a ticket after it’s been registered. If you change the price of a ticket where registrations have been approved, another ticket will be created.
|
|
Joe Tartaglione
|
February 10, 2015 at 6:36 am
Ok so how do I raise their ticket price? Is there a way to export all the registrations and import them as new tickets? Can I edit the database? I need to find some way to make this change. Thanks.
|
|
Garth
|
February 10, 2015 at 3:58 pm
Hi Joe,
You can attempt to change the values in the database, but we don’t recommend it. Be sure to backup your database before making any changes.
|
|
Tony
|
February 10, 2015 at 4:28 pm
Hi Joe,
It is possible to change the values within the database, although it will involve editing multiple rows within multiple tables and will not be an easy task.
The tables wp_esp_price and wp_esp_ticket (wp_ being the default table prefix) store the ticket values. If you edit those tables tables you’ll find your ticket, identifiable using the ticket name for TKT_Name and PRC_Name.
You’ll need to edit those values to change to the ticket price within the event.
Next you’ll need to alter rows within wp_esp_line_item, each registration creates multiple rows (at least 6) so this will be the hardest part.
I have a few questions to help narrow down the rows to edit.
Are all of the registration using the same ticket?
Are all of the registration single ticket registrations?
Have you use the ‘not approved’ status for the attendees?
As this is not a feature of Event Espresso, I would advise creating a clone of the site and making edits there first, NOT on the live site without fully testing the changes you are making work as expected.
|
