Tax by city

[scott_landon1]

I need to add an extra check for the City in the Tax Rates.

E.g, some Cities in the US have different sales tax, I need to check the city and apply the correct tax rate.

I have tried using extension attributes, but couldn't get it to work properly.

[Robert Rand]

Hi Scott,

I've never tried to do it by city, but I imagine that could be a pain. For instance, many states have a city named Springfield. It's also not usually as accurate as I understand it. Major cities like Birmingham, Atlanta, Oklahoma City, Kansas City, Cincinnati, and Omaha have more than one sales tax rate. This is usually because these cities are split between more than one county.

I'd typically go by zip code instead of city. You should be able to get free rate tables from: https://www.avalara.com/taxrates/en/download-tax-tables.html

You can learn more about formatting and uploading rates at https://docs.magento.com/m2/ee/user_guide/system/data-transfer-tax-rates.html 

Alternatively, I've worked with systems like Avalara, TaxJar, and Vertex to automate sales taxes by street address, which is even more accurate. There are several integrations that you can choose from in the Magento Marketplace, and some, like TaxJar, have pretty reasonable starting rates if it's not something that you've previously budgeted for: https://marketplace.magento.com/extensions/accounting-finance/taxes.html

Best of luck!

[scott_landon1]

Hi Robert, 

I have a list of zip codes that I have imported into my Magento Admin.

Set up the Tax Rule, but there are over 1000 zip codes in this file all with different sales tax rates. So when I try and set up the Tax Rule and select all of the correct tax rates and save, I get the error "priority required." message display, but if I take the selected Tax Rates to under 1000, it saves correctly.

SO, I then tried to add another Tax Rule to include the missing last couple of Tax Rates, save this, but then when going to the checkout and filling in the shipping address with the Zip code, the Zip codes that are in the first Tax Rule (the one with 999), that shows the correct tax amount.

But then when changing the Zip Code to one that is in the second Tax Rule saved, this adds that Zip Codes sale tax on top of the current tax, instead of overwriting it.

I have tried to use the priority field, but this has no affect, in fact it actually increases the tax amount.

Hope this is understandable! 

Any help you have is much appreciated.