Strange issue with tax not calculating..??

  • angelleye

    (@angelleye)


    8 years, 8 months ago

    I’m setting up a very simple WooCommerce configuration, but for some reason my tax isn’t calculating.

    Under WooCommerce -> Settings -> General I have the base store location set to US – California.

    Under the Tax tab / tax options I have the following…

    – Enable taxes and tax calculations – checked/enabled
    – Prices exclusive of tax.
    – Calculate tax based on : Shop base address.
    – Shipping tax class: Standard
    – Display prices in shop/checkout: Excluding tax.
    – Display tax totals: As a single total.

    Under the Tax tab / Standard Rates section I have one row filled in with the country set to US and the rate set to 9%. State, zip, and city each have * filled out so it should apply to all.

    In the product’s General tab I have the following…

    – Tax stats: Taxable
    – Tax class: Standard

    When I add the product to the cart, though, it shows the tax line with 0.00 and it is not calculating the 9% tax.

    I can’t think of what else I am missing and would appreciate any info I can get on this. Thanks!

    https://wordpress.org/plugins/woocommerce/

Viewing 5 replies - 1 through 5 (of 5 total)
  • lorro

    (@lorro)

    8 years, 8 months ago

    Did you check the existence of the wp_woocommerce_tax_rate_location table. This problem has been on here a few times lately.

    Thread Starter angelleye

    (@angelleye)

    8 years, 8 months ago

    I don’t have access to look at the database on this particular site right now. I’ll have to get the credentials from the client. Would uninstalling and re-installing WooCommerce create it for me if it wasn’t there?

    lorro

    (@lorro)

    8 years, 8 months ago

    Member jjbte did track down the particular circumstances when the table create failed for some people:
    https://wordpress.org/support/topic/error-creating-woocommerce_tax_rate_locations-table?replies=1

    I don’t know if WooCommerce has fixed this bug yet. If they have, reinstallation may fix it.

    Its the work of a moment to look at the database in phpMyAdmin to see if the table is there. If you don’t have access, try this plugin:
    https://wordpress.org/plugins/sql-executioner/
    and run this sqlquery:

    IF EXISTS (SELECT *
    FROM SqlHintsDemoDB.INFORMATION_SCHEMA.TABLES
    WHERE TABLE_SCHEMA = N'dbo'  AND TABLE_NAME = N'wp_woocommerce_tax_rate_locations')
BEGIN
  PRINT 'Table Exists'
END

    Replace SqlHintsDemoDB with the name of your database which you can get from wp-config.php.

    This more indirect method may not give as much confidence in the result as a direct look.

    Thread Starter angelleye

    (@angelleye)

    8 years, 8 months ago

    Thanks for the details. I’ll get the credentials from the client so I can check the database to see if the table is there.

    Thread Starter angelleye

    (@angelleye)

    8 years, 8 months ago

    Indeed, the database was missing that table. I used the SQL provided in jjbte’s thread to create the table manually and now tax is calculating as expected. Thanks!

    Not sure if I should mark this as resolved or not, though..?? I’ve got it working, but there’s apparently a problem that needs to be addressed.

Viewing 5 replies - 1 through 5 (of 5 total)
  • The topic ‘Strange issue with tax not calculating..??’ is closed to new replies.

Tags