USA CSV File Standard Tax Rate Table List & State City Item Class

  • Resolved backt0thefuture

    (@backt0thefuture)


    6 months, 2 weeks ago

    Very unfortunate Woocommerce does NOT calculate the taxes already automatically. The “automated tax calculation” box is not even visable dispite the fact several post refer to it. I found online it would work only by charging for customers who are purchasing from the SAME state as the store (based on the store’s location in WooCommerce > Settings > General). WHICH IS POINTLESS, the whole purpose is to make as many sells worldwide theortically, no? If I am going to sell locally then I would just go to a outside flea market.


    By any chance does ayone know a site that offers a simplified tax rate table CVS file for all city and states within the USA and other countries? The submitted list should be for sales tax rates by state, city, and category class of item being sold (ex. Clothing, Accessories, Jewerly, Food, Etc).


    I notice some sites like Avalara have a FREE tax rate tables with about a 2GB of data (each file is devided by state and can’t upload anyway). Apparently these CVS files can be uploaded into a plugin thats about 10 years old called “Tax RAte Upload” By Adam Bowen. I am trying my best to avoid strange plugins for someting that should be alot more streamline and simple.


    Does anyone know a better more safer way? Has anyone tried WooCommerce Quaderno plugin or WooCommerce AvaTax by SkyVerge? I am honestly trying my best to avoid plugins since we can get a file from Avalara, even though its not perfect, because the file is huge and don’t see how it can differiciate between different item classes.


    Is it nesscesary to have such large CVS data files used? I figured when creating your own standard list, there should be a simple function for just listing the city (Which embodies all other city zipcodes already for the set specified tax). For example why would I need every zipcode entry point in New York City, when shopping for clothing is taxed the same within EVERY zipcode within that city anyway? Seems all those extra entries are too repetitive. Can’t we just use product categories, the city name, and state to identify the approiate tax? Editing the document would be alot easier too when laws change.


    On Woocommerce, if we enter the city name without zipcode, would the appropriate tax be issued if the customr enters the same city at checkout? Do we need to make a seprate tax table list (Woocommerce> Settings>Tax options>Additional tax classes) and have it set for each product item within woocommerce? The system can’t just know which tax class to apply related to the category of the item listed in the description/title/etc? If so, how can we achieve this?

Viewing 2 replies - 1 through 2 (of 2 total)

  • Hi @backt0thefuture,

    Thank you for reaching out. I understand that setting up taxes can be quite complex, especially when dealing with multiple jurisdictions and product classes. It’s true that WooCommerce can calculate taxes automatically, but the “automated tax calculation” feature you mentioned might be related to a specific plugin or service that integrates with WooCommerce. WooCommerce itself allows for manual tax setup, which can be quite detailed and flexible to accommodate various tax laws.

    Regarding your question about a simplified tax rate table CSV file, WooCommerce doesn’t offer a pre-made CSV file for tax rates because the rates can vary widely and change frequently. However, you can create your own CSV file and upload it to WooCommerce. The format needs to be compatible with WooCommerce’s tax import functionality.

    As for the plugins you mentioned, WooCommerce Quaderno and WooCommerce AvaTax are both reputable solutions that integrate with WooCommerce to provide automated tax calculations. They can handle tax calculations for multiple regions and product classes, which seems to be what you’re looking for.

    To address your concern about large CSV files, it’s not necessary to have a separate entry for every single ZIP code if the tax rate is the same across a city. You can set up tax rates by city, and as long as the customer enters a matching city name at checkout, the appropriate tax should be applied.

    Lastly, regarding the tax class for different product categories, you would need to set up “Additional tax classes” in WooCommerce and assign them to your products. WooCommerce doesn’t automatically apply tax classes based on product descriptions or titles; you’ll need to set this up manually.

    I hope this helps! If you have any more questions or need further assistance, please don’t hesitate to ask.

    anastas10s

    (@anastas10s)

    Howdy ?? We haven’t heard back from you in a while, so I’m going to mark this as resolved – we’ll be here if and/or when you are ready to continue.

Viewing 2 replies - 1 through 2 (of 2 total)
  • The topic ‘USA CSV File Standard Tax Rate Table List & State City Item Class’ is closed to new replies.

Tags