Support » Plugin: WooCommerce Services » Automated Tax Calculations Incorrect

  • Resolved ageekonabike

    (@ageekonabike)



    The automated taxes for the WooCommerce services are incorrect.

    The website is a clean install.

    The tax rate for the test zip code (80303) should be 8.845%. But the tax logs shows a combined tax total of just 4.00%.

    Checking TaxJar’s sales tax calculator shows the correct tax rate for the zip code.
    I’ve tested with other CO zip codes and the problem is consistent.
    The system also does not seem to be charging out of state taxes too.

    Looking at the tax logs the API does not seem to be returning city and district rates.
    Note: Shipping is disabled so no taxes are being collected.

    I know that CO’s new laws require charging city and district taxes.

    URL: https://thewalnutgallery.com/shop/

    Log & System Files: https://thewalnutgallery.com/support/ThewalnutGallery-WC-Taxes-20180823.zip

    The page I need help with: [log in to see the link]

Viewing 12 replies - 1 through 12 (of 12 total)
  • Plugin Contributor Shaun Kuschel

    (@shaunkuschel)

    Automattic Happiness Engineer

    Hey @ageekonabike!

    Thanks for passing along that info.

    We are aware of this bug and a fix for this is currently in the works. It should be included in the next Services update, which we hope to be releasing soon. We apologize for the inconvenience.

    In the meantime, you can use manual rates to ensure you collect the correct amount in taxes.

    Cheers,

    hluoma

    (@hluoma)

    Still seeing some discrepancies with Colorado (CO) tax rates, has a fix for this issue be released?

    Still a problem in Colorado – calculating tax at 4% for area with 7.9%. How do we set taxes manually? If an order has been placed, the customer has already been charged and paid for an incorrect tax. We cannot go back and ask them to pay more because our system has an error.

    Thanks!

    I don’t see a taxes option in Woocommerce services. I set up taxes in Settings to do automatic calculations with buyer’s billing address.

    The product is Hemp Oil Plus, 5 oz, $50, shipping to Arvada, CO 80003. The tax calculated was $2, or 4%. There was no shipping fee with this order.

    This is a problem, since it’s costing us revenue. Thanks for the help!

    
    ### WordPress Environment ###
    
    Home URL: https://www.vbfarms.com
    Site URL: https://www.vbfarms.com
    WC Version: 3.5.3
    Log Directory Writable: ✔
    WP Version: ❌ 4.9.9 - There is a newer version of WordPress available (5.0.2)
    WP Multisite: –
    WP Memory Limit: 256 MB
    WP Debug Mode: –
    WP Cron: ✔
    Language: en_US
    External object cache: –
    
    ### Server Environment ###
    
    Server Info: Apache
    PHP Version: 7.0.33 - We recommend using PHP version 7.2 or above for greater performance and security. How to update your PHP version
    PHP Post Max Size: 64 MB
    PHP Time Limit: 30
    PHP Max Input Vars: 1000
    cURL Version: 7.62.0
    OpenSSL/1.0.2q
    
    SUHOSIN Installed: –
    MySQL Version: 5.6.41-84.1
    Max Upload Size: 64 MB
    Default Timezone is UTC: ✔
    fsockopen/cURL: ✔
    SoapClient: ✔
    DOMDocument: ✔
    GZip: ✔
    Multibyte String: ✔
    Remote Post: ✔
    Remote Get: ✔
    
    ### Database ###
    
    WC Database Version: 3.5.3
    WC Database Prefix: wpg8_
    MaxMind GeoIP Database: ✔
    Total Database Size: 10.02MB
    Database Data Size: 9.19MB
    Database Index Size: 0.83MB
    wpg8_woocommerce_sessions: Data: 5.48MB + Index: 0.30MB
    wpg8_woocommerce_api_keys: Data: 0.00MB + Index: 0.00MB
    wpg8_woocommerce_attribute_taxonomies: Data: 0.00MB + Index: 0.00MB
    wpg8_woocommerce_downloadable_product_permissions: Data: 0.00MB + Index: 0.00MB
    wpg8_woocommerce_order_items: Data: 0.00MB + Index: 0.00MB
    wpg8_woocommerce_order_itemmeta: Data: 0.02MB + Index: 0.01MB
    wpg8_woocommerce_tax_rates: Data: 0.00MB + Index: 0.01MB
    wpg8_woocommerce_tax_rate_locations: Data: 0.00MB + Index: 0.00MB
    wpg8_woocommerce_shipping_zones: Data: 0.00MB + Index: 0.00MB
    wpg8_woocommerce_shipping_zone_locations: Data: 0.00MB + Index: 0.00MB
    wpg8_woocommerce_shipping_zone_methods: Data: 0.00MB + Index: 0.00MB
    wpg8_woocommerce_payment_tokens: Data: 0.00MB + Index: 0.00MB
    wpg8_woocommerce_payment_tokenmeta: Data: 0.00MB + Index: 0.00MB
    wpg8_woocommerce_log: Data: 0.00MB + Index: 0.00MB
    wpg8_commentmeta: Data: 0.00MB + Index: 0.00MB
    wpg8_comments: Data: 0.00MB + Index: 0.01MB
    wpg8_failed_jobs: Data: 0.00MB + Index: 0.00MB
    wpg8_image_hover_ultimate_list: Data: 0.00MB + Index: 0.00MB
    wpg8_image_hover_ultimate_style: Data: 0.00MB + Index: 0.00MB
    wpg8_links: Data: 0.00MB + Index: 0.00MB
    wpg8_loginizer_logs: Data: 0.00MB + Index: 0.01MB
    wpg8_mailchimp_carts: Data: 0.00MB + Index: 0.00MB
    wpg8_my_calendar: Data: 0.01MB + Index: 0.01MB
    wpg8_my_calendar_categories: Data: 0.00MB + Index: 0.00MB
    wpg8_my_calendar_category_relationships: Data: 0.00MB + Index: 0.00MB
    wpg8_my_calendar_events: Data: 0.00MB + Index: 0.00MB
    wpg8_my_calendar_locations: Data: 0.00MB + Index: 0.00MB
    wpg8_nf3_actions: Data: 0.00MB + Index: 0.00MB
    wpg8_nf3_action_meta: Data: 0.01MB + Index: 0.00MB
    wpg8_nf3_chunks: Data: 0.00MB + Index: 0.00MB
    wpg8_nf3_fields: Data: 0.00MB + Index: 0.00MB
    wpg8_nf3_field_meta: Data: 0.15MB + Index: 0.01MB
    wpg8_nf3_forms: Data: 0.00MB + Index: 0.00MB
    wpg8_nf3_form_meta: Data: 0.01MB + Index: 0.00MB
    wpg8_nf3_objects: Data: 0.00MB + Index: 0.00MB
    wpg8_nf3_object_meta: Data: 0.00MB + Index: 0.00MB
    wpg8_nf3_relationships: Data: 0.00MB + Index: 0.00MB
    wpg8_nf3_upgrades: Data: 0.17MB + Index: 0.00MB
    wpg8_ngg_album: Data: 0.00MB + Index: 0.00MB
    wpg8_ngg_gallery: Data: 0.00MB + Index: 0.00MB
    wpg8_ngg_pictures: Data: 0.00MB + Index: 0.00MB
    wpg8_options: Data: 1.03MB + Index: 0.10MB
    wpg8_postmeta: Data: 0.54MB + Index: 0.21MB
    wpg8_posts: Data: 1.57MB + Index: 0.09MB
    wpg8_queue: Data: 0.00MB + Index: 0.00MB
    wpg8_termmeta: Data: 0.00MB + Index: 0.01MB
    wpg8_terms: Data: 0.00MB + Index: 0.01MB
    wpg8_term_relationships: Data: 0.00MB + Index: 0.01MB
    wpg8_term_taxonomy: Data: 0.00MB + Index: 0.00MB
    wpg8_usermeta: Data: 0.19MB + Index: 0.02MB
    wpg8_users: Data: 0.00MB + Index: 0.01MB
    wpg8_wc_download_log: Data: 0.00MB + Index: 0.00MB
    wpg8_wc_webhooks: Data: 0.00MB + Index: 0.00MB
    wpg8_yoast_seo_links: Data: 0.01MB + Index: 0.01MB
    wpg8_yoast_seo_meta: Data: 0.00MB + Index: 0.00MB
    
    ### Post Type Counts ###
    
    attachment: 100
    custom_css: 1
    customize_changeset: 7
    ec_store: 1
    ecwd_calendar: 1
    ecwd_event: 1
    jetpack_migration: 2
    jp_img_sitemap: 3
    jp_sitemap: 3
    jp_sitemap_master: 3
    mc-events: 75
    mc4wp-form: 1
    nav_menu_item: 30
    nf_sub: 10
    page: 43
    post: 2
    product: 13
    product_variation: 37
    revision: 434
    shop_coupon: 8
    shop_order: 11
    shop_order_refund: 1
    tablepress_table: 2
    tribe_events: 4
    tribe_organizer: 1
    tribe_venue: 3
    
    ### Security ###
    
    Secure connection (HTTPS): ✔
    Hide errors from visitors: ✔
    
    ### Active Plugins (28) ###
    
    Akismet Anti-Spam: by Automattic – 4.1
    Jetpack by WordPress.com: by Automattic – 6.8.1
    Mailchimp for WooCommerce: by Mailchimp – 2.1.11 – Not tested with the active version of WooCommerce
    My Calendar: by Joseph C Dolson – 3.1.2
    Ninja Forms: by The WP Ninjas – 3.3.20
    Really Simple SSL: by Rogier Lankhorst
    Mark Wolters – 3.1.3
    
    Remove Query Strings From Static Resources: by Speed Up My Website – 1.4
    Storefront Blog Customiser: by WooCommerce – 1.2.5
    Storefront Footer Bar: by WooThemes – 1.0.4
    Storefront Hamburger Menu: by WooCommerce – 1.2.2
    Storefront Homepage Contact Section: by WooThemes – 1.0.5
    Storefront Mega Menus: by WooCommerce – 1.6.2 – Not tested with the active version of WooCommerce
    Storefront Parallax Hero: by WooCommerce – 1.5.7
    Storefront Powerpack: by WooCommerce – 1.4.13
    Storefront Pricing Tables: by WooCommerce – 1.1.0
    Storefront Product Hero: by WooThemes – 1.2.13
    Storefront Product Pagination: by WooThemes – 1.2.4 – Not tested with the active version of WooCommerce
    Storefront Product Sharing: by WooCommerce – 1.0.6
    Storefront Reviews: by WooCommerce – 1.0.4 – Not tested with the active version of WooCommerce
    Storefront Sticky Add to Cart: by WooThemes – 1.1.9
    Title Remover: by WPGurus – 1.2
    UpdraftPlus - Backup/Restore: by UpdraftPlus.Com
    DavidAnderson – 1.16.0
    
    WooCommerce PayPal Checkout Gateway: by WooCommerce – 1.6.5
    WooCommerce Services: by Automattic – 1.18.0
    WooCommerce Square: by WooCommerce – 1.0.34
    WooCommerce: by Automattic – 3.5.3
    Yoast SEO: by Team Yoast – 9.3
    SEOPress: by Benjamin Denis – 3.2.6
    
    ### Settings ###
    
    API Enabled: –
    Force SSL: –
    Currency: USD ($)
    Currency Position: left
    Thousand Separator: ,
    Decimal Separator: .
    Number of Decimals: 2
    Taxonomies: Product Types: external (external)
    grouped (grouped)
    simple (simple)
    variable (variable)
    
    Taxonomies: Product Visibility: exclude-from-catalog (exclude-from-catalog)
    exclude-from-search (exclude-from-search)
    featured (featured)
    outofstock (outofstock)
    rated-1 (rated-1)
    rated-2 (rated-2)
    rated-3 (rated-3)
    rated-4 (rated-4)
    rated-5 (rated-5)
    
    ### WC Pages ###
    
    Shop base: #939 - /shop/
    Cart: #940 - /cart/
    Checkout: #941 - /checkout/
    My account: #942 - /my-account/
    Terms and conditions: ❌ Page not set
    
    ### Theme ###
    
    Name: Storefront
    Version: 2.4.2
    Author URL: https://woocommerce.com/
    Child Theme: ❌ – If you are modifying WooCommerce on a parent theme that you did not build personally we recommend using a child theme. See: How to create a child theme
    WooCommerce Support: ✔
    
    ### Templates ###
    
    Overrides: –
    

    I have replied to all your emails requesting information and trying different approaches, but none of them have solved the problem.

    This seems to be a bug in WooCommerce resulting in incorrect sales tax calculations in Colorado. This is costing us money on every transaction, so could you please help us resolve this?

    Thanks you!

    @shaunkuschel

    Can you please let us know when the Colorado tax issue will be resolved? I’m trying to launch my store, but given that most of our transactions will be in Colorado, I want to ensure the tax is correct.

    My test sales are showing a 4.0% tax for Denver through Woocommerce automated tax. The 2019 combined sales tax rate for Denver, CO is 8.31%. That’s a big discrepancy.

    Please help and thanks.

    • This reply was modified 1 month, 1 week ago by  beckyrisch.
    Plugin Contributor Shaun Kuschel

    (@shaunkuschel)

    Automattic Happiness Engineer

    Hey everyone (@beckyrisch, @patvanb6, @hluoma, @ageekonabike)! Sorry for the delay getting back to you all with an update about this issue.

    There was a fix released for the discrepancies, but it looks like there may still be an issue with a few locations.

    Using Denver as an example, it looks like the correct State and District taxes are being added, but the City tax isn’t.

    There is some great info about what taxes need to be collected in CO the link below, as well as a link to a very handy tax rate collection calculator, which I definitely recommend checking out.

    https://www.taxjar.com/states/colorado-sales-tax-online/#how-to-register-for-a-sales-tax-permit-in-colorado

    Denver’s City tax rate of 4.310% wasn’t being added in the automated rates for the Denver address I was testing but the the 2.9% State tax and 1.1% District tax were correctly added.

    While we work on a fix for this, I would suggest manually adding the City tax rate to the tables you use (WooCommerce > Settings > Tax > Standard rates) and change the priority of that rate to something different than what the State tax priority is (the default priority of the State tax is “1”, so you can set the City tax rate priority to “2”, for example), that way those rates will combine to equal the correct 8.310%.

    Also, be sure to test this workaround using a real address, to make sure the automated rates are returned correctly.

    Give this a try and let me know if you see any other issues.

    Thanks!

    Plugin Contributor Shaun Kuschel

    (@shaunkuschel)

    Automattic Happiness Engineer

    CC: @beckyrisch (since the tag above doesn’t seem to have worked)

    This has been marked as resolved but based on Shaun Kuschel’s response, and my own testing, it is an ongoing issue. May I ask when is this going to be truly resolved and fixed?

    Plugin Contributor Shaun Kuschel

    (@shaunkuschel)

    Automattic Happiness Engineer

    Hey @npuana!

    This thread was marked as resolved a while back (perhaps when part of the issue was resolved?), but it does look like there are still some issues going on, so we’re still working on this. Normally, we would have asked for a new thread to be created since the ‘Resolved’ status makes this pretty confusing (and it’s an old thread), but the developers are aware and working on a resolution currently.

    I’ll be sure to watch this thread, keep you all updated, and let you know when this is actually resolved.

    Uggh, I have many clients using these automated tax rates and we have just realized they are incorrect. Only state and county rates are being added, no city rates. I am going to have to revert to manual rates. Colorado users BEWARE

    Plugin Contributor Shaun Kuschel

    (@shaunkuschel)

    Automattic Happiness Engineer

    Hey @czeller,

    The cause of the issue with Colorado has been identified and a fix is being worked on, but in the meantime, you can either switch to manual rates (disabling automated taxes) or just add the city tax rate you need to the appropriate tax table(s) with a different priority than the State tax. For example, this is what I did on my test site for Denver while awaiting the update:

    https://cld.wthms.co/y8XC7B

    The State tax row was added automatically by Services and has a priority of 1, so I manually added Denver’s city tax of 4.31% (which I believe is the correct City rate for Denver, but recommend that everyone confirm the rates that they should legally be charging) with a priority of 2, to ensure they are combined when customers match both the Denver and Colorado rows.

Viewing 12 replies - 1 through 12 (of 12 total)
  • You must be logged in to reply to this topic.