rjjacob

Forum Replies Created

Viewing 5 posts - 1 through 5 (of 5 total)
  • Author
    Posts
  • in reply to: Adding Event Date and Time to Order List in Admin #1632635
    rjjacob
    Participant

    Awesome. Thanks for putting this in front of your dev team. That’s more than I could’ve hoped for.

    You can close this one if you wish.

    in reply to: Adding Event Date and Time to Order List in Admin #1632134
    rjjacob
    Participant

    Thanks, Brendan. I get that this is not covered as support. I appreciate the answer and in case you guys reach a point where you might want to tinker with this, I’ve attached some screenshots to illustrate my request/issue. I don’t need a developer at this point – my client will take the info from the notification email and add it to their in-house ticketing software – but eventually this would be nice to have.

    The “ticket-description.png” shows what the tribe-ext-woo-order-templates plugin does for Woo email notifications when a ticket is the product and is created through the Event Tickets Plus plugin. Without this, the person notified of the sale and the person who purchased the ticket would not be able to tell at a glance for which event, event date and time the ticket is for. Quite confusing. I’m glad this plugin exists and puts this data in the emails!

    But…in the back-end in Woo Orders, this information is still not provided and doesn’t give a clue as to what the ticket is for. Only the ticket title and SKU is displayed. It takes several clicks through to see what Event ID this ticket is for. (“admin-order-details.png”)

    What would REALLY help, especially when there are several tickets created for one event and there are dozens or hundreds of events, would be to add the Event name and date/time to the Order Details in Woo. (“admin-order-line-item-revised.jpg”)

    In my case, we have 7 ticket types for each event and a couple hundred events, so the data was all imported by CSV. Had I known how important the SKU would be, I probably would’ve included the event name and date-time in it for reference but this modification would enable helpful data to be included, regardless of SKU or ticket title.

    Thanks for the opportunity to post this. You guys are great and your plugins work really well.

    in reply to: Event Tickets are Not Displaying #1630524
    rjjacob
    Participant

    Wow, that helped a lot! I really appreciate the time you spent on updating the import CSV and added those update queries. I had to modify the queries a bit because the post_id referenced in “_ticket_end_date” is actually the id for the *product* or individual ticket for a particular date and not the event post_id. But I worked that out, changed the update queries and got all the tickets into the database and displaying on the website.

    Now I need to figure out how to add the ticket event dates to the Woocommerce email templates because all that’s going out is the skus and those don’t mean anything to the ticket buyers. But I’ll look at the documentation first and create a new thread if necessary.

    in reply to: Event Tickets are Not Displaying #1629520
    rjjacob
    Participant

    I’m sorry, I just found what you were referring to in the “Advanced” section under each ticket. I was looking in the wrong place.

    Yes, the “End Sale” date was imported to be the same as the “Start Sale” date which was July 6, 2018, so all tickets are past the point of being for sale.

    I have 7 ticket types available for about 100 events = 700 tickets to be updated to the correct “order by” times. How can I import that?

    in reply to: Event Tickets are Not Displaying #1629502
    rjjacob
    Participant

    Yes, it is weird. I imported ticket info, ordering date ranges and other data by CSV. I noticed in the wp_postmeta table that meta_key event_orderby shows “meta_value” instead of the dates and times I imported for cut-off times to order tickets for particular event dates. Could that have something to do with it?

    When viewing the “Advanced” tab on tickets, there are no fields for start and end sale dates, either.

    What’s weird is that the tickets did show up originally and only recently have disappeared, as far as I can tell.

    Although I’m using the Duplicate post plugin, I haven’t used it for events. I imported them using the templates at your website.

    I’ve attached a dump of the posts/postmeta tables. The whole DB was too big. And the CSV I used to import ticket meta data, including prices, event dates, order by dates and times, IDs for the events they are FK’d to, etc.

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