Tax Names

yes, I’ve got your email and sample file.

code to get order taxes ( above line “Order Total:”)

class WOE_multi_taxes_order{
	var $gst_tax = 0;
	var $hst_tax = 0;
	var $qst_tax = 0;
	
	function __construct() {
		add_filter('woe_get_order_fields', array($this,'add_order_fields'), 10, 1);
		add_filter('woe_order_export_started',array($this,'fetch_order_taxes'), 10, 1);
		
		//for XLS ,  woe_get_order_{$format}_value_{$field}
		add_filter('woe_get_order_xls_value_gst_tax',array($this,'get_gst_tax'), 10, 2);
		add_filter('woe_get_order_xls_value_hst_tax',array($this,'get_hst_tax'), 10, 2);
		add_filter('woe_get_order_xls_value_qst_tax',array($this,'get_qst_tax'), 10, 2);
	}	
	
	function add_order_fields($fields) {
		$fields['gst_tax'] = array('label'=>'TAXES GST','checked' => 1, 'segment'=>'','colname'=>'TAXES GST');
		$fields['hst_tax'] = array('label'=>'TAXES HST','checked' => 1, 'segment'=>'','colname'=>'TAXES HST');
		$fields['qst_tax'] = array('label'=>'TAXES QST','checked' => 1, 'segment'=>'','colname'=>'TAXES QST');
		return $fields;
	}
	

	function fetch_order_taxes($order_id) {
		//reset values
		$this->gst_tax = $this->hst_tax = $this->qst_tax = 0;
		//read taxes
		$order = new WC_Order($order_id);
		foreach ( $order->get_items('tax') as $item_id=>$item ) {
			// must add shipping taxes  
			if($item['label'] == 'GST')$this->gst_tax =  $item['tax_amount'] + $item['shipping_tax_amount']; 
			if($item['label'] == 'HST')$this->hst_tax =  $item['tax_amount'] + $item['shipping_tax_amount'];
			if($item['label'] == 'QST')$this->qst_tax =  $item['tax_amount'] + $item['shipping_tax_amount'];
		}
	}
	
	function get_gst_tax($value, $order) {  return $this->gst_tax; }
	function get_hst_tax($value, $order) {  return $this->hst_tax; }
	function get_qst_tax($value, $order) {  return $this->qst_tax; }
}	
new WOE_multi_taxes_order();

I just added the above code to my functions.php file. It adds the fields to the export, but they all have 0 in them instead of the tax values.

In the woocommerce_order_items table it looks like this: https://snag.gy/60VNov.jpg

In the woocommerce_order_itemmeta table, it has this: https://snag.gy/A5SuMJ.jpg

We are using the standard WooCommerce tax rates Admin > WooCommerce > Settings > Tax > Standard Rates.

This is the tax table: https://snag.gy/TVu3r4.jpg

• This reply was modified 8 years, 6 months ago by dwdonline.

some hooks were added in beta version, so provided code works in beta only.

you can contact me if you need it.

• This reply was modified 8 years, 6 months ago by algol.plus.

Code works since version 1.2.2

Hi,

Thanks for this solution. I have two additional questions:

Do i place this code in functions.php of my child theme?

I need to slightly adjust the code:
My tax names in Woocommerce are ‘BTW Hoog‘ and ‘BTW Laag‘. So they contain a whitespace.

What code do i need to use for BTW Hoog? For example here:
var $gst_tax = 0;
var $hst_tax = 0;

because simply replacing ‘gst’ by ‘BTW Hoog’ does not work:
var $BTW Hoog_tax = 0;
var $BTW Laag = 0;

I have two tax rates and i want to export each in a separate column.
Thank you in advance.

hi

Yes, you must put it in in functions.php of child theme

You must replace space with “_” , look at the updated code

class WOE_multi_taxes_order{
	var $BTW_Hoog = 0;
	var $BTW_Laag = 0;
	
	function __construct() {
		add_filter('woe_get_order_fields', array($this,'add_order_fields'), 10, 1);
		add_filter('woe_order_export_started',array($this,'fetch_order_taxes'), 10, 1);
		
		//for XLS ,  woe_get_order_{$format}_value_{$field}
		add_filter('woe_get_order_xls_value_BTW_Hoog',array($this,'get_BTW_Hoog'), 10, 2);
		add_filter('woe_get_order_xls_value_BTW_Laag',array($this,'get_BTW_Laag'), 10, 2);
	}	
	
	function add_order_fields($fields) {
		$fields['BTW_Hoog'] = array('label'=>'BTW Hoog','checked' => 1, 'segment'=>'','colname'=>'BTW Hoog');
		$fields['BTW_Laag'] = array('label'=>'BTW Laag','checked' => 1, 'segment'=>'','colname'=>'BTW Laag');
		return $fields;
	}
	
	function fetch_order_taxes($order_id) {
		//reset values
		$this->BTW_Hoog = $this->BTW_Laag = 0;
		//read taxes
		$order = new WC_Order($order_id);
		foreach ( $order->get_items('tax') as $item_id=>$item ) {
			// must add shipping taxes  
			if($item['label'] == 'BTW Hoog')$this->BTW_Hoog =  $item['tax_amount'] + $item['shipping_tax_amount']; 
			if($item['label'] == 'BTW Laag')$this->BTW_Laag =  $item['tax_amount'] + $item['shipping_tax_amount'];
		}
	}
	
	function get_BTW_Hoog($value, $order) {  return $this->BTW_Hoog; }
	function get_BTW_Laag($value, $order) {  return $this->BTW_Laag; }
}	
new WOE_multi_taxes_order();