[Plugin: Woocommerce] Tax not calculating

  • Resolved richbate88

    (@richbate88)


    9 years, 5 months ago

    This has been playing on me for the last few weeks. I’ve got a Woocommerce store set up with a number of products. For some reason the TAX/VAT is just not showing or calculating on the product page, cart or checkout.
    I’ve tried almost every TAX setting variation but nothing seems work. For reference the store only sells to the UK so general settings reflect this.

    General Tax Options
    Enable Taxes: Yes
    Prices Entered With Tax: No, I will enter prices exclusive of tax
    Calculate Tax Based On: Shop base address
    Shipping Tax Class: Standard
    Display prices in the shop: Including tax

    Standard Tax Rate Settings
    GB, *, *, *, 20.0000, VAT

    I also installed the EU VAT Compliance for WooCommerce to see if it will force Woocommerce to take note of the GB VAT rate but again it’s done nothing.

    I’m not sure what I’m doing wrong. All the settings seem to be right but it’s just not playing ball. I’ve seen a few people have had a similar problem but they don’t seem to get resolved.

    Anyone else had this issue?

Viewing 1 replies (of 1 total)
  • Thread Starter richbate88

    (@richbate88)

    I worked out what was wrong. For some reaason the wp_woocommerce_tax_rate_locations table was missing in the mySQL database.

    I ran the following script in phpMyAdmin and all the correct TAX/VAT levels started to appear!

    CREATE TABLE IF NOT EXISTS wp_woocommerce_tax_rate_locations (
    location_id bigint(20) NOT NULL AUTO_INCREMENT,
    location_code varchar(255) NOT NULL,
    tax_rate_id bigint(20) NOT NULL,
    location_type varchar(40) NOT NULL,
    PRIMARY KEY (location_id),
    KEY tax_rate_id (tax_rate_id),
    KEY location_type (location_type),
    KEY location_type_code (location_type,location_code)
    ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

Viewing 1 replies (of 1 total)
  • The topic ‘[Plugin: Woocommerce] Tax not calculating’ is closed to new replies.

Tags