Setting decimal precision?

hi

You should remove “format” for these columns.

please, try following code

add_filter('woe_get_order_fields', function ($fields) {
	unset($fields["order_total_tax"]["format"]);
	return $fields;
});

add_filter('woe_get_order_product_fields', function ($fields) {
	unset($fields["line_tax"]["format"]);
	return $fields;
});

use https://www.ads-software.com/plugins/code-snippets/ or modify functions.php

thanks, Alex

Hi Alex, thank you so much for your time and help!

Unfortunately the code doesn’t appear to change anything :(. Does woocommerce maybe only save the already rounded taxes? I hope not!

I have already used your code “//add all taxes as columns” you posted on your website and it works great. Is it possible to get these tax fields with the full tax amount and not the rounded one?

hi

you should replace
$this->taxes['tax_'.$tax->rate_id ] = wc_round_tax_total($tax->amount);
with
$this->taxes['tax_'.$tax->rate_id ] = $tax->amount;

thanks, Alex

Hi Alex,

thanks again for your help! At first glance your code totally works, but as it turns out, the numbers after the second decimal digit are wrong.

For example: A order total is 12.70 incl. 10% tax. This means tax is 1,154545454545455
but the export says tax is 1,159091.

Do you think this is a woocommerce problem?

hi

I think, yes.

but you should review database, table “woocommerce_order_itemmeta” , records having “meta_key” = “tax_amount”.

thanks, Alex