Support

Home Forums Event Espresso Premium More sold than available

More sold than available

Posted: May 9, 2019 at 6:23 pm


Michael

May 9, 2019 at 6:23 pm

Hi, my set up is as follows:
– Tickets sold with payments using stripe and invoice.
– With both payment methods, both get status of approved.

I have an event which has 20 tickets available. It shows 26 sold:

https://www.evernote.com/l/APefzdkBjWtLwYxnMrWzUQ1anOxO8qH1Wd4

This is the only event out of 25 that has this issue.

When looking at the overall, the admin lists as 27 (not 26).

https://www.evernote.com/l/APf5KJ-uqMlDYK_OmvHup_C7Aiow8oSrhLw

When filtering by Approved for this event, it also shows 27:

https://www.evernote.com/l/APd8XwKTpslGTqK2IutCDj7UfX2q-j0siKc

All events have a limit (varies). After the limit is reached, we are using the Wait List module.

How can more than available tickets be ‘sold’ (approved, Stipe & Invoice).

We have limited space for the events so this is a huge issue.

Please advise.

Thank you!


Tony

  • Support Staff

May 10, 2019 at 4:44 am

Hi there,

With the waitlist add-on, are you manually promoting users or are they automatically promoted?

Have users been promoted from waitlist to pending payment at all on the above event?


Michael

May 13, 2019 at 3:42 pm

Hi!

With the waitlist add-on, are you manually promoting users or are they automatically promoted?

No, we have not utilized the plugin yet to manually promote users. We are at this state just collecting wait list registrants. The wait list module settings are the same for all events.

Have users been promoted from waitlist to pending payment at all on the above event?

No, we have not used the wait list manager to promote anyone.

I look forward to your reply. Of all the issues we’ve had so far, this is probably the most important one due to limited space.

Thank you!


Michael

May 13, 2019 at 6:16 pm

Hi again, it seems we have the issue with another event. This time Its not related to any 503 errors. Those were triggered by the number of people hitting the server, the ‘rush’ has passed.

https://www.evernote.com/l/APdCsYuHPaJJLorHQKkbS3idxhvlfTvX1is

This event has 36 sold, but the ticket only has 35 available and 35 tickets sold. This new registration happened today.

Thanks!


Michael

May 14, 2019 at 6:14 pm

Hi, so we need to figure out the best way to address this issue. The event is oversold by 7 tickets (space is limited).

-We have turned off automatic promotion on the waitlist.
-We added 7 reserved slots on the wait list.

https://www.evernote.com/l/APefm8fhkD1Cw4l5iDYTtjN_2v0rJ8AQ0QY

What we would like to do:

1- Take the last 7 people who registered and move them to the waiting list.
2- Have those 7 people move to the top of the wait list so if a spot opens, they will be the first to register.

Can you let me know what steps we can take to achieve the above?

Also, the post above this one is a related issue but a different event. IF you dont mind addressing both on a follow up.

Thank you so much!!!


Tony

  • Support Staff

May 15, 2019 at 4:27 am

Ok, lets break this down some:

Hi, my set up is as follows:
– Tickets sold with payments using stripe and invoice.
– With both payment methods, both get status of approved.

Ok, so you are using a ‘Default Registration Status’ of Approved on all events?

I have an event which has 20 tickets available. It shows 26 sold:

https://www.evernote.com/l/APefzdkBjWtLwYxnMrWzUQ1anOxO8qH1Wd4

Each time a registration is Approved, that value is incremented.

Each time a registration is changed from being Approved to something else, that value is decremented.

So whilst that number should be accurate, it’s not a ‘live’ count as such in that it’s not querying the database to pull all of the registrations and then counting the returned values, its simply pulling that value from the DB.

When looking at the overall, the admin lists as 27 (not 26).

https://www.evernote.com/l/APf5KJ-uqMlDYK_OmvHup_C7Aiow8oSrhLw

That value is a ‘live’ count of ‘Approved’ registrations.

Meaning when you load the events page, it pulls any registrations that have a status of Approved on the event and counts the rows returned.

So this is the number of ‘Approved’ registrations on your event.

When filtering by Approved for this event, it also shows 27:

https://www.evernote.com/l/APd8XwKTpslGTqK2IutCDj7UfX2q-j0siKc

Note that clicking on the link will actually show you all of the registrations on the event, if you have some that are pending payment, they will show up on that table.

No, we have not utilized the plugin yet to manually promote users. We are at this state just collecting wait list registrants. The wait list module settings are the same for all events.

?? I’m not sure I follow this answer. You don’t show any of the promotion settings above.

The reason I asked if registration have been promoted is if you manually promote waitlist registrations to pending payment then ALL of those promoted registrations are able to pay, even if there was only a single ‘space’ available when you promoted them.

Your next answer clarified that though:

No, we have not used the wait list manager to promote anyone.

Ok, Thank you.

Hi again, it seems we have the issue with another event.

Whilst the problem may well be the same, jumping between different events is going to confuse things, so it’s better to work on a single event to narrow down the problem than work through any others that may have the same issue.

So, on the event with 27 approved registrations if you look at the time stamp for the registrations were they all within a relatively short amount of time or are they spread out?

What we would like to do:

1- Take the last 7 people who registered and move them to the waiting list.
2- Have those 7 people move to the top of the wait list so if a spot opens, they will be the first to register.

Can you let me know what steps we can take to achieve the above?

This I’m going to need to do some digging into to see if it’s possible and will post shortly.


Michael

May 15, 2019 at 4:33 pm

Hi, my set up is as follows:
– Tickets sold with payments using stripe and invoice.
– With both payment methods, both get status of approved.
Ok, so you are using a ‘Default Registration Status’ of Approved on all events?

Yes, wether they pay thought stripe or use invoice, their status is automatically set to Approved.

So, on the event with 27 approved registrations if you look at the time stamp for the registrations were they all within a relatively short amount of time or are they spread out?

All 27 registrations happened in a 18 minute span.

Thank you for checking into this.

I have a new issue and I will start a new thread.


Tony

  • Support Staff

May 16, 2019 at 3:38 pm

All 27 registrations happened in a 18 minute span.

Hmm, then you may have multiple registrations all starting the process at pretty much the exact same time.

Do you have a group of registrations all showing the same time within the ‘Reg Date’ field when viewing the registrations?

Thank you for checking into this.

Looks like the waitlist auto promotion is based on the Reg ID ASC, meaning if space becomes available the ‘lowest’ ID of waitlist registrations will be the next one promoted.

I’ve requested some feedback to confirm this is the case before moving forward.

Another option is to manually promotion the registration(s) if a space becomes available, the admin can then select the correct registrant to promote.


Michael

May 24, 2019 at 12:08 pm

Hi Tony, any update on this ticket? Thank you!


Tony

  • Support Staff

June 5, 2019 at 5:51 am

Hi Michael,

My apologies for the delay, I checked and the waitlist registrations are ordered by Reg ID ASC meaning if you set the ‘last’ X number of registrations to waitlist they should be promoted in the order they registered.

Meaning Reg ID 98, 99, 100 would be promoted in that order if they were set to Waitlist registrations and a space opened up, although again, doing this is a little unexpected, so you may be better manually controlled the spaces and promoting the registrations manually in this case.


Michael

June 12, 2019 at 7:42 pm

Thank you for all your help Tony! I will pass this information to my client.

The support post ‘More sold than available’ 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