Local Sales Tax Mod - Support Thread

[artcoder]

My problem is that when I create a new Local Sales Taxes. The "Edit Tax Rate" has a Zone drop list for me to select the zone. But the drop list is empty. It only have "Select Zone". I want to select a zone of new york.

In "Admin -> Locations/Taxes -> Zones", I do have four pages of zones listing all the states (including new york).

In "Admin -> Configuration -> customer Detail -> State -Always display as pulldown" I have set as true.

I had installed 2.2 and 2.3 and ran the SQL statements. All else seems well. Except I can not select zone in the drop list.

Any ideas?

[LadyHLG]

Thank you LadyG

can a dropdown be used for the suburbs?

It can be done but will require quite a bit of hacking. There use to be directions on this but its been a long time since I've seen anything.

LadyHLG

[webman1]

It can be done but will require quite a bit of hacking. There use to be directions on this but its been a long time since I've seen anything.

LadyHLG

last question...I think.

do you know where that suburb field lives?

thanks.

[LadyHLG]

I'm afraid not. I can tell you the field isn't in just one file as there are a couple of places where it can be edited.

LadyHLG

[ptogel]

How do you turn off the debugging for this module?

[LadyHLG]

Modules -> Order Total -> Local Sales Taxes ->
Debugging is active = False

LadyHLG

[jabbawest]

I'm looking for a Module that will recognize when someone from my state makes a purchase and will then automatically add my local sales tax rate to their total.
Will this module accomplish that?

Thank you,

Stephen

[artcoder]

I'm looking for a Module that will recognize when someone from my state makes a purchase and will then automatically add my local sales tax rate to their total.
Will this module accomplish that?

yes, it will.

[awesome]

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);  
}

Sorry for the long quote, but this is the only post I can find related to local sales tax and Google Checkout.

I have ZC v 1.3.8a, Local Sales Tax 2.2 upgraded to 2.3, Google Checkout 1.4.7. Before I added the Local Sales Tax I was able to get to GC from my cart. With LST I get a page at GC that says:

"OOPS. We were unable to process your request."

I tried to implement this revision, changed zen_tax_rates_local to tax_rates_local since that is the current name of the table, and changed the SetStateAreas to "WA" since I am in Washington. I still get the OOPS message. I set the GC sort order to 99 thinking that might get to GC after calculating the tax. No luck there either.

Any help would be appreciated. I see a lot of other folks from Washington here with problems created by our tax structure.

[jabbawest]

Really, I am trying to understand the instructions in the 2.3 readme but, what I really need this module to do is make everyone in the state of Texas pay the sales tax of 8.25%.

Do I need to make ALL of the per county edits to make this happen?

Thank you