Local Sales Tax Mod - Support Thread

[Defined By Eye]

Feature request

How much work would it be to reference the tax lookup tool instead of the database for all washington state taxes? You would be our hero if it could be implemented!

http://dor.wa.gov/Content/FindTaxesA...Interface.aspx

I've written a bit of PHP to send the city/state/zip and parse the URL results if you are interested.

[inkuyo]

Feature request

How much work would it be to reference the tax lookup tool instead of the database for all washington state taxes? You would be our hero if it could be implemented!

http://dor.wa.gov/Content/FindTaxesA...Interface.aspx

I've written a bit of PHP to send the city/state/zip and parse the URL results if you are interested.

I too would love to have it. I don't have the time right now, but will take a look more in depth. Had not been extremely important since most of my clients sales have been out of state. Local sales tax mod works OK but is a lot of manual input.

I need to correct an earlier comment about the calculation of SHIPPING versus BILLING address. That setting is done under --> configurtion --> my store --> Basis of Product Tax.

If you want to PM the PHP code you have written I can see if it can work as the basis. All in all it looks like it would be a mod of the local sales tax mod coding and be used for ONLY WA given that it calls for the sales tax codes in WA.

Maybe in the next few weeks I can take a closer look. It would make life easier, especially since the tax rates go up AGAIN on April first.

[nsirago]

Google Checkout Solution
----

I have only tested this for about 5 minutes but it worked every time. :) Give this a shot to incorporate this mod into your Google Checkout.

In gcheckout.php (on or around line 719 there is a SQL query, I changed mine to:

$tax_result = $db->Execute("SELECT
zen_tax_rates_local.local_tax_id,
zen_tax_rates_local.zone_id,
zen_tax_rates_local.local_fieldmatch,
zen_tax_rates_local.local_datamatch,
zen_tax_rates_local.local_tax_rate,
zen_tax_rates_local.local_tax_label,
zen_tax_rates_local.local_tax_shipping,
zen_tax_rates_local.local_tax_class_id
FROM
zen_tax_rates_local
WHERE
zen_tax_rates_local.local_datamatch = " . SHIPPING_ORIGIN_ZIP . "");

on or around line 743 you should see
$rate = ((double)($tax_result->fields['tax_rate']))/100.0;
change that to
$rate = ((double)($tax_result->fields['local_tax_rate']))/100.0;

I also got rid of a few lines. You won't be able to copy/paste my changes but this will definitely get you 80% there. I have pasted the entire foreach below. Modify as necessary. I'm doing zip code lookups. It will only work with zip codes.

foreach($tax_array as $tax_table)  {

    
   $tax_result =  $db->Execute("SELECT
zen_tax_rates_local.local_tax_id,
zen_tax_rates_local.zone_id,
zen_tax_rates_local.local_fieldmatch,
zen_tax_rates_local.local_datamatch,
zen_tax_rates_local.local_tax_rate,
zen_tax_rates_local.local_tax_label,
zen_tax_rates_local.local_tax_shipping,
zen_tax_rates_local.local_tax_class_id
FROM
zen_tax_rates_local
WHERE
zen_tax_rates_local.local_datamatch = " . SHIPPING_ORIGIN_ZIP . "");
                                          
  $num_rows = $tax_result->RecordCount();
  $tax_rule = array();


  $GAtaxTable = new GoogleAlternateTaxTable((!empty($tax_name_array[$i])?$tax_name_array[$i]:'none'), 'false');

  for($j=0; $j<$num_rows; $j++) {
    $tax_result->MoveNext();


    $rate = ((double)($tax_result->fields['local_tax_rate']))/100.0;
    $GAtaxRule = new GoogleAlternateTaxRule($rate);
	$GAtaxRule->SetStateAreas("CA");
		
    			
    $GAtaxTable->AddAlternateTaxRules($GAtaxRule);
  }
  $i++;
  $Gcart->AddAlternateTaxTables($GAtaxTable);  
}

[phoeuth]

First of all, Thank You for this mod. Ok I finally got this mod to work but I am having a few issue. Am using zen cart 1.3.8 and I am using PayPal Express as my only method of payment. My business is base in california and i set my tax rate for california at 7.25, then I use the local tax mod to calulate by zip code to add .50 to customers who I ship to in my county. It work flawlessly and my invoice on zen cart would read:

Sub-Total: $36.90
Zone Rates (Shipping to US): $9.80
CA Sales Tax: $2.68
92592 Local sales tax 0.50%: $0.18
Total: $49.56


But on my PayPal invoice it would read:

Item Amount:
$36.90 USD
Shipping:
$9.80 USD
Handling:
$2.68 USD
Quantity:
1
Sales Tax:
$0.18 USD

PayPal is using the ca sales tax data and reading it as Handling, and using the local sales tax as the sales tax. Is there a way to get PayPal to use my ca sales tax and the local sales tax and read it as sales tax only. I've read the above post but I was scared to use it since it was only 80% of the code and wouldn't be able to figure out the other 20%. Please help. Your knowledge is very much appreciated. Thanks in Advance.

[phoeuth]

Anyone please help. Someone gotta know how to fix this.

[LadyHLG]

phoeuth,
I'm sorry for the delay in responding, but the paypal modules are far from simple and it takes a while to track down an issue like this.

From what I can tell the problem is that the paypal mods are not setup to handle multiple taxes. Its only looking for one tax, it finds it and any difference in the total it simply adds it on as handling.

The other issue here is that I dont use paypal express, which makes the problem difficult to trouble shoot.

I will keep looking into it as best I can, but this may require the assistance of someone who is more familiar with the paypal payment mods than I am.

LadyHLG

[patternman]

LadyHLG, thank you again for the marvelous job you have done here.

I hope that you will still be able to release a quick patch/fix as I discovered a glitch/pitfall in the current version: If the customer enters a ZIP+4 code, and the Local Sales Tax Mod is configured to use Zip Codes (instead of city/town names), then the Mod will not calculate local tax for that customer.

In a way, it is similar to the problem of a user entering "S Royalton" or "S. Royalton" instead of "South Royalton"... except that the ZIP+4 code problem is easily solvable in the PHP code.

(BTW, limiting the customers to enter only 5 digits for the zip code as a workaround might not be a good idea as there are countries in which there are more than 5 characters in the zip code)

Hello,
I was wondering if there was any progress on this particular glitch. I am using ZIP+4 codes and this has become quite an obstacle.
Thank you.

[LadyHLG]

patternman,
Try this,
Open includes\modules\order_total\ot_local_sales_taxes.php

At about line 151 look for :

$listarray = explode(";", $taxto);

Just after that add the following:

// get only first 5 of zip code
if($taxmatch == "postcode"){
$myfield = substr($myfield,0,5);
}

This fix will only work when the CUSTOMER enters zip+4 NOT if the database is set up for zip+4!

Hope that helps!
LadyHLG

[patternman]

Awesome!
That worked just fine.
Thank you so much.

[Cafinity]

I need to charge a local tax on a specific type of product but no state tax on that product, on other product I need to charge both a state and a local tax.
Consumable items (like coffee) are not charged an Arizona sales tax but,
Consumable items (like coffee) are charged an Scottsdale City sales tax 1.65 %
Non Consumable (coffee pots) are charged a AZ sales tax 6.3 % and a Scottsdale sales tax of 1.65%

The mod is install and I have set up the local tax rate, but no local tax is charged.

I have set a seperate tax class for the the local tax, because the consumable product was being taxed at the state tax rate with no local tax included.
Any idea of where I am going wrong