Counts off for Total Tickets Sold, Remaining, etc.

[Jared]

I’m hosting a large art retreat the end of April, with 50+ events and expecting 300-500 people.

My site is powered by WooCommerce.

Orders have come in as complete although PayPal didn’t finish the transaction. People clicked the Submit button multiple times, so they had 2-6 orders for the same tickets.

I Trashed Orders, refunded, etc. to get all the orders in sync with PayPal.

But that’s made the numbers for Total Tickets Sold, Complete, etc. useless. They are all out of sorts.

I’ve attached a few screen shots as examples. Dozens of the events are now like this:

Encaustic Mask Assemblages: Only 6 tickets were actually sold. The rest were in Trashed orders. The max for the event is 24. Showing “9 Sold” doesn’t make sense (doesn’t tie to the 6 listed as Tickets). Only 6 were sold. You’ll only find 6 Completed Orders (rest were Trashed and Trash was Emptied). 15 Seats max. So, there should be 9 remaining. Page says 18 Remaining.

Ancestor Art: Encaustic Story Collage: Only 2 tickets were actually sold. The rest were in Trashed orders. The max for the event is 24. Showing “9 Sold” doesn’t make sense (doesn’t tie to the 2 listed as Tickets). Only 2 were sold. You’ll only find 6 Completed Orders (rest were Trashed and Trash was Emptied). 15 Seats max. So, there should be 13 remaining. Page says 15 Remaining.

Art Journaling with PanPastels: Only 6 tickets were actually sold. The rest were in Trashed orders. The max for the event is 24. Showing “9 Sold” doesn’t make sense (doesn’t tie to the 6 listed as Tickets). Only 6 were sold. You’ll only find 6 Completed Orders (rest were Trashed and Trash was Emptied). 20 Seats max. So, there should be 14 remaining. – page says 18 Remaining.

The listing of tickets is correct. I’m not sure why the site isn’t just counting the listing and using that as SOLD and then subtracting that from the Max to get Remaining.

Do you have a script I can run to fix this mess?

How can I get SOLD to actually reflect the existing completed orders in Woo?

And then get the “Remaining” to reflect the max minus SOLD?

I’m way nervous I’m going to oversell these events because of oddities in how the site interprets SOLD and REMAINING.

Please advise!
Thanks!

[Andras]

This reply is private.

[Andras]

Hello again,

Sorry, I had to remove the images from the original post for data privacy reasons. Nonetheless, thanks again for reaching out with your issue. Let’s see what we can do about them.

I checked your descriptions and the screenshots and I need to ask a clarification.

E.g. Encaustic Mask Assemblages: […] The max for the event is 24. […] 15 Seats max.

What is the difference beween “max for the event” and “seats max”?

As for the stats on this event: 24 max stock, 6 sold => 18 remains. That’s what is there.

Deleted attendees: 3. So the 3 deleted plus the 6 in the list (actually sold) adds up to the Total tickets sold: 9

 

Art Journaling with PanPastels

Some of the numbers here do see jumbled a bit. But again the 24 max stock, 6 sold => 18 remains seems OK.

 

Ancestor Art: Encaustic Story Collage

Yes, this seems totally off.

 

Here’s something you can check while I run some tests and dig a bit further into this:

Go to the WooCommerce product page of the tickets and check there the inventory -> stock quantity of the product, and check the “total_sales” in the custom fields. Do these seem right? You can modify them here manually if needed. Also check if they match with the stats on the event admin page.

Let me know if anything comes up.

Cheers,
Andras

[Jared]

Let me try to clarify the problem – Total Tickets Sold does NOT reflect the real number of tickets sold.

Here’s what happened:
A customer places an order
They don’t wait for PayPal to respond and click the Submit button again
2 orders come in to WordPress (Woo Commerce)
There should be only 1 order (since they really only paid one time)
You TRASH the order, Empty the Trash.

The right number of tickets are listed on the event.
But the Total Tickets Sold is off by one

Screen shot has an example:

This event had Stock = 20
Someone (Sue) accidentally had two orders come in
I Trashed one of those orders and emptied the trash

Now look at the Event.
In the bottom part it shows 5 tickets – that’s good
Sue is only in there once – that’s good
It says 15 remaining – that’s good – because 20-5 is 15
It says “6 Sold” and “Total Tickets Sold 6” and “Complete 6” – WRONG

There are only 5 ticket sales for this
There are only 5 orders in WooCommerce (each ordering a single ticket for this event)

If I look at the orders, there are 5
Each has 1 of these tickets in the order
WooCommerce shows 5 of these were purchased
If you look at the “Customers who bought this product” report (2nd screen shot) it shows 5

So, WooCommerce shows 5 sold
The list of tickets shows 5 people
Just the “Sold” counts at the top of the page are off

So, the problem is what Tickets Plus has for the value of “Sold”

I’m guessing Tickets got “confused” when an order was trashed.

I’m OK with that if I knew how/where to go in and fix that number by hand (i.e., change 6 to 5).

If I have to, I’m OK doing it directly in the MySQL database – but I don’t know where

I’m guessing, whatever code calculates that “Sold” number isn’t really looking at orders and adding them up correctly. Maybe it only counts when an order comes in and doesn’t know to decrement counts when an order is Trashed.

Does this clarify the problem?

[Andras]

Jared,

Thank you for the repeated detailed explanation. That was mighty helpful!

Although I cannot click the “Place order” button twice (after one click the button, actually the screen gets disabled so there is no way to click on it – I guess that might be a theme feature), this is what I did.

• Create event and create a WooCommerce ticket with a stock of 10.
• Go to front end and make 2 separate purchases with payment on delivery.
• The 2 purchases get registered and are marked completed
• On the orders page I delete one purchase and then remove it from the trash.
• I can confirm that the tickets sold remains 2.
• I went to the event edit page, scrolled down to the ticket and clicked “Edit in WooCommerce” (https://cloudup.com/cukrZ6eC8DS – the screenshot already shows the corrected sold amount)
• On the WooCommerce edit product page I scrolled to the Custom Fields, where total_sales show 2 rightfully, as 2 purchases went through. (https://cloudup.com/cz3_LGGUixt)
• Change this value to 1 (or whatever you need) and update the product
• Check on the Event Attendees page if the change is correctly reflected (https://cloudup.com/cfP9QZVpqpV)

Please check this and let me know if this helps / solves it.

Cheers,
Andras

[Support Droid]

Hey there! This thread has been pretty quiet for the last three weeks, so we’re going to go ahead and close it to avoid confusion with other topics. If you’re still looking for help with this, please do open a new thread, reference this one and we’d be more than happy to continue the conversation over there.

Thanks so much!
The Events Calendar Support Team

[Author]

Posts