david schultz dot org(dot com was taken)

#copy and paste to the bottom of
#app/design/frontend/default/theme_name/template/checkout/success.phtml
$companyID = "K123456"; #provided by Google
$category = urlencode("Your product category");
$lastorderid = Mage::getSingleton('checkout/session')->getLastOrderId();
$_order = Mage::getModel('sales/order')->load($lastorderid);
$orderID = $this->getOrderId(); #get the order ID
$aProduct = array();
$totalAmt = 0;
$prdsku = "";
$prdnm = "";
$prdqn = "";
$prdpr = "";
$prcatid = "";

###########store order data in array of objects###########
foreach ($_order->getAllItems() as $item) {
	$oProduct = new stdClass();
	$oProduct->sku = $item->getSku(); #sku
	$oProduct->price = $item->getPrice(); #price
	$totalAmt = $totalAmt + ($oProduct->price * $item->getQtyOrdered()); #total amt (excl.tax/shipping)
	$oProduct->qty = $item->getQtyOrdered(); #quantity
	$oProduct->name = $item->getName(); #product name
	$oProduct->category = $category;
	array_push($aProduct, $oProduct);
	$oProduct = NULL; #nuke it
}
###########build query string variables###########
for ($i=0; $i < count($aProduct); $i++) {
	if ($i == count($aProduct)-1) {
		$prdsku .= urlencode($aProduct[$i]->sku);
		$prdnm .= urlencode($aProduct[$i]->name);
		$prdqn .= urlencode($aProduct[$i]->qty);
		$prdpr .= urlencode($aProduct[$i]->price);
		$prcatid .= urlencode($aProduct[$i]->category);
	} else {
		$prdsku .= urlencode($aProduct[$i]->sku) . "^";
		$prdnm .= urlencode($aProduct[$i]->name) . "^";
		$prdqn .= urlencode($aProduct[$i]->qty) . "^";
		$prdpr .= urlencode($aProduct[$i]->price) . "^";
		$prcatid .= urlencode($aProduct[$i]->category) ."^";
	}
}
?>

7 comments

1. Jay Martin

   December 16, 2009 at 6:59 AM

   Magento is tests your patience but overall they seem to be the best free cart out there.

   Do you have experience with any other cart bundles like this, and this is our favorite? Or is this the first one you’re trying?
2. Jay Martin

   December 16, 2009 at 7:00 AM

   I love 6am grammar
3. David Schultz

   December 16, 2009 at 10:12 AM

   To be honest before we settled on Magento we didn’t really try anything else. One of the other guys had used OSCommerce and i looked at it briefly, but it seemed neglected. Magento appears to have a vibrant community of developers, like WordPress or Drupal.

   There are some things about Magento that drive me crazy though. The “plumbing” has a steep learning curve, and there seems to be a few problems with their checkout in IE 6.0 that are stumping us (that problem should get better over time). I also wish it was easier to insert my own custom PHP / database calls – have been using iFrames to get things done fast (lame i know)…If i’d give WordPress a 9/10 overall, i’d give Magento a solid 6.5/10.
4. Mecute

   February 13, 2010 at 2:20 PM

   Hi david,
   I try to in put the as listed above only difference being the $companyID = “K123456″ to my id.

   I am very newbie at this so please understand.

   I copy/pasted exactly as listed above to my success.phtml and the entire code above is actually displaying on the success page, and also when i see the source for the success page it is not showing any values but just showing exactly as shown above. it is displaying as if its just text and not some kind of script or code.

   What am i doing wrong?

   Thanks,
   Lee
5. David Schultz

   February 16, 2010 at 4:45 PM

   Hey Mecute – maybe check how your web server PHP config is set to handle <? vs <?php since it sounds like it is having trouble knowing when to interpret PHP code.
6. Mecute

   February 19, 2010 at 4:53 PM

   If not a big deal could you please email me the same codes above production ready? thank you so much!
7. Dan Myers

   April 8, 2010 at 9:59 AM

   Thanks for this chunk of code. Saved me a bigger headache than I already have!!

   Mecute, make sure you add the php opening tag “<?php" before this chunk of code.

   David,
   I suggest you take a look at UberCart. I operate both Magento installs and UberCart installs for my customers. While it's not as powerful as Magento overall, I find it meets all of the needs of 90% of my customers. As for OS Commerce, you're right, it's been all but abandoned. It's big brother, Zen Cart is much more supported, but has no where near the community support as Magento or UberCart.