Skip to content

Instantly share code, notes, and snippets.

Show Gist options
  • Select an option

  • Save maxrice/71d8c930d026aa780f38 to your computer and use it in GitHub Desktop.

Select an option

Save maxrice/71d8c930d026aa780f38 to your computer and use it in GitHub Desktop.
WooCommerce Customer/Order CSV Export - Add custom columns when using the legacy one row per item format
<?php
/**
*Additional columns for CSV Export
*/
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. for orders with multiple items this will include the same data for each item
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
);
$new_order_data = array();
foreach ( $order_data as $data ) {
$new_order_data[] = array_merge( $data, $custom_data );
}
return $new_order_data;
}
add_filter( 'wc_customer_order_csv_export_order_row', 'wc_csv_export_modify_row_data', 10, 2 );
@Garconis

Copy link
Copy Markdown

How do you move where these columns show?

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment