Add New Fields

You can create new field via user interface too.

For example, I want to export string like “Rain x 4, Lemon x 2, Other product x Qty”,
so I create field using meta key “all_products”

and put following code to section “Misc Settings”

add_filter('woe_get_order_value_all_products',function ($value, $order,$fieldname) {
	$lines = array();
	foreach($order->get_items() as $item) {
		$lines[] = $item["name"]. " x " .$item["qty"];
	}
	return join(",  ",  $lines);
},10,3);

add_filter('woe_get_order_value_all_products',function ($value, $order,$fieldname) {

$lines = array();

foreach($order->get_items() as $item) {

$lines[] = $item["name"]. " x " .$item["qty"];

}

return join(", ", $lines);

},10,3);

// export 2  shipping methods as separate columns
// you should add keys - shipping_name_1 shipping_name_2 shipping_cost_1 shipping_cost_2
add_filter( "woe_fetch_order", function($row, $order ) {
$i = 1;
foreach ( $order->get_items('shipping') as $item_id=>$item ) {
    if( !isset( $row["shipping_name_".$i]) ) continue;
    $row["shipping_name_".$i] = $item->get_name();
    $row["shipping_cost_".$i] = $item->get_total();
    $i++;
}
return $row;
},10,2);

// export 2 shipping methods as separate columns

// you should add keys - shipping_name_1 shipping_name_2 shipping_cost_1 shipping_cost_2

add_filter( "woe_fetch_order", function($row, $order ) {

$i = 1;

foreach ( $order->get_items('shipping') as $item_id=>$item ) {

if( !isset( $row["shipping_name_".$i]) ) continue;

$row["shipping_name_".$i] = $item->get_name();

$row["shipping_cost_".$i] = $item->get_total();

$i++;

}

return $row;

},10,2);

Extra custom fields, meta key must be added via UI, see exact name in code!

//export current date, add meta key "current_date"
add_filter('woe_get_order_value_current_date',function ($value, $order,$fieldname) {
return current_time("Y-m-d");
},10,3);

//export current date, add meta key "current_date"

add_filter('woe_get_order_value_current_date',function ($value, $order,$fieldname) {

return current_time("Y-m-d");

},10,3);

//export Shipping Zone, add meta key "zone_name"
add_filter('woe_get_order_value_zone_name',function ($value, $order,$fieldname) {
  $methods = $order->get_items( 'shipping' );
  $method  = reset( $methods ); // take first entry
  if ( ! empty( $method ) ) {
        $zone  = WC_Shipping_Zones::get_zone_by('instance_id',$method['instance_id']);
        $value  = $zone->get_zone_name();
  }
  return $value;
},10,3);

//export Shipping Zone, add meta key "zone_name"

add_filter('woe_get_order_value_zone_name',function ($value, $order,$fieldname) {

$methods = $order->get_items( 'shipping' );

$method = reset( $methods ); // take first entry

if ( ! empty( $method ) ) {

$zone = WC_Shipping_Zones::get_zone_by('instance_id',$method['instance_id']);

$value = $zone->get_zone_name();

}

return $value;

},10,3);

//export Geolocation Country, add meta key "geolocation_country"
add_filter('woe_get_order_value_geolocation_country',function ($value, $order,$fieldname) {
	$user_ip_address = $order->get_customer_ip_address();
	$geolocation_instance = new WC_Geolocation();
	$user_geolocation = $geolocation_instance->geolocate_ip( $user_ip_address );
	$value =  $user_geolocation['country'];
	return $value;
},10,3);

//export Geolocation Country, add meta key "geolocation_country"

add_filter('woe_get_order_value_geolocation_country',function ($value, $order,$fieldname) {

$user_ip_address = $order->get_customer_ip_address();

$geolocation_instance = new WC_Geolocation();

$user_geolocation = $geolocation_instance->geolocate_ip( $user_ip_address );

$value = $user_geolocation['country'];

return $value;

},10,3);

// Pimwick Gift Card, add meta keys "card_number" and "amount_redeemed"
add_filter( "woe_fetch_order", function($row, $order ){
	foreach( $order->get_items( 'pw_gift_card' ) as $order_item_id => $line ) {
		$row["card_number"] = $line->get_card_number();
		$row["amount_redeemed"] = $line->get_amount();
	}
	return $row;
},10,2);

// Pimwick Gift Card, add meta keys "card_number" and "amount_redeemed"

add_filter( "woe_fetch_order", function($row, $order ){

foreach( $order->get_items( 'pw_gift_card' ) as $order_item_id => $line ) {

$row["card_number"] = $line->get_card_number();

$row["amount_redeemed"] = $line->get_amount();

}

return $row;

},10,2);

// export ATUM supplier, add meta key "atum_supplier"
add_filter('woe_get_order_product_value_atum_supplier', function ($value, $order, $item, $product,$item_meta) {
	if($product AND  class_exists("Atum\Inc\Helpers") ) {
		$product = Atum\Inc\Helpers::get_atum_product( $product->get_id() );
		$supplier_id = $product->get_supplier_id();
		if ( $supplier_id ) {
			$supplier_post = get_post( $supplier_id );
			if ( $supplier_post ) 
				$value = $supplier_post->post_title;
		}
	}
	return $value;
}, 10, 5);

// export ATUM supplier, add meta key "atum_supplier"

add_filter('woe_get_order_product_value_atum_supplier', function ($value, $order, $item, $product,$item_meta) {

if($product AND class_exists("Atum\Inc\Helpers") ) {

$product = Atum\Inc\Helpers::get_atum_product( $product->get_id() );

$supplier_id = $product->get_supplier_id();

if ( $supplier_id ) {

$supplier_post = get_post( $supplier_id );

if ( $supplier_post )

$value = $supplier_post->post_title;

}

return $value;

}, 10, 5);

// export the name and role of the user that created the Phone Order
// add meta keys "po_creator_name" ,  "po_creator_role"
add_filter( "woe_fetch_order", function($row, $order){
 $creator_id = $order->get_meta("_wpo_order_creator");
 if( $creator_id AND ( isset($row['po_creator_name']) OR isset($row['po_creator_role']) ) )
 {
  $user_info = get_userdata($creator_id);
  if($user_info AND isset($row['po_creator_name']))
   $row['po_creator_name'] = $user_info->display_name;
  if($user_info AND isset($row['po_creator_role']))
   $row['po_creator_role'] = implode(', ', $user_info->roles);
 }
 return $row;
},10,2);

// export the name and role of the user that created the Phone Order

// add meta keys "po_creator_name" , "po_creator_role"

add_filter( "woe_fetch_order", function($row, $order){

$creator_id = $order->get_meta("_wpo_order_creator");

if( $creator_id AND ( isset($row['po_creator_name']) OR isset($row['po_creator_role']) ) )

{

$user_info = get_userdata($creator_id);

if($user_info AND isset($row['po_creator_name']))

$row['po_creator_name'] = $user_info->display_name;

if($user_info AND isset($row['po_creator_role']))

$row['po_creator_role'] = implode(', ', $user_info->roles);

}

return $row;

},10,2);

Some samples for adding fields via code

// add order field "Order Time"
add_filter('woe_get_order_fields', function ($fields) {
	$fields['order_time'] = array( 'label' => 'Order Time', 'colname' => 'Order Time', 'checked' => 1 );
	return $fields;
});
// calculate new field
add_filter('woe_get_order_value_order_time', function ($value,$order, $field) {
	return $order->get_date_created()->date("H:i:s");
}, 10, 3);

// add order field "Order Time"

add_filter('woe_get_order_fields', function ($fields) {

$fields['order_time'] = array( 'label' => 'Order Time', 'colname' => 'Order Time', 'checked' => 1 );

return $fields;

});

// calculate new field

add_filter('woe_get_order_value_order_time', function ($value,$order, $field) {

return $order->get_date_created()->date("H:i:s");

}, 10, 3);

// add product field "Quantity x Name"
add_filter('woe_get_order_product_fields', function($fields,$format) {
	$fields['qty_name'] = array( 'label' => 'Quantity x Name', 'colname' => 'Quantity x Name', 'checked' => 1 );
	return $fields;
},10, 2);

add_filter('woe_get_order_product_value_qty_name', function($value,$order, $item, $product,$item_meta) {
	return $item['qty'] .' x '. $item['name'];
}, 10, 5);

// add product field "Quantity x Name"

add_filter('woe_get_order_product_fields', function($fields,$format) {

$fields['qty_name'] = array( 'label' => 'Quantity x Name', 'colname' => 'Quantity x Name', 'checked' => 1 );

return $fields;

},10, 2);

add_filter('woe_get_order_product_value_qty_name', function($value,$order, $item, $product,$item_meta) {

return $item['qty'] .' x '. $item['name'];

}, 10, 5);

 // add field  "Invoice Numbers", for Germanized Pro
add_filter('woe_get_order_fields', function ($fields) {
	$fields['german_invoice_numbers'] = array( 'label' => 'Invoice Numbers', 'colname' => 'Invoice Numbers', 'checked' => 1 );
	return $fields;
});

add_filter('woe_get_order_value_german_invoice_numbers', function ($value,$order, $field) {
	$invoices = wc_gzdp_get_invoices_by_order( $order );
	if( $invoices ) {
		$numbers = array();
		foreach ( $invoices as $id => $invoice ) {
			$numbers[] = $invoice->get_title();
		}
		$value = join(", ", $numbers);
	}
	return $value;
}, 10, 3);

// add field "Invoice Numbers", for Germanized Pro

add_filter('woe_get_order_fields', function ($fields) {

$fields['german_invoice_numbers'] = array( 'label' => 'Invoice Numbers', 'colname' => 'Invoice Numbers', 'checked' => 1 );

return $fields;

});

add_filter('woe_get_order_value_german_invoice_numbers', function ($value,$order, $field) {

$invoices = wc_gzdp_get_invoices_by_order( $order );

if( $invoices ) {

$numbers = array();

foreach ( $invoices as $id => $invoice ) {

$numbers[] = $invoice->get_title();

}

$value = join(", ", $numbers);

}

return $value;

}, 10, 3);

// add field "Date Processed", based on order's comments
add_filter('woe_get_order_fields', function ($fields) {
    $fields['date_processed'] = array( 'label' => 'Date Processed', 'colname' =>'Date Processed', 'segment' => 'common', 'format'=>'date', 'checked' => 1 );
    return $fields;
});
add_filter('woe_get_order_value_date_processed', function ($value,$order,$fieldname) {
    $args = array(
		'post_id' 	=> $order->id,
		'approve' 	=> 'approve',
		'type' 		=> 'order_note',
		'search'        => 'Order status changed from Pending Payment to Processing.',
    );
    // woocommerce hides such records by default
    remove_filter( 'comments_clauses', array( 'WC_Comments', 'exclude_order_comments' ), 10 );
    $notes = get_comments( $args );
    add_filter( 'comments_clauses', array( 'WC_Comments', 'exclude_order_comments' ), 10, 1 );

    $date_processed = '';
    if(!empty($notes)) {
        $date_processed = $notes[0]->comment_date;
    }
    return $date_processed;
},10, 3);

// add field "Date Processed", based on order's comments

add_filter('woe_get_order_fields', function ($fields) {

$fields['date_processed'] = array( 'label' => 'Date Processed', 'colname' =>'Date Processed', 'segment' => 'common', 'format'=>'date', 'checked' => 1 );

return $fields;

});

add_filter('woe_get_order_value_date_processed', function ($value,$order,$fieldname) {

$args = array(

'post_id' => $order->id,

'approve' => 'approve',

'type' => 'order_note',

'search' => 'Order status changed from Pending Payment to Processing.',

);

// woocommerce hides such records by default

remove_filter( 'comments_clauses', array( 'WC_Comments', 'exclude_order_comments' ), 10 );

$notes = get_comments( $args );

add_filter( 'comments_clauses', array( 'WC_Comments', 'exclude_order_comments' ), 10, 1 );

$date_processed = '';

if(!empty($notes)) {

$date_processed = $notes[0]->comment_date;

}

return $date_processed;

},10, 3);

//add all taxes as columns
class WOE_add_all_taxes{
	var $taxes;
	
	function __construct() {
		add_filter('woe_get_order_fields', array($this,'add_order_fields'), 10, 1);
		add_filter('woe_settings_validate_defaults', array($this,'hook_new_fields'), 10, 1);
		add_filter('woe_order_export_started',array($this,'fetch_order_taxes'), 10, 1);
	}	
	
	function add_order_fields($fields) {
		global $wpdb;
		
		$taxes = $wpdb->get_results("SELECT * FROM {$wpdb->prefix}woocommerce_tax_rates");
		foreach($taxes  as $tax) {
			$fields['tax_'.$tax->tax_rate_id] = array('label'=>$tax->tax_rate_name,'checked' => 1, 'segment'=>'cart','colname'=>$tax->tax_rate_name, 'format'=>'money');
		}	
		return $fields;
	}
	
	function hook_new_fields($settings) {
		global $wpdb;
		
		$taxes = $wpdb->get_results("SELECT * FROM {$wpdb->prefix}woocommerce_tax_rates");
		foreach($taxes  as $tax) {
			add_filter('woe_get_order_value_tax_'.$tax->tax_rate_id, array($this,'get_tax_value'), 10, 3);
		}	
		return $settings;
	}	

	function fetch_order_taxes($order_id) {
		//reset values
		$this->taxes = array();
		//read taxes
		$order = new WC_Order($order_id);
		foreach($order->get_taxes() as $code=>$tax) {
			$key = 'tax_'.$tax->get_rate_id();
			if( !isset($this->taxes[$key])) $this->taxes[$key] = 0;
			$this->taxes[$key] +=  $tax->get_tax_total();
		}
		return $order_id;
	}
	
	function get_tax_value($value, $order,$field) { 
		return isset($this->taxes[$field]) ? wc_round_tax_total($this->taxes[$field]) : 0;
	}
}	
new WOE_add_all_taxes();

//add all taxes as columns

class WOE_add_all_taxes{

var $taxes;

function __construct() {

add_filter('woe_get_order_fields', array($this,'add_order_fields'), 10, 1);

add_filter('woe_settings_validate_defaults', array($this,'hook_new_fields'), 10, 1);

add_filter('woe_order_export_started',array($this,'fetch_order_taxes'), 10, 1);

}

function add_order_fields($fields) {

global $wpdb;

$taxes = $wpdb->get_results("SELECT * FROM {$wpdb->prefix}woocommerce_tax_rates");

foreach($taxes as $tax) {

$fields['tax_'.$tax->tax_rate_id] = array('label'=>$tax->tax_rate_name,'checked' => 1, 'segment'=>'cart','colname'=>$tax->tax_rate_name, 'format'=>'money');

}

return $fields;

}

function hook_new_fields($settings) {

global $wpdb;

$taxes = $wpdb->get_results("SELECT * FROM {$wpdb->prefix}woocommerce_tax_rates");

foreach($taxes as $tax) {

add_filter('woe_get_order_value_tax_'.$tax->tax_rate_id, array($this,'get_tax_value'), 10, 3);

}

return $settings;

}

function fetch_order_taxes($order_id) {

//reset values

$this->taxes = array();

//read taxes

$order = new WC_Order($order_id);

foreach($order->get_taxes() as $code=>$tax) {

$key = 'tax_'.$tax->get_rate_id();

if( !isset($this->taxes[$key])) $this->taxes[$key] = 0;

$this->taxes[$key] += $tax->get_tax_total();

}

return $order_id;

}

function get_tax_value($value, $order,$field) {

return isset($this->taxes[$field]) ? wc_round_tax_total($this->taxes[$field]) : 0;

}

new WOE_add_all_taxes();

//add fees as columns
class WOE_add_fees_columns{
	var $order_fees;
	var $fee_columns;
	
	function __construct() {
		add_filter('woe_get_order_fields', array($this,'add_order_fields'), 10, 1);
		add_filter('woe_settings_validate_defaults', array($this,'hook_new_fields'), 10, 1);
		add_filter('woe_order_export_started',array($this,'fetch_order_fees'), 10, 1);
	}	
	
	//1 add to UI
	function add_order_fields($fields) {
		global $wpdb;
		$fees = $wpdb->get_results("SELECT DISTINCT order_item_name FROM {$wpdb->prefix}woocommerce_order_items WHERE order_item_type='fee' ORDER BY order_item_name");
		foreach($fees as $fee) {
			$key = 'fee_'.md5($fee->order_item_name);
			$fields[ $key ] = array('label'=>$fee->order_item_name,'checked' => 1, 'segment'=>'cart','colname'=>$fee->order_item_name, 'format'=>'string');
			
			$key = 'fee_tax_'.md5($fee->order_item_name);
			$fields[ $key ] = array('label'=>$fee->order_item_name. " Tax",'checked' => 1, 'segment'=>'cart','colname'=>$fee->order_item_name. " Tax", 'format'=>'string');
			
			$key = 'fee_plus_tax_'.md5($fee->order_item_name);
			$fields[ $key ] = array('label'=>$fee->order_item_name. " + Tax",'checked' => 1, 'segment'=>'cart','colname'=>$fee->order_item_name. " + Tax", 'format'=>'string');
		}	
		return $fields;
	}

	// 2 set hooks for new fields 
	function hook_new_fields($settings) {
		global $wpdb;
		$fees = $wpdb->get_results("SELECT DISTINCT order_item_name FROM {$wpdb->prefix}woocommerce_order_items WHERE order_item_type='fee' ORDER BY order_item_name");
		foreach($fees as $fee) {
			$key = 'fee_'.md5($fee->order_item_name);
			add_filter('woe_get_order_value_'.$key, array($this,'get_fee_value'), 10, 3);
			
			$key = 'fee_tax_'.md5($fee->order_item_name);
			add_filter('woe_get_order_value_'.$key, array($this,'get_fee_value'), 10, 3);
			
			$key = 'fee_plus_tax_'.md5($fee->order_item_name);
			add_filter('woe_get_order_value_'.$key, array($this,'get_fee_value'), 10, 3);
		}	
		return $settings;
	}
	function get_fee_value($value, $order, $field) { 
		return isset($this->order_fees[$field]) ? $this->order_fees[$field] : 0;
	}

	//3 get data from order 
	function fetch_order_fees($order_id) {
		//reset values
		$this->order_fees = array();
		
		//read fees
		$order = new WC_Order($order_id);
		foreach($order->get_items('fee') as $item_id => $item) {
			$name = $item->get_name();

			$key = 'fee_'.md5($name);
			$total = $item->get_total();
			$total = floatval($total);
			$this->order_fees[ $key ] =  $total;

			$key = 'fee_tax_'.md5($name);
			$total_tax = $item->get_total_tax();
			$total_tax = floatval($total_tax);
			$this->order_fees[ $key ] =  $total_tax;

			$total_totalTax = $total + $total_tax;
			$key = 'fee_plus_tax_'.md5($name);
			$this->order_fees[ $key ] = $total_totalTax;
		}
        
		return $order_id;
	}
	
}	
new WOE_add_fees_columns();

//add fees as columns

class WOE_add_fees_columns{

var $order_fees;

var $fee_columns;

function __construct() {

add_filter('woe_get_order_fields', array($this,'add_order_fields'), 10, 1);

add_filter('woe_settings_validate_defaults', array($this,'hook_new_fields'), 10, 1);

add_filter('woe_order_export_started',array($this,'fetch_order_fees'), 10, 1);

}

//1 add to UI

function add_order_fields($fields) {

global $wpdb;

$fees = $wpdb->get_results("SELECT DISTINCT order_item_name FROM {$wpdb->prefix}woocommerce_order_items WHERE order_item_type='fee' ORDER BY order_item_name");

foreach($fees as $fee) {

$key = 'fee_'.md5($fee->order_item_name);

$fields[ $key ] = array('label'=>$fee->order_item_name,'checked' => 1, 'segment'=>'cart','colname'=>$fee->order_item_name, 'format'=>'string');

$key = 'fee_tax_'.md5($fee->order_item_name);

$fields[ $key ] = array('label'=>$fee->order_item_name. " Tax",'checked' => 1, 'segment'=>'cart','colname'=>$fee->order_item_name. " Tax", 'format'=>'string');

$key = 'fee_plus_tax_'.md5($fee->order_item_name);

$fields[ $key ] = array('label'=>$fee->order_item_name. " + Tax",'checked' => 1, 'segment'=>'cart','colname'=>$fee->order_item_name. " + Tax", 'format'=>'string');

}

return $fields;

}

// 2 set hooks for new fields

function hook_new_fields($settings) {

global $wpdb;

$fees = $wpdb->get_results("SELECT DISTINCT order_item_name FROM {$wpdb->prefix}woocommerce_order_items WHERE order_item_type='fee' ORDER BY order_item_name");

foreach($fees as $fee) {

$key = 'fee_'.md5($fee->order_item_name);

add_filter('woe_get_order_value_'.$key, array($this,'get_fee_value'), 10, 3);

$key = 'fee_tax_'.md5($fee->order_item_name);

add_filter('woe_get_order_value_'.$key, array($this,'get_fee_value'), 10, 3);

$key = 'fee_plus_tax_'.md5($fee->order_item_name);

add_filter('woe_get_order_value_'.$key, array($this,'get_fee_value'), 10, 3);

}

return $settings;

}

function get_fee_value($value, $order, $field) {

return isset($this->order_fees[$field]) ? $this->order_fees[$field] : 0;

}

//3 get data from order

function fetch_order_fees($order_id) {

//reset values

$this->order_fees = array();

//read fees

$order = new WC_Order($order_id);

foreach($order->get_items('fee') as $item_id => $item) {

$name = $item->get_name();

$key = 'fee_'.md5($name);

$total = $item->get_total();

$total = floatval($total);

$this->order_fees[ $key ] = $total;

$key = 'fee_tax_'.md5($name);

$total_tax = $item->get_total_tax();

$total_tax = floatval($total_tax);

$this->order_fees[ $key ] = $total_tax;

$total_totalTax = $total + $total_tax;

$key = 'fee_plus_tax_'.md5($name);

$this->order_fees[ $key ] = $total_totalTax;

}

return $order_id;

}

new WOE_add_fees_columns();

Advanced Order Export for WooCommerce

Add New Fields

Extra custom fields, meta key must be added via UI, see exact name in code!

Some samples for adding fields via code