[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?

[Jared]

Ugh… I gotcha. Thanks.

[Jared]

The additional plugin worked great! Thanks!
Joe

[Author]

Posts