Hooks/Filters

Each column can be modified by filter before output.
Hook names depend on type of field and field name

for order – woe_get_order_value_FIELD
for product – woe_get_order_product_value_FIELD
for coupon – woe_get_order_coupon_value_FIELD

Use section “Setup fields” to find FIELD – hover the field(see tooltip on the screenshot) OR switch to “JSON” format

EACH type has own parameters

//Order: we use  usermeta field  to fill First Name
add_filter('woe_get_order_value_first_name',function( $value,$order, $fieldname ) {
  $user_id = $order->get_user_id();
  return get_user_meta($user_id, 'first_name', true); 
}, 10, 3 );

// Product: format  weight, 0.2->0.200  and 0.12->0.120
add_filter('woe_get_order_product_value_weight', function ($value, $order, $item, $product,$item_meta) {
	return number_format($value,3,'.','');
}, 10, 5);

// Coupon: add prefix to code 
add_filter('woe_get_order_coupon_value_code', function ($value, $order, $item) {
	return "WC-".$value;
}, 10, 3);

//Order: we use usermeta field to fill First Name

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

$user_id = $order->get_user_id();

return get_user_meta($user_id, 'first_name', true);

}, 10, 3 );

// Product: format weight, 0.2->0.200 and 0.12->0.120

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

return number_format($value,3,'.','');

}, 10, 5);

// Coupon: add prefix to code

add_filter('woe_get_order_coupon_value_code', function ($value, $order, $item) {

return "WC-".$value;

}, 10, 3);

It’s possible to skip order using filter woe_order_export_started

//  export only orders with total > 10
add_filter( 'woe_order_export_started',  function ( $order_id ) { 
  $order = new WC_Order($order_id);
  return   ($order->get_total()  > 10.00) ? $order_id: false;
});

// export only orders with total > 10

add_filter( 'woe_order_export_started', function ( $order_id ) {

$order = new WC_Order($order_id);

return ($order->get_total() > 10.00) ? $order_id: false;

});

There are extra filters to format final text before output woe_xls_output_filter, woe_csv_output_filter, woe_xml_output_filter, woe_json_output_filter

Example: we add namespace "ns2:" to all tags
add_filter( 'woe_xml_output_filter', function( $xml, $rec  ) { 
  // for <test> 
  $xml = preg_replace( '/(?<=<)([^/].*?)(?=>)/', 'ns2:$1', $xml);
  // for </test>
 $xml = preg_replace( '/(?<=</)(.*?)(?=>)/', 'ns2:$1', $xml); 
return $xml; 
} , 10, 2);

Example: we add namespace "ns2:" to all tags

add_filter( 'woe_xml_output_filter', function( $xml, $rec ) {

// for <test>

$xml = preg_replace( '/(?<=<)([^/].*?)(?=>)/', 'ns2:$1', $xml);

// for </test>

$xml = preg_replace( '/(?<=</)(.*?)(?=>)/', 'ns2:$1', $xml);

return $xml;

} , 10, 2);