buooy

Forum Replies Created

Viewing 4 posts - 1 through 4 (of 4 total)
  • Author
    Posts
  • in reply to: This is the MySQL code to delete tickets #55919
    buooy
    Participant

    To add on, if you ever need to “upgrade” your attendees, please use the following code. Basically it changes on ticket to another.

    Replace *YOUR*TICKET*SKU* with the ticket sku that you want to “upgrade” them to
    Replace *YOUR*TICKET*ID* with your ticket ID

    UPDATE events_postmeta
    JOIN (
    SELECT * FROM events_postmeta
    WHERE events_postmeta.meta_key = ‘_sku’
    AND events_postmeta.meta_value = ‘*YOUR*TICKET*SKU*’
    ) AS original
    SET events_postmeta.meta_value = original.post_id
    WHERE events_postmeta.meta_key = ‘_tribe_wooticket_product’
    AND events_postmeta.post_id = ‘*YOUR*TICKET*ID*’;

    in reply to: This is the MySQL code to delete tickets #55902
    buooy
    Participant

    The new status will be reflected. HOWEVER, the total sales and the quantity remaining will not be changed. Meaning that I could have one ticket hanging loose.

    It is also not reflected on the summary portion.

    If it cost $500, i could potentially be missing out on $500.

    in reply to: Extending Wootickets and multisites #55224
    buooy
    Participant

    Oh and when is the next release planned for?

    in reply to: Quite A Number of Things #55191
    buooy
    Participant

    Hi,

    My bad. I am actually using wootickets3.0!

    My tickets are html based and I have been sending them in HTML. That was the issue because there are no pdf tickets.

    Also, refunded tickets or deleted orders don’t decrease the qty_sold or increase the total sales meta value.

    Is there a function I’m missing

Viewing 4 posts - 1 through 4 (of 4 total)