Subtotal different

Viewing 10 replies - 1 through 10 (of 10 total)
  • Plugin Contributor Ewout

    (@pomegranate)

    4 years, 6 months ago

    Hello Redmar,
    Can you show a screenshot of the order in WooCommerce? The Simple template uses the same totals that WooCommerce prints in the emails (another place you may want to check), and these usually correspond with the totals shown in the backend. We don’t calculate the subtotal separately.

    Let us know what you find!

    Thread Starter redmarwordpress

    (@redmarwordpress)

    4 years, 6 months ago

    Hi,

    The subtotal isn’t showed in there:

    https://broodjesservicewestland.nl/wp-content/uploads/2019/10/total-1.jpg

    Any advice?

    Regards,

    Redmar

    DodoDog

    (@dododog)

    4 years, 6 months ago

    Hello,
    we experience the same subtotal problem.
    – The subtotal shows up correctly on the Cart page and the first check out page.
    – BUT, the subtotal amount changes from €42,50 to €42,49 when the order is placed on /checkout/order-received/. The total amount of the order is correct.
    – The wrong subtotal amount also shows up on the PDF Invoices
    This is a real big problem!

    I found this Github page about the tax rounding problem:
    https://github.com/woocommerce/woocommerce/issues/23694
    And tried all tips including adding a tiny script to functions.php
    But nothing works, the PDF invoices still show the wrong subtotal amount.

    We use the latest versions of WP and all plugins are up to date:
    WooCommerce Version 3.7.0
    WooCommerce PDF Invoices & Packing Slips Version 2.3.4
    WooCommerce PDF Invoices & Packing Slips Premium Templates Version 2.7.1 (and we use the SIMPLE template)

    My question in short, is there anything I might try to get the right subtotal amount on the PDF invoices?

    Thank you so much for your answer!
    Eva

    Plugin Contributor Ewout

    (@pomegranate)

    4 years, 6 months ago

    I believe eva is right on the ball with this one. Redmar’s first screenshot shows the checkout, and if I understand the reports on the github issue correctly, this issue doesn’t surface until the order is placed. You’d have to check either the thank you page or the email that is sent to the customer to find which subtotal WooCommerce uses. Can you check that too, Redmar?

    A few things to note here:

    • Many of the suggestions on the Github ticket will only work on new orders, placed after these changes have been made. Existing orders will not be affected by the “Rounding: Round tax at subtotal level, instead of rounding per line” setting.
    • If this is indeed a rounding error happening in WooCommerce itself (before our plugin can even read the data) there’s not much we can do about this on our end…

    For Eva: since you are using the Premium Templates extension, there’s one more option you could try (depending on which kind of subtotal you want):
    If you switch to Simple Premium (same layout as the Simple but with the customizer options), you can add a “Grand Total” block and set it to “excl. tax”. This is a different kind of subtotal than the one from WooCommerce, it includes shipping and fees too. If you need more help with this, please send us an email at support@wpovernight.co since wordpress.org does not allow using these forums for support of our paid extensions.

    DodoDog

    (@dododog)

    4 years, 6 months ago

    Thank you so much Ewout for all your advise!
    I’ve been testing the Premium template tip and added a Grand Total block excluding tax but that didn’t work.
    One last question, should the setting “Round tax at subtotal level, instead of rounding per line” be checked or unchecked?
    I’m get a bit confused about this setting reading the Github page https://github.com/woocommerce/woocommerce/issues/23694
    Thank you again for your time and help, much appreciated!
    Eva

    Plugin Contributor Ewout

    (@pomegranate)

    4 years, 6 months ago

    Hello Eva,
    Can you elaborate on what doesn’t work with the Grand Total excluding tax block? This literally takes the grand total and subtracts the tax, so that should no result in any difference usually.

    The issue is quite complex. The ticket you refer to has just been updated with someone describing the issue with both options resulting in incorrect amounts: https://github.com/woocommerce/woocommerce/issues/23694#issuecomment-541065015

    It seems this is starting to affect more and more people and the tickets on Github are gaining tracktion so hopefully WooCommerce will sort this rather sooner than later.

    DodoDog

    (@dododog)

    4 years, 6 months ago

    Hello Ewout,
    indeed, fingers crossed WooCommerce will look into this problem and fix it asap! As far as I can see the problem started in May 2019 after upgrading WooCommerce.

    About the Grand Total excluding tax block not working in my tests.It seems that the Grand Total minus Tax gives the same one cent difference and “wrong” amount as the Vat base/subtotal block. I say “wrong” because we want to see the subtotal amount of €40,00 (not €39,99, €43,70 or €43,69). Please check the example order for 2 LP’s of 20 euro (subtotal 40 euro) plus Shipping costs total 12 euro.

    PDF with Grandtotal ex. VAT and Vat base/subtotal blocks:
    2x LP €20,00 (2x €16,81+ VAT €3,19) = €40,00
    Shipping €12,00 (€10,08 + VAT €1,92) = €12,00
    Incl. VAT 19 % €8,30 = correct
    Subtotal inc. VAT €39,99 = incorrect, should be €40,00
    Grandtotal ex VAT €43,70
    Vat base/subtotal (19 %) €43,69

    I don’t really understand how the Grandtotal ex.VAT and VAT base/subtotal are calculated but it’s not the 40 euro I was hoping to see,….

    I tested with Simple Premium template and Modernkopie (copied and altered template), the wrong numbers and subtotal showed up in both templates.

    Please let me know if you need more information about this test.
    Thank you!
    Cheers, EVa

    Plugin Contributor Ewout

    (@pomegranate)

    4 years, 6 months ago

    I see, that makes sense actually. There’s rounding in several places here and if the source totals (tax, grand total, shipping, etc.) are not rounded, then any calculations between them can have a rounding difference.

    for example (comma = decimal separator):
    Tax: €1,005 => €1,01
    Total: €10,000 => €10,00

    Subtotal = €10,000 – 1,005 = €8,995 => €9,00

    I’m afraid this really means the solution needs to come from WooCommerce. Letting the PDF Invoice plugin make its own rounding is only going to make the problem more messy and not contribute to a long term solution…

    DodoDog

    (@dododog)

    4 years, 6 months ago

    Thanks for all your help Ewout, your explanation makes sense to me too now. It’s def a WooCommerce problem. The question is how to get WooCommerce to finally look into this problem, but how to get them to take action…. Do you know how to contact the WooCommerce team and explain the problem? Maybe the team is already in the know and working on this, is there a place where we can see what the team is working on?
    Again, thanks for all your help and time, very much appreciated!

    Plugin Contributor Ewout

    (@pomegranate)

    4 years, 6 months ago

    In addition to the (closed) ticket that you already linked to/found yourself, there are several other, open tickets for this issue:

    https://github.com/woocommerce/woocommerce/issues/24184
    https://github.com/woocommerce/woocommerce/issues/24784
    https://github.com/woocommerce/woocommerce/issues/24695

    The fact that these are still open means that WooCommerce is aware of the issue, but I don’t know how high the priority is. If you have a github account I would recommend adding your voice to one of the above tickets, it helps a lot to share a real life example and your settings at the time of the example.

Viewing 10 replies - 1 through 10 (of 10 total)
  • The topic ‘Subtotal different’ is closed to new replies.