OK. I have the solution to two problems. But unfortunately, I have no idea what is going on with alan_powerbrixx's error message. That is a strange one... 1.3.8 seems to work for me with this mod.
dscott1966 -- I had the same problem with the blank error page. See the earlier posts. The cart not clearing may just be something that the author overlooked. Not too huge of a deal. Not getting them in GC probably means something is wrong with responsehandler. Don't know what exactly, but that is the file I would be looking at. Also, are you sure you defined the responslehandler.php file in your GC account under Integration? Otherwise, GC doesn't know where to send the information to.
Here are the two problems I solved:
- Page stops loading when a customer is logged in and they go to their shopping cart page. This only happens when the shipping estimator is turned on for the shopping cart page AND a user is logged in. The problem is that orders.php is getting loaded twice when google checkout is used and the shipping estimator is used. To fix this problem, change these lines in /includes/modules/shipping_estimator.php:
// include the order class (uses the sendto !)
require(DIR_WS_CLASSES . 'order.php');
$order = new order;
You just need to comment these lines out, so the new code should look like:
// include the order class (uses the sendto !)
// require(DIR_WS_CLASSES . 'order.php');
// $order = new order;
PLEASE NOTE: This will break your shopping cart unless you use Google Checkout. So if you ever stop using google checkout, you will need to undo this change.
- Taxes don't work or you want to use more complicated tax rules. The bad news is that this mod has some serious tax flaws. The good news is that the author created some easy to use tax functions, so creating your own tax rules directly in the code is easy to do! Here's how to create your own tax rules:
In /googlecheckout/gcheckout.php, go the end of the file. You want to cut out the following code right under the line "// Tax options":
if(sizeof($tax_class_unique) == 1 && sizeof($module_info_enabled) == sizeof($tax_class)) {
$tax_result = $db->Execute( "select distinct countries_name, coalesce(zone_code, 'All Areas') zone_code, tax_rate, countries_iso_code_2
from " . TABLE_TAX_RATES . " as tr " .
" inner join " . TABLE_ZONES_TO_GEO_ZONES . " as ztgz on tr.tax_zone_id = ztgz.geo_zone_id " .
" inner join " . TABLE_COUNTRIES . " as c on ztgz.zone_country_id = c.countries_id " .
" left join " . TABLE_ZONES . " as z on ztgz.zone_id=z.zone_id
where tr.tax_class_id= '" . $tax_class_unique[0] ."'");
$num_rows = $tax_result->RecordCount();
$tax_rule = array();
for($j=0; $j<$num_rows; $j++) {
$tax_result->MoveNext();
$rate = ((double) ($tax_result->fields['tax_rate']))/100.0;
$GDtaxRule = new GoogleDefaultTaxRule($rate, 'true');
if($tax_result->fields['countries_iso_code_2'] == 'US') {
if($tax_result->fields['zone_code'] == 'All Areas') {
$GDtaxRule->SetCountryArea('ALL');
}
else {
$GDtaxRule->SetStateAreas($tax_result->fields['zone_code']);
}
}
else {
$GDtaxRule->AddPostalArea($tax_result->fields['countries_iso_code_2']);
}
$Gcart->AddDefaultTaxRules($GDtaxRule);
}
} else {
$GDtaxRule = new GoogleDefaultTaxRule(0, 'false');
$GDtaxRule->SetWorldArea(true);
$Gcart->AddDefaultTaxRules($GDtaxRule);
}
if(sizeof($tax_class_unique) > 1 || (sizeof($tax_class_unique) == 1 &&
sizeof($module_info_enabled) != sizeof($tax_class) )) {
$Gcart->SetButtonVariant(false);
$Gwarnings[] = GOOGLECHECKOUT_STRING_WARN_MULTIPLE_SHIP_TAX;
}
You can just comment this out if you don't to remove it by adding /* to the beginning and */ to the end of this.
Then, you want to create your own tax rules to replace this code. Here is the basic format to do so:
$GDtaxRule = new GoogleDefaultTaxRule('.0725', 'false');
$GDtaxRule->SetStateAreas('CA');
$Gcart->AddDefaultTaxRules($GDtaxRule);
This would create a 7.25% tax for all of California. Change the rate to anything you want. The false that follows it means that tax will not be calculated for shipping -- only the products. Change to true if shipping should be taxed. Then, the SetStateAreas allows you to select a state that is taxed. For multiple states, use an array. Use the two character state code, ex: OR=Oregon.
If you want to define the tax rules by zip code, change SetStateAreas function to SetZipPatterns. You can use * as a wildcard, so the following code would tax someone at 5% including shipping for anyone at zip codes beginning with 11:
$GDtaxRule = new GoogleDefaultTaxRule('.05', 'true');
$GDtaxRule->SetZipPatterns('11*');
$Gcart->AddDefaultTaxRules($GDtaxRule);
You can also use an array for the zip patterns function, allowing you to pick and choose zip codes from your county, or create other complicated zip code by zip code tax rules.
If you define two areas that have some overlap, the first definition has priority. So, in this example, I have created an array with all the zip codes in Los Angeles County. LA County gets charged 8.25%. The rest of California gets charged 7.25%. I must put LA Country first, otherwise all of California, including LA County, will get charged 7.25% because the first definition has priority in a conflict:
$GDtaxRule = new GoogleDefaultTaxRule('.0825', 'false');
$GDtaxRule->SetZipPatterns(array(90001,90002,90003,90004,90005,90006,90007,90008,90009,90010,90011,90012,90013,90014,90015,90016,90017,90018,90019,90020,90021,90022,90023,90024,90025,90026,90027,90028,90029,90030,90031,90032,90033,90034,90035,90036,90037,90038,90039,90040,90041,90042,90043,90044,90045,90046,90047,90048,90049,90050,90051,90052,90053,90054,90055,90056,90057,90058,90059,90060,90061,90062,90063,90064,90065,90066,90067,90068,90069,90070,90071,90072,90073,90074,90075,90076,90077,90078,90079,90080,90081,90082,90083,90084,90086,90087,90088,90089,90091,90093,90094,90095,90096,90101,90102,90103,90189,90201,90202,90209,90210,90211,90212,90213,90220,90221,90222,90223,90224,90230,90231,90232,90233,90239,90240,90241,90242,90245,90247,90248,90249,90250,90251,90254,90255,90260,90261,90262,90263,90264,90265,90266,90267,90270,90272,90274,90275,90277,90278,90280,90290,90291,90292,90293,90294,90295,90296,90301,90302,90303,90304,90305,90306,90307,90308,90309,90310,90311,90312,90313,90397,90398,90401,90402,90403,90404,90405,90406,90407,90408,90409,90410,90411,90501,90502,90503,90504,90505,90506,90507,90508,90509,90510,90601,90602,90603,90604,90605,90606,90607,90608,90609,90610,90623,90630,90631,90637,90638,90639,90640,90650,90651,90652,90659,90660,90661,90662,90665,90670,90701,90702,90703,90704,90706,90707,90710,90711,90712,90713,90714,90715,90716,90717,90723,90731,90732,90733,90734,90744,90745,90746,90747,90748,90749,90755,90801,90802,90803,90804,90805,90806,90807,90808,90809,90810,90813,90814,90815,90822,90831,90832,90833,90834,90835,90840,90842,90844,90845,90846,90847,90848,90853,90888,91001,91003,91006,91007,91009,91010,91011,91012,91016,91017,91020,91021,91023,91024,91025,91030,91031,91040,91041,91042,91043,91046,91066,91077,91101,91102,91103,91104,91105,91106,91107,91108,91109,91110,91114,91115,91116,91117,91118,91121,91123,91124,91125,91126,91129,91131,91175,91182,91184,91185,91186,91187,91188,91189,91191,91201,91202,91203,91204,91205,91206,91207,91208,91209,91210,91214,91221,91222,91224,91225,91226,91301,91302,91303,91304,91305,91306,91307,91308,91309,91310,91311,91312,91313,91316,91321,91322,91324,91325,91326,91327,91328,91329,91330,91331,91333,91334,91335,91337,91340,91341,91342,91343,91344,91345,91346,91350,91351,91352,91353,91354,91355,91356,91357,91361,91362,91363,91364,91365,91367,91371,91372,91376,91380,91381,91382,91383,91384,91385,91386,91387,91388,91390,91392,91393,91394,91395,91396,91399,91401,91402,91403,91404,91405,91406,91407,91408,91409,91410,91411,91412,91413,91416,91423,91426,91436,91470,91482,91495,91496,91497,91499,91501,91502,91503,91504,91505,91506,91507,91508,91510,91521,91522,91523,91601,91602,91603,91604,91605,91606,91607,91608,91609,91610,91611,91612,91614,91615,91616,91617,91618,91702,91706,91709,91711,91715,91716,91722,91723,91724,91731,91732,91733,91734,91735,91740,91741,91744,91745,91746,91747,91748,91749,91750,91754,91755,91756,91759,91765,91766,91767,91768,91769,91770,91771,91772,91773,91775,91776,91778,91780,91788,91789,91790,91791,91792,91793,91795,91801,91802,91803,92397,93243,93510,93523,93532,93534,93535,93536,93539,93543,93544,93550,93551,93552,93553,93560,93563,93584,93586,93590,93591,93599));
$Gcart->AddDefaultTaxRules($GDtaxRule);
$GDtaxRule = new GoogleDefaultTaxRule('.0725', 'false');
$GDtaxRule->SetStateAreas('CA');
$Gcart->AddDefaultTaxRules($GDtaxRule);
There are several other functions you can use, but Zip Code and State were the most useful for me. The list of function includes:
SetStateAreas
SetZipPatterns
AddPostalArea
SetWorldArea
SetCountryArea
You can infer what these functions do if you poke around where they are defined. You will find them all in /googlecheckout/library/googletax.php.
I hope someone finds this useful.
