Support

Home Forums Event Espresso Premium Incorrect Tickets Sold Numbers

Incorrect Tickets Sold Numbers

Posted: July 10, 2018 at 11:26 pm


Ellimatta

July 10, 2018 at 11:26 pm

Hi,
I am having an issue with the tickets sold number displaying incorrectly and thus reporting an event as ‘sold out’ when it is not sold out.

For reference, this is not related to reserved tickets as there are none. To be completely certain of that, I have also cleared out the reserved ticket data in the maintenance area.

I also note that for some reason, in some cases the number of registrations reported is less than the number of tickets sold…?? how can this be possible when the smallest number of registrations for 1 ticket, is 1.
See screen shot of tickets here.

Two of the tickets report fewer registrations than tickets sold.

The first of which is reporting 10 tickets sold, but there are in fact only 8 – there should be 2 tickets left for sale.
here is a list of the registrations for this ticket

And likewise directly from the db – registrations

How is this happening and how do I fix it?

It looks to me like this value is coming from esp_ticket.TKT_sold value rather than the sum of all approved transactions or registrations. How is this value set and why would it be out of sync with actual transactions?


Tony

  • Support Staff

July 11, 2018 at 3:30 am

Hi there,

It looks to me like this value is coming from esp_ticket.TKT_sold value rather than the sum of all approved transactions or registrations. How is this value set and why would it be out of sync with actual transactions?

That’s correct, it’s in/decremented each time a registration is approved.

We’ve seen this happen with PayPal Standard and looking at your screenshots it looks like that is the payment method you have activated.

We’ve found if the PayPal IPN hits the site at exactly the same time as the user is returned to the site it can cause issues such as these and we have attempted to reduce this down to the smallest timeframe possible (we lock the transaction when either of the 2 hit the site) but apparently it can still happen.

A little while ago we replaced the PayPal Standard payment method in favour of the PayPal Express payment method to help prevent the issues with IPN’s, user’s who already use PayPal Standard can continue to do so but it does not show for new installs. I’d recommend switching the site to use that, it doesn’t use IPN’s and so doesn’t have the same problem and uses the same account type (just different credentials).

We have documentation on setting up PayPal Express here:

https://eventespresso.com/wiki/paypal-standard-payment-gateway/

To fix your current tickets you can either adjust the TKT_sold value to be the correct value in the DB, or adjust the limit set on the ticket to have he correct number of spaces available.


Ellimatta

July 11, 2018 at 6:52 am

Ok, thanks Tony.
I had a sneaking suspicion something like that might be happening.
I’ll just adjust the value in the db and look into PayPal Express.

Cheers,

The support post ‘Incorrect Tickets Sold Numbers’ 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.

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: closed

Updated by  Ellimatta 5 months ago ago

Topic Tags

Notifications

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