• Resolved Mike

    (@mike_vl)


    Problem: Woocommerce recalculating order ignores setting that VAT is included in the product price and adds tax to productprice (increasing the total order amount incorrectly)

    When setting up a site the owner forgot to activate taxes. She now asked me to correct it and I have:

    • activated taxes
    • set the option to have VAT included in the price
    • set a 21% tax rate as standard

    Now when placing a new order, the tax gets show correctly on checkout and invoice. The tax is not added to the productprice but is shown as being included in the price & ordertotal.
    Productprice 14,95
    Tax 3,14 (product price excl. tax 12,35)
    Total: 14,95

    Recalculating old orders
    For the previous orders when tax was not enabled however it is a different story:
    Woocommerce offers the ability to recalculate orders. If I do this for an old order: the tax is added to the product price instead of shown to be included in the product price.
    Productprice 14,95
    Tax 3,14
    Total: 18,09

    As you can see recalculation ignores the setting that the productprice includes VAT.

    Have you seen this behaviour, or do you have an idea how to solve this problem?

    • This topic was modified 3 years, 7 months ago by Mike.
Viewing 2 replies - 1 through 2 (of 2 total)
  • Hey @mike_vl,

    I know it’s been quite a while since this thread was started. You may want to check in the _postmeta table for these orders. You can use the order number as the post_id and search for it in the database.

    See if there is a row with the meta_key _prices_include_tax on that order.

    It’s possible the old orders don’t have this set or it’s set to no. You could try changing this to yes and then see what happens when you recalculate the order totals.

    Let us know what you find out.

    Hi @mike_vl

    We’ve not heard back from you in a while, so I’m marking this thread as resolved. If you have further questions, please feel free to open a new topic.

Viewing 2 replies - 1 through 2 (of 2 total)
  • The topic ‘Woocommerce recalculating order adds tax to total’ is closed to new replies.