WPSC WP E-Commerce Shopping Cart 3.6.12 Google Checkout Shipping

It turns out that, among other things, WPSC can’t calculate shipping properly when linked to Google Checkout when using a flat-rate shipping method.

Surprise, Surprise.

We found a fix:

shopping_cart_functions.php around line 295 had the following as a method for calculating shipping:

$pnp += $wpdb->get_var(“SELECT SUM(pnp) FROM “.$wpdb- >prefix.”product_list WHERE id IN (“.$google_product_id.”)”);

That’s great – except that it doesn’t take into account the possibility that someone could order MORE THAN ONE ITEM. Like that ever happens in the e-commerce world. Maybe it just doesn’t happen in New Zealand. But here in the great U S of A, people often times buy more than one item.

So we changed the above line to:

foreach((array)$_SESSION['nzshpcrt_cart'] as $cart_item) { $product_id = $cart_item->product_id; $quantity = $cart_item->quantity; $pnp += nzshpcrt_determine_item_shipping($product_id, $quantity, $_SESSION['delivery_country']); }

Which was conveniently stolen from some other file.

The logic here is bad, too – only because I have a feeling nzshpcrt_determine_item_shipping looks up in the database for each item its price. Ideally the price should be stored locally as part of the nzshpcrt_cart array of cart objects, as quantity and description already are. Of course we were going to do that much, we might as well just re-write the entire plugin – properly, of course – and send the original developers packing.

Hope that helps.