Tax is not calculated

  • Resolved jkriester

    (@jkriester)


    9 years, 6 months ago

    I’m setting up fresh WordPress webshop using WooCommerce, it isn’t calculating VAT (BTW in the Netherlands). It shows up as “incl. € 0,00 BTW”.

    I use these settings:
    WooCommerce > Settings > General: Base location = Netherlands
    WooCommerce > Settings > Tax > Tax Options: Enable taxes = checked
    WooCommerce > Settings > Tax > Tax Options: Calculate Tax Based On = Shop base address
    WooCommerce > Settings > Tax > Standard rates:
    * * * * 21.0000 BTW 1

    I also saw that this note has been removed in the cart:

    “Note: Shipping and taxes are estimated and will be updated during checkout based on your billing and shipping information”

    And in the changelog that woo worked on the cart.php

    And I also tested a roll back of version of woo + theme, but that didnt solve the problem.

    Bug only seems to appear on a fresh install. other shops I have with same woo version are fine.

    please help!

Viewing 15 replies - 1 through 15 (of 22 total)
  • Thread Starter jkriester

    (@jkriester)

    I was able to find the fix, as follows:
    It a databse problem.
    This database table is missing: “wp_woocommerce_tax_rate_locations”

    1 Go to database of webshop that is working correctly
    2 Export the database table “wp_woocommerce_tax_rate_locations”: select it on left side; on right side tab select export; all setting can be left default
    3 Go to databse of webshop that is NOT calculating VAT
    4 Import the database table “wp_woocommerce_tax_rate_locations”; on right side tab select import
    5 now its fixed

    (I cant share this db table with you all here, file type is not supported. Dont not other solution here, or send me message and Ill send it over)

    Could you upload the file of an exported database table to (one of) your servers and share the link here?

    You’d help me out incredibly much.

    Thread Starter jkriester

    (@jkriester)

    https://expirebox.com/download/7876238dbdaf263a80c6da43133ddeaa.html

    hope this works!?

    I downloaded it. Thanks.

    Now how do I go about importing it? Is that in WordPress, or PHPMyAdmin?

    Thread Starter jkriester

    (@jkriester)

    PHPMyAdmin

    and there follow steps 1 – 5

    I downloaded it and its an empty table. My shop with working taxes also has an empty table of the same name. So I think what you’re saying is that the table must exist but is not being created by a new install.

    I imported the file and now it’s working! Thanks Jkriester!

    And I guess it’s right what Lorro is saying. Creating the file should work just as well, will test that now on different system.

    I have no clue how to create a table. Can’t figure out what to do. I imported the file again and his proven to work again.

    hi guys,
    seems like finally there is a workaround? im glad cause i searched more than 2 weeks for a solution why the taxes are not calculated.

    jkriester can u upload it once again please?
    the link expired and i was to late ??

    thank you
    f

    God bless you jkriester!

    I spend hours today looking for a mistake I’ve done.

    After i couldn’t I started an internet research and found your thread.

    Shame on Woothemes (again), it’s not the first time they delivered bugs.

    It works now, finally.

    Thank you man, you saved my day.

    @itsecmedia, did you solve the problem without downloading the empty table?

    Seems like many people would need this advice ??

    f

    jkriester, can you please upload the file again, so i can download it?

    thanks..

    yes please i still need it too..

    I encounter the same problem with this. Could anyone help me this? The above file is already expired.

    I already fixed this problem. Thanks for the idea “jkriester”.

Viewing 15 replies - 1 through 15 (of 22 total)
  • The topic ‘Tax is not calculated’ is closed to new replies.