Woocommerce recalculating order adds tax to total
-
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,95Recalculating 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,09As 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?
-
Hey @mike_vl,
I know it’s been quite a while since this thread was started. You may want to check in the
_postmetatable for these orders. You can use the order number as thepost_idand search for it in the database.See if there is a row with the meta_key
_prices_include_taxon that order.It’s possible the old orders don’t have this set or it’s set to
no. You could try changing this toyesand then see what happens when you recalculate the order totals.Let us know what you find out.
- The topic ‘Woocommerce recalculating order adds tax to total’ is closed to new replies.
