Home Forums Event Espresso Premium Payment Calculation Issue

Payment Calculation Issue

Posted: January 12, 2021 at 8:34 pm


January 12, 2021 at 8:34 pm


I have an issue where a user is being presented with a different total when viewing their payment URL versus what I see on the back end.

This started when I accidentally applied a promotion on the backend to a user. Since there is no trash can option to remove a promotion from a user (which would be a nice enhancement), I added a refund of an equal dollar amount. In this scenario, the user also has a credit applied to the transaction which I added as a payment.

On the backend under the payment details, I see the refund and the payment. When the user clicks on the payment URL (registration-checkout) they only see the payment line item and not the refund line item. This causes their “Amount Owing” to be wrong by the amount of the refund. They actually owe more.

How can I correct this scenario and also fix the registration-checkout page which seems to have an issue?

Thank you!


January 12, 2021 at 8:40 pm

This reply has been marked as private.


  • Support Staff

January 13, 2021 at 6:34 am

Hi there,

That’s an odd one but I think I may know why this is happening, but unfortunately, not why it happened.

Are you comfortable using something like phpMyAdmin?


January 13, 2021 at 8:05 am

Greetings Tony,

It has been a while since I have used phpMyAdmin but I am comfortable with it and SQL. I work with MS SQL DBs as part of my “real” job.


  • Support Staff

January 13, 2021 at 9:24 am

Oh, ok, so this should be relatively straightforward for you tbh.

So what I think has happened here is the registration_payment record has the REG_ID value set to 0 (which isn’t expected).

The invoice pulls the payments from the transaction, SPCO pulls them from the registration object (because payments can be assigned to specific registrations) which is why you get 2 different results.

First, the data you need.

The registration ID for the reg this has happened on (Event Espresso -> Registrations -> {find the registration in the list and note the ID})

Go to the EE Transaction for the above reg and look in the payment section, note the ID for the refund ‘payment’ object and also the Transaction ID (TXN_ID)

Now in your DB look in {prefix}_esp_registration_payment

Select the rows where PAY_ID is payment object ID above, do you have just one row?

Is the REG_ID value set to 0 (or something other than the Reg ID for the registration above)?

If 0, update it to the correct REG_ID and then the checkout link, work now?

If its another ID, double-check that registration and confirm the PAY_ID is correct before updating that row.


January 13, 2021 at 6:29 pm

Greetings Tony,

Oddly enough there was no entry in the {prefix}_esp_registration_payment table at all. I saw one for the credit I applied, but not the refund.

After seeing this I deleted the refund and added it back and then the entry was present in the table. Now the payment screen shows the correct amount.

Odd but thank you for your help!


  • Support Staff

January 14, 2021 at 2:46 am

Yeah, that is odd.

I should have asked you to try deleting the payment first actually as if REG_ID was invalid (0) it would have then thrown an error stating the related registration object was invalid and not delete, then move onto the above.

Odd that you didn’t have a record at all, although it’s equally as odd to have REG_ID set to 0 if it had of been. If this continues to happen on other transactions please do let us know. I can’t reproduce but we can try adding some debugging code to your site to log the queries and go from there.

Anyway, for now, I’m glad your back up and running.

You must be logged in to reply to this support post. Sign In or Register for an Account

Support forum for Event Espresso 3 and Event Espresso 4.
Documentation for EE3 and EE4
Documentation for Event Espresso 3 Documentation for Event Espresso 4

Status: publish

Updated by  Tony 1 week, 4 days ago ago

Topic Tags


This topic is: resolved
Do NOT follow this link or you will be banned from the site!