WooCommerce Customer/Order CSV Export: Add additional columns

woocommerce-customer-order-csv-export-add-additional-columns.php

<?php
// add custom column headers
function wc_csv_export_modify_column_headers( $column_headers ) { 
 
	$new_headers = array(
		'column_1' => 'Column 1',
		'column_2' => 'Column 2',
		// add other column headers here in the format column_key => Column Name
	);
 
	return array_merge( $column_headers, $new_headers );
}
add_filter( 'wc_customer_order_csv_export_order_headers', 'wc_csv_export_modify_column_headers' );

// set the data for each for custom columns
function wc_csv_export_modify_row_data( $order_data, $order ) {
 
	$custom_data = array(
		'column_1' => get_post_meta( $order->id, 'some_meta_key', true ),
		'column_2' => get_post_meta( $order->id, 'some_other_meta_key', true ),
		// add other row data here in the format column_key => data
	);
 
	return array_merge( $order_data, $custom_data );
}
add_filter( 'wc_customer_order_csv_export_order_row', 'wc_csv_export_modify_row_data', 10, 2 );

I'm no php wiz, but I can understand that code. However, I having a hard time displaying user meta data of the customer. So instead of a custom field i'd like to display user meta of the user who made the purchase.

'column_1' => get_user_meta( $order->id, 'some_meta_key', true ),
'column_2' => get_user_meta( $order->id, 'some_other_meta_key', true ),

Doesn't work. Any insights?

Thanks

How do you add custom meta keys from an ITEM that is part of the order? Example: I am using "Custom Format" where a row represents a single line item. Items within an order have _startdate set to them... but I'm having a hard time pulling in this custom meta key into the CSV Export.

davidmanson's example seems to pull in the item's CURRENT data... not the data that was captured during the order.

@mikeeman2000, did you ever figure that out? I'm looking to do the same.