Modify Existing Fields

// add order prefix
add_filter('woe_get_order_value_order_number', function ($value, $order, $fieldname) {
	return "KTR-" . $value;
}, 10, 3);

1

2

3

4

// add order prefix

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

return "KTR-" . $value;

}, 10, 3);

// remove line breaks from customer note 
add_filter('woe_get_order_value_customer_note',function ($value, $order,$fieldname) {
	return preg_replace( "/\r|\n/", "", $value);
},10,3);

1

2

3

4

// remove line breaks from customer note

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

return preg_replace( "/\r|\n/", "", $value);

},10,3);

//  swap   last  and  first  names in  "Shipping Full Name"
add_filter('woe_get_order_value_shipping_full_name',function ($value, $order,$fieldname) {
	return $order->get_shipping_last_name(). ' '  . $order->get_shipping_first_name();
},10,3);

1

2

3

4

// swap last and first names in "Shipping Full Name"

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

return $order->get_shipping_last_name(). ' ' . $order->get_shipping_first_name();

},10,3);

// remap shipping method titles
add_filter('woe_get_order_value_shipping_method_title', function ($value, $order, $fieldname) {
	if($value == 'Flat rate') // copy these 2 lines for other mappings
		$value = 'STANDARD'; 
	return $value;
}, 10, 3);

1

2

3

4

5

6

// remap shipping method titles

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

if($value == 'Flat rate') // copy these 2 lines for other mappings

$value = 'STANDARD';

return $value;

}, 10, 3);

// format product 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);

1

2

3

4

// format product 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);

// fix problem with apostrophe in "WC Fields Factory"
add_filter( "woe_get_order_product_item_meta", function($item_meta ){
	foreach($item_meta as $k=>$v) {
		$k2 = html_entity_decode ($k,ENT_QUOTES);
		$item_meta[$k2] = $v;
	}
	return $item_meta;
});

1

2

3

4

5

6

7

8

// fix problem with apostrophe in "WC Fields Factory"

add_filter( "woe_get_order_product_item_meta", function($item_meta ){

foreach($item_meta as $k=>$v) {

$k2 = html_entity_decode ($k,ENT_QUOTES);

$item_meta[$k2] = $v;

}

return $item_meta;

});

// modify field "Customer Total Orders" to count only paid orders
add_filter("woocommerce_customer_get_order_count", function($value,$customer){
	global $wpdb;
	$statuses = array("wc-processing","wc-completed");
	return $wpdb->get_var(
		"SELECT COUNT(*)
		FROM $wpdb->posts as posts
		LEFT JOIN {$wpdb->postmeta} AS meta ON posts.ID = meta.post_id
		WHERE meta.meta_key = '_customer_user'
		AND posts.post_type = 'shop_order'
		AND posts.post_status IN ( '" . implode( "','", $statuses) . "' )
		AND meta_value = '" . esc_sql( $customer->get_id() ) . "'"
	);
},10,2);

1

2

3

4

5

6

7

8

9

10

11

12

13

14

// modify field "Customer Total Orders" to count only paid orders

add_filter("woocommerce_customer_get_order_count", function($value,$customer){

global $wpdb;

$statuses = array("wc-processing","wc-completed");

return $wpdb->get_var(

"SELECT COUNT(*)

FROM $wpdb->posts as posts

LEFT JOIN {$wpdb->postmeta} AS meta ON posts.ID = meta.post_id

WHERE meta.meta_key = '_customer_user'

AND posts.post_type = 'shop_order'

AND posts.post_status IN ( '" . implode( "','", $statuses) . "' )

AND meta_value = '" . esc_sql( $customer->get_id() ) . "'"

);

},10,2);

//convert "order total" and "item price"  from CNY to USD
class WOE_currency_mod {
	var $rate = false;
	
	function __construct() {
		add_filter('woe_get_order_value_order_total',array($this,'convert_cny_usd'), 10, 3);
		add_filter('woe_get_order_product_value_item_price',array($this,'convert_cny_usd'), 10, 3);
	}	
	
	function convert_cny_usd($value, $order,$fieldname) {
		return round( $value * $this->get_rate(), 2 );
	}
	
	function get_rate() {
		if( $this->rate === false) {
			$response = wp_remote_get("http://ratesapi.io/api/latest?base=CNY&symbols=USD");
			$api_response = json_decode( wp_remote_retrieve_body( $response ), true );
			$this->rate = $api_response['rates']['USD'];
		}
		return $this->rate;
	}
}	
new WOE_currency_mod();

1

2

3

4

5

6

7

8

9

10

11

12

13

14

15

16

17

18

19

20

21

22

23

//convert "order total" and "item price" from CNY to USD

class WOE_currency_mod {

var $rate = false;

function __construct() {

add_filter('woe_get_order_value_order_total',array($this,'convert_cny_usd'), 10, 3);

add_filter('woe_get_order_product_value_item_price',array($this,'convert_cny_usd'), 10, 3);

}

function convert_cny_usd($value, $order,$fieldname) {

return round( $value * $this->get_rate(), 2 );

}

function get_rate() {

if( $this->rate === false) {

$response = wp_remote_get("http://ratesapi.io/api/latest?base=CNY&symbols=USD");

$api_response = json_decode( wp_remote_retrieve_body( $response ), true );

$this->rate = $api_response['rates']['USD'];

}

return $this->rate;

}

new WOE_currency_mod();

Advanced Order Export for WooCommerce