Local Sales Tax Mod - Support Thread

I've never found tax cloud to be a great solution - avalara has a paid module that works well.

batracy - would you consider letting me retrieve the tax info from your database so that I could upload it and others can get it? Just had a NY customer ask about it.

I have a question regarding this mod. If I configure it by county and then handle any exceptions to city if any, how does Zen-cart and or the mod decide what county the address belongs to?

I'm in South Carolina and the state has a 6% rate. Some counties charge up to 2.5% and some cities within the county may have their own addition.

For example Myrtle Beach is in Horry County so the tax for Myrtle Beach would be:

State: 6%
Horry County 1%
Myrtle Beach 1%
Total tax 8%

Being the address only has city and zip code, how will the Zen-cart and module calculate the tax to the proper 8% being I do not see how it knows its Horry County?

On the other hand, can someone tell me how to configure this mod? Also do I need to install the addressbookzone validation sql script or is it totally optional?

Is there anything we can do to help?

delia:

I've never found tax cloud to be a great solution - avalara has a paid module that works well.
Can we do anything to help?

gwynwyffar:

Based on the TaxCloud forum thread, it appears that the current plugin version of TaxCloud here on Zen-Cart.com is not fully compatible with version 1.5.4. I'd be happy to use it if it were.

We have left the older version of our module here on ZenCart for Zen'ers that have older versions of ZenCart. For newer versions, please use our GitHub source.

Greetings, if different tax rates for let's say 100 different counties and cities in one state are configured using this mod, do all 100 counties and cities show up in the drop-down menu during checkout? Thank you.

Terrific addition to ZC! Thank you! Am testing a statewide rule for Louisiana where rule is 70001-to-71497 and search field is set to Zip Code. On test orders to Sarasota, FL 34236 (shipping and billing) I am seeing 4% LA State Sales Tax. Two smaller delimited zip code lists for local parishes (counties) seem to work fine.

With 717 zip codes the delimited list seems like it would be a memory drain. Any advice? Thanks!

jerrygarciuh:

Terrific addition to ZC! Thank you! Am testing a statewide rule for Louisiana where rule is 70001-to-71497 and search field is set to Zip Code. On test orders to Sarasota, FL 34236 (shipping and billing) I am seeing 4% LA State Sales Tax. Two smaller delimited zip code lists for local parishes (counties) seem to work fine.

With 717 zip codes the delimited list seems like it would be a memory drain. Any advice? Thanks!

It looks like your zip codes overlap in the list, the mod is based on looking up the zip codes, you should not have any zip code listed twice, even it it is in a range. In your example ID 3 overlaps those in ID 1 and 2. This will give unexpected results, change the range to something not in the other lists.

luckystu:

Greetings, if different tax rates for let's say 100 different counties and cities in one state are configured using this mod, do all 100 counties and cities show up in the drop-down menu during checkout? Thank you.

The short answer is no. You can see just what happens by doing a test checkout on this site https://www.1potteryhouse.com
The site is based in Florida, and has 64 counties with varying tax rates setup based on zip codes. The mode looks at the zip code of the ship too address you enter and does a lookup in the database tables to find the tax rate. The customer only has to enter a valid address, the mod uses that information.

Thank you for the reply! Somehow missed getting notification email. So module would not support multiple rule matches? Eg if a county in state has a rate of its own I must make a single rule applying county and state for the zip codes in county. The another rule or rules for all other zips in state to just get state tax?

Has anyone seen or built a module to connect to the Washington State Tax API ? http://dor.wa.gov/Content/FindTaxesAndRates/RetailSalesTax/DestinationBased/ClientInterface.aspx

Hello I just downloaded this mod and have a question. I have the sales tax rate table by zip code for South Carolina. I see various zip codes consist of 2 or more counties and may have different rates for respective counties. Can this module handle this issue or if not how can I handle it?

thanks

I believe the module searches by zip code for the tax rate so whatever county name it has isn't going to matter. The name of the county is really only there to display for the customer in checkout. As long as you've got the zip code assigned it's proper tax rate, you should be fine.

potteryhouse:

The short answer is no. You can see just what happens by doing a test checkout on this site https://www.1potteryhouse.com
The site is based in Florida, and has 64 counties with varying tax rates setup based on zip codes. The mode looks at the zip code of the ship too address you enter and does a lookup in the database tables to find the tax rate. The customer only has to enter a valid address, the mod uses that information.

This site does NOT calculate florida sales tax correctly. I put in 32092 for my zip code and it says 6% at checkout. It should add the St Johns County surtax of 0.5% which it did not

Anyone tried this mod on 1.5.5f? I installed 2.5.3a version and it worked fine for tax rate calculation. However, sales tax rate for store pickup is incorrect. It should be based on my store zipcode, but it is actually based on the zipcode from shipping address.

Finally I found a walkaround solution for the previous issue. Here is the link: https://www.zen-cart.com/showthread.php?209715-Flexible-Footer-Columns-Menu-for-1-5-x

By this modification, you can limit this Pickup option to postcodes surrounding your physical store location. I modified the 1.5.5f version storepickup.php, and it worked good. You need to remove your store pickup module over admin page and install it back again. Also "Shipping Zone" option is blank after you install pickup module. You need to change it back to your default zone, otherwise it may not function properly.

I tried to use TaxCloud plug-in, but it looks like its registration process is very complicated.

I tried to installed this mode on 157 with php7.2, unfortunately it doesn't work. It generated warning log like following:

#1 require_once() called at [/public_html/test/includes/autoload_func.php:37]
#2 require(/public_html/test/includes/autoload_func.php) called at [/public_html/test/admin/includes/application_top.php:37]
#3 require(/public_html/test/admin/includes/application_top.php) called at [/public_html/test/admin/login.php:8]
#4 require(/public_html/test/admin/login.php) called at [/public_html/test/admin/index.php:11]
--> PHP Warning: require_once(includes/init_includes/init_local_sales_taxes_install.php): failed to open stream: No such file or directory in /public_html/test/includes/autoload_func.php on line 37.

[30-Sep-2020 14:05:28 America/Boise] PHP Fatal error: require_once(): Failed opening required 'includes/init_includes/init_local_sales_taxes_install.php' (include_path='.:/opt/cpanel/ea-php72/root/usr/share/pear') in /public_html/test/includes/autoload_func.php on line 37

Any alternatives other than TaxCloud? I need to collect tax based on county or zipcode.

does the file ```
includes/init_includes/init_local_sales_taxes_install.php

Thanks for your reply. I re-upload all the files for this plug-in, and it worked on my 157! Thanks for your help!

There is a deprecated warning, and I added the following code to ot_local_sales_taxes.php and it is good now.

public function __construct()
{
// Constructor's functionality here, if you have any.
}

See note here: https://stackoverflow.com/questions/36339774/php7-constructor-class-name