Total doesn’t add up

  • Resolved Graham Mandeno

    (@grahammandeno)


    7 years, 3 months ago

    Hi Malcolm

    I had someone today apparently pay too much for a reservation. He bought five Adult tickets @ $25 and one Senior @ $20, which should add to $145, but he paid $155. I was about to email him and tell him of his “mistake”, but I looked at his reservation email and it said total due was $155. Furthermore, I went into the SSG control panel and his sale looks like this:
    https://torbaytheatre.com/SSG-support-2017-11-28.png

    Notice there is no donation, yet the “Total Paid/Due” is $10 more than it should be.

    Can you think of an explanation for this?

    Cheers,
    Graham

Viewing 5 replies - 1 through 5 (of 5 total)
  • Plugin Author Malcolm

    (@malcolm-oph)

    Well, yes I think I can.

    A quick test on my trial server suggests that Donations added to a Reservation are being included in the EMail but not in the Sales record. So my guess is that your purchaser did make a donation of $10 (very generous of them) but it was not recorded in the database.

    I’ll do a bit more investigation and get back to you.

    Plugin Author Malcolm

    (@malcolm-oph)

    The code explicitly removes the donation amount from the sale record and the code to do so was added quite some time ago (23rd August 2014 v3.9.4 to be specific).

    Not too surprisingly I can’t remember why this change was added, and there’s not much further information in the change log, but I can’t see an reason why it shouldn’t be reversed. I’ll make that change and include it in my next release.

    Thread Starter Graham Mandeno

    (@grahammandeno)

    Hi Malcolm

    Thanks for your prompt response. I’ve taken a peek “under the hood” and it appears that donations are being recorded (in wp_sshow_sales.saleDonation) for “checkout” transactions, but not for reservations. However, the amount of the donation is included in wp_sshow_sales.salePaid for both.

    Incidentally, the saleDonation amount will also need to be available as a field to be included in the reservation email, otherwise the amounts won’t add up in the email.

    Cheers,
    Graham

    Plugin Author Malcolm

    (@malcolm-oph)

    That’s true. I’ve added the donation to all the templates.

    Plugin Author Malcolm

    (@malcolm-oph)

    Fixed in v6.6.2

Viewing 5 replies - 1 through 5 (of 5 total)
  • The topic ‘Total doesn’t add up’ is closed to new replies.