Here is a Tax Calculation Fix for BlueHost

  • For anyone that has blue host and has a lot of tax rates entered and they are not working. This is the fix.

    The file is located in wp-content/plugins/woocommerce/classes/class-wc-tax.php. On line 91 add this

    $wpdb->query(‘SET SQL_BIG_SELECTS=1’);

    So it should then look like this

    // Run the query
    $wpdb->query(‘SET SQL_BIG_SELECTS=1’);
    $found_rates = $wpdb->get_results( $wpdb->prepare( “

    I have a had a few clients who have used my tax rate upload plugin and contacted me saying the taxes were not being calculated. All of these people were using Bluehost. Nothing to do with my plugin but the way woocommerce setup the query. Seems to only be affected when you have hundreds or thousands of tax rates.

    https://www.ads-software.com/plugins/woocommerce/

  • The topic ‘Here is a Tax Calculation Fix for BlueHost’ is closed to new replies.