evmapa

Hi! Thanks for your reply! I have it set to round at the subtotal level. But in this case there shouldn’t be any rounding at all so where is the error coming from?

Some quick backstory of a related error if you care to read about it, since it leads up to why this can’t (or shouldn’t) be a rounding error.

—–
Due to the way we have to submit our taxes I have to do some calculations with the unrounded tax numbers split up by tax class, which I export from the database. They aren’t completely unrounded of course, but the six decimal places are precice enough for my purposes. Or should be!

Only, the numbers are incorrect! For example, I had a total of €8.55 including €4,90 shipping taxed at 10%. That should have given a tax of 0.777273 but the exported tax was 0.781818. Completely wrong.
———-

I never could figure out where those numbers were coming from, so in desperation I changed ALL our prices so that the tax would never have more than two decimal places (with the exception of shipping and vouchers, which have three decimal places when calculated with 20% tax, since there is no total that works equally well for 10% and 20%)

If you take a look at the numbers in my first post, they are all strangely precice (5.28, 4.95, 35.09). That’s by design, all in order to only get a maximum of two decimal places of calculated tax.

5.28 includes a 10% tax of 0.48
35.09 includes a 10% tax of 3.19
4.95 includes a 10% tax of 0.45

And yet, in this order, when I apply the voucher of 5.28 it steals a cent from the total and everything is out of whack again. There should be zero rounding going on, so why is it doing this?

I’m seriously running out of ideas here ??

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 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?

Thank you! I’m very grateful for your help. SQL should work. I’m not an expert but I peeked into the database and it looks simple enough. Thanks again! You went above and beyond.

All right, I understand! Thank you so much for your help!!! Only two more questions if I may and I will leave you in well-deserved peace.

Is it possible to import existing gif card codes into your plugin? We do have some that we generated manually before we had this plugin, so it would be convenient to import them. If not, that’s OK, we can deal with it :).

And an unrelated question. You already provided support for the translation issues with Loco translate. I followed your instructions and it worked like a charm. Only one button (the one that says “Apply Gift Card” and is labled pwgc-redeem-button in the html/css) remains untranslated. Could you please tell me the line I need to paste into wp-config to translate that one too?

Thank you very much and sorry for the many questions.

Thank you! That is very kind of you!

Hi, I have the same problem as patrickschulz with the translation. I followed your instructions to the letter, but no matter where in wp-config.php I insert this code (directly above the happy blogging line or anywhere else), it breaks my site (white screen back and front end) every time. I copy it exactly as you wrote it here and only replace the English words in between the ”, but it never works. Any advice?

Edit: Never mind, I figured it out. The ‘ symbol was wrong when copy/pasted. I replaced them all and now it works. Thanks for this workaround!

• This reply was modified 6 years, 11 months ago by evmapa.