Support » Plugin: WooCommerce » After update (3.6.2) subtotal is displayed wrong in corfirmation email

  • Resolved aovivo

    (@aovivo)


    Hi there,
    I had updated to 3.6.1. and had not experienced that error ever before. But after updating to 3.6.2. in some cases (not all) the subtotal displayed on the order confirmation email, is not displayed correctly. That means sometimes we have a subtotal like 10,01 Euros oder 12,99 Euros, althought we only have rounded prices such as 10,00 Euros or 13,50 Euro…

    There has been NO update in themes, plug-ins etc so far except WooCommerce updated to 3.6.2.
    Its not dramatic, since the total price is correct at the end (which doesnt make it less weird), but somehow I’d like to know where it comes from.

    I was not able to reproduce the error during checkout (online) – subtotal and total price look fine. It only shows that issue in confirmation email (received by customer).

    Has there been a change in calculation, taxes, etc somehow?
    Here is a screenshot of the issue: https://imgur.com/a/LhTBXeC

    Maybe someone has an idea…
    thanks
    Pedro

Viewing 15 replies - 1 through 15 (of 18 total)
  • Plugin Support Andrew

    (@slash1andy)

    Automattic Happiness Engineer

    Hey there!

    Calculations involving product prices, tax rates, subtotals, and decimal places can be fairly complex, so knowing all of the variables can help us figure this out.

    * Can you tell us how you have your prices set up, including tax or excluding tax?
    * Can you tell us the tax rates for that order you sent a screenshot of?
    * Can you tell us the amount of decimal places you have set up on your site to round to?
    * Are there any custom templates for WooCommerce provided by your theme or otherwise (if you are not sure, you can see them in the WooCommerce Status Report)?

    Once we have that info, we can hopefully help you get this sorted.

    Have a great one!

    Thanks for the quick response. I will try to be as accurate as possible.

    1) the prices include taxes , the shipping costs include taxes as well.
    2) (Reduced) tax is 7% (reduced, because in Germany the standard tax is 19% (7% like in this case, is f.e. for foodstuff)
    3) I don’t know of a place where to ’round’ decimal places. I see an option to round up in the subtotal instead of each price (see attached image) … can you explain where to find that option?
    4) there are no custom templates used (see image link)

    I have found a similar request a year ago here: https://wordpress.org/support/topic/wrong-round-in-cart-and-checkout/

    Here are the images corresponding to the questions above.
    https://imgur.com/LofA4Dq
    https://imgur.com/f9ibao5
    https://imgur.com/z6i87jh

    My guess is, that there is a slight calculation issue, that indeed could be resolved by rounding up. However – I am running this shop over 5 years now (receiving 5-8 orders a day) and I never have noticed this issue before… so I still wonder if there is a bug or option unchecked… note, that I could not reproduce this issue while checking out, but it appears clearly in the confirmation email.

    thanks again for the support and have a good start into the new week!
    Pedro

    Dani

    (@adorablepaws)

    Same problem here 🙁

    @aovivo, could it be related to Germanized Pro? I contacted Germanized Pro support, too. Perhaps Dennis can help.

    • This reply was modified 2 months, 2 weeks ago by  Dani.

    Thanks, but no. I dont use Germanized-/Pro.
    But anyway, I would be happy to know what the Germanize team finds out.

    regards.
    P.-

    Dani

    (@adorablepaws)

    Germanized team already answered. Nothing to do with their plugin. They just take the subtotals from Woocommerce.

    I assume it might has to do with the Woo Update 3.6 where acc. to the changelog the tax rounding methods were refactored. 🙁

    Okay, great – thanks for the feedback. Lets hope this can be fixed soon.

    Plugin Support dougaitken

    (@dougaitken)

    Automattic Happiness Engineer

    Hey @aovivo @adorablepaws

    To find out where and what has changed here, do you have the option to use a staging site and try this with WooCommerce and the default Store theme? This would rule out any changes with the theme and any other plugins.

    I don’t know of a place where to ’round’ decimal places. I see an option to round up in the subtotal instead of each price (see attached image) … can you explain where to find that option?

    For the rounding, the setting for this is in the Taxes screen – https://docs.woocommerce.com/document/setting-up-taxes-in-woocommerce/

    If the change was between version 3.6.1 and 3.6.2 – all corresponding changes are listed on the changelog and blog – https://woocommerce.wordpress.com/2019/04/24/woocommerce-3-6-2/

    Thanks,

    aovivo

    (@aovivo)

    okay thanks for the input.
    So I staged and tried a standard – the problem is, that its unrelated to specific products and its some specific combinations – I guess its something to do where or what is been rounded. however nothing changed. I am not sure if this happened between 3.6 and 3.61 or 3.6.2… I am pretty sure WooCommerce was the only plug-in that was updated (besides WordPress) at that time. (no option was changed in any plug-in)

    As for the rounding in the Taxes screen, I changed (unchecked the option) the rounding – and voilá the rounding error appears in the “Total” which is even less favorable…

    I am lost here. I checked the input on GitHub but (unfortunately) did not see any similar reclamation… Still, I hope there are some other people running into this and explaining how this can be corrected…

    thanks for the efforts!
    best regards
    P.-

    aovivo

    (@aovivo)

    I guess this is what Dany was writing about in the update 3.6.0:
    * Fix – Misc tax rounding improvements. #22420

    So I am not sure anymore if the issue in rounding I am worried about came after between 3.6.1. and 3.6.2 or it happened right after 3.6.0…

    Anyways – what exactly happened here: * Fix – Misc tax rounding improvements. #22420
    Can this be elucidated?
    thanks in advance

    Plugin Support dougaitken

    (@dougaitken)

    Automattic Happiness Engineer

    Hey @aovivo

    So I am not sure anymore if the issue in rounding I am worried about came after between 3.6.1. and 3.6.2 or it happened right after 3.6.0…

    Given the changelog entry is mentioning this on the 3.6.0 release, it will have happened on that update.

    If you updated from 3.5.8 to 3.6.1 it would have been included in that full update.

    Anyways – what exactly happened here: * Fix – Misc tax rounding improvements. #22420
    Can this be elucidated?

    Sure, all numbers liks #22420 refer to GitHub Issues or Pull Requests where the development happens, so searching GitHub for that ID returns this
    https://github.com/woocommerce/woocommerce/issues/22420

    Hopefully, that explains the change in enough detail for you.

    Thanks,

    aovivo

    (@aovivo)

    Thanks Doug.

    So as far as I understand the follow up – the testing does not show any error in rounding. This happens most, when there are more than 3 or 4 lines of items in the cart. Not every time. But its there.

    However, in a new testing, I found out that the error only appears after the order is finally placed… which makes it weird, since I always thought, that there is a compiling and rounding error once the item is placed in the cart. So its not there during checkout, but its there after the order is placed (“thank you page” and order confirmation emails)…

    has this been followed till the order has been placed?
    can this be adjusted?

    thanks for all the efforts.
    regards

    Plugin Support dougaitken

    (@dougaitken)

    Automattic Happiness Engineer

    Hey @aovivo

    However, in a new testing, I found out that the error only appears after the order is finally placed… its not there during checkout, but its there after the order is placed (“thank you page” and order confirmation emails)…

    Thanks for confirming what is happening here, to me this sounds like either your theme files are outdated or there is a rounding issue which is displaying the prices differently in the cart/checkout and the order-received page and confirmation email.

    Have you tried testing with only WooCommerce and our Storefront theme?

    Any WooCommerce settings related to Taxes can be read about in the documentation – https://docs.woocommerce.com/document/setting-up-taxes-in-woocommerce/

    Thanks

    Hi to all, rather new to all this and trying to launch our new website, we are experiencing the same issue as above, have you found a solution?
    Would rolling back the updates fix this for now?

    Thanks

    Plugin Support dougaitken

    (@dougaitken)

    Automattic Happiness Engineer

    Hi @georgea26

    Can you confirm that the behavior you are seeing exists using only WooCommerce core?

    I believe the root of your query is the same as @aovivo and it comes from – https://github.com/woocommerce/woocommerce/issues/22420

    Would rolling back the updates fix this for now?

    Rolling back will only cover up the issue until you need to update – and we always recommend updating as often as possible.

    For yourself and @aovivo, and @adorablepaws I’d recommend speaking to an accountant or tax professional to confirm yourself up is correct – https://docs.woocommerce.com/document/setting-up-taxes-in-woocommerce/

    If you want the behavior as it was pre-3.6, you would need to contract a developer and create a custom solution to revert the changes.

    I may have got this totally wrong and if you feel this is something which needs to change in WooCommerce core, please do search through the Issues on GitHub – https://github.com/woocommerce/woocommerce/issues and see if something similar has been reported, or open a new one if needed with full details.

    Could this be related – https://github.com/woocommerce/woocommerce/issues/23694 ?

    Thanks,

    Could this be related – https://github.com/woocommerce/woocommerce/issues/23694 ?

    YES – same issue!
    I run three larger WC shops for more than 5 years now. The issue has never been there! no tax calculation or whatsoever needed to be changed… in fact it was totally exemplary and accurate compared to other shop systems…

    so I hope someone can locate the error.
    thanks in advance
    Pedro

Viewing 15 replies - 1 through 15 (of 18 total)
  • You must be logged in to reply to this topic.