Add Event Date and Ticket Time to Woocommerce Orders Page & CSV Export

[Sheldon]

Hi There,

I’m hoping you can help me finalize out setup of the Event Tickets Plus plugin.
For context – I have finished building a new site for our comedy club, and have successfully integrated the Events Calendar Pro and Events Ticket Plus plugins, working with Woocommerce and Moneris.

All events and subsequent tickets have been setup on the site and orders are processing correctly. The last gap we have is what is being displayed on the Woocommerce Orders page and in the CSV export.

I have setup each of the comedy acts with individual events, instead of recurring, so that we can add different showtimes and ticket pricing for each event, based on the day of the week. http://d.pr/i/1b6co

I’ve specified the showtime and ticket type in the ticket name field when creating an event. http://d.pr/i/O0vK

The issue now is that following a purchase, I don’t have either the event date displayed on the either the Woocommerce all orders page (see private screenshot in system info) – or on the Woocommerce individual order page (http://d.pr/i/9Nj2) . Additionally the event date and ticket name (time) is not available in the CSV report download provided by Woocommerce.

The above are crucial when reconciling with our internal reporting / accounting systems, as otherwise we would have to manually go through and identify the ticket type purchased and event date. Hopefully you guys can assist in helping to setup the above requirements or can let me know if there is a better way to approach this.

Thanks!

• This topic was modified 9 years, 8 months ago by Sheldon.

[Geoff B.]

Good evening Sheldon and welcome back!

Thank you for reaching out to us.
I would love to help you with this topic.

First of all I want to congratulate you on what you have achieved so far.
Very nice setup.

What you are looking to do would be a very cool feature.
In fact, you can suggest it or cast your vote on other features in our User Voice forum.

That being said, it is not currently a built-in feature.

I am pretty sure this could be accomplished via some template customization. Here are a couple of useful links for that:

1. http://stackoverflow.com/questions/13683162/woocommerce-show-custom-column
2. http://stackoverflow.com/questions/36446617/woocommerce-add-custom-columns-to-admin-orders-list-page/36453587

Additionally, but this is untested, perhaps a third-party plugin such as the following might prove to be helpful: https://www.admincolumns.com/woocommerce-columns/

Another alternative might be to look at more advanced WooCommerce reporting or order plugin.
There are quite a few and they typically offer a ton of options when it comes to orders export.

Let me know if that helps.

Have a great day!

Geoff B.

[Sheldon]

Hi Geoff,

Thanks for getting back to me.

I was able to get the columns added, but am struggling with getting the event date and showtime data to populate into the columns. I’ve got this so far:

add_filter( ‘manage_edit-shop_order_columns’, ‘MY_COLUMNS_FUNCTION’ );
function MY_COLUMNS_FUNCTION($columns){
$new_columns = (is_array($columns)) ? $columns : array();
unset( $new_columns[‘order_actions’] );

//edit this for you column(s)
//all of your columns will be added before the actions column
$new_columns[‘MY_COLUMN_ID_1’] = ‘Event Date’;
//stop editing

$new_columns[‘order_actions’] = $columns[‘order_actions’];
return $new_columns;
}

add_action( ‘manage_shop_order_posts_custom_column’, ‘MY_COLUMNS_VALUES_FUNCTION’, 2 );
function MY_COLUMNS_VALUES_FUNCTION($column){
global $post;
$data = get_post_meta( $post->ID );

//start editing, I was saving my fields for the orders as custom post meta
//if you did the same, follow this code
if ( $column == ‘MY_COLUMN_ID_1’ ) {
echo (isset($data[‘_EventStartDate’]) ? $data[‘_EventStartDate’] : ”);
}
//stop editing
}

The issue is I’m not sure how to grab the event date from the meta data and display it. Can you advise?

Additionally, I’m not sure this solution addresses the requirement to add event date to the Order landing page. Can you advise on this as well please?

Thanks,
Rob

[Geoff B.]

Good evening Sheldon,

Thank you for writing back.

Before we continue, just to set expectations, the scope of our support is mostly to get our customers started on the right track and to help them in case of issues.

We unfortunately do not provide complete support for customization.

With that in mind, you are not out of options. You can:

1. Hire one of our recommended customizers to do the customization for you.
2. Read our Themer’s guide to get a sense of how the different parts of our plugins live.
3. Take a look at our different functions here: https://theeventscalendar.com/functions/

Another idea that might meet all of your accounting / bookkeeping requirement is to combine reports in Excel (using a Macro). You could then combine:

1. WooCommerce’s built-in CSV reporting (or use one of the many advanced WooCommerce reporting plugins out there)
2. Our own built-in Sales and Attendees reports: https://theeventscalendar.com/knowledgebase/managing-your-orders-and-attendees/

I wish I had a better answer for you, but for now it’s the best one I have.

Let me know how that goes.

Best regards,
Geoff B.

[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