Google Checkout with JROX Affiliate Manager

I'm setting up a ZenCart site for a client, and they are really excited about using Google Checkout because of the FREE merchant processing through the end of the year, and because of the fact that for every $1 you spend on Google Adwords, they credit you $10 in merchant processing fees.

At present, the problem is that they also want to employ an affilaite program. I used to recommend another product, but have now switched to recommending JROX because I've heard good things about thier support and impressed by their activity here on the ZenCart forums.

The problem with either of these systems in conjuction with ZenCart is that (from my understanding) rely on control being returned to "checkout_success.php", and Google Checkout doesn't do that.

From my understanding, Google Checkout uses a callback URL to let ZenCart know when the status of an order has changed. Based on that, I would imagine that JROX integration code would need to be incorporated into "googlecheckout/responsehandler.php", or some other routines that are initiated from Google Checkout.

Unfortunately I'm not a PHP developer, and in fact completely left the software development world a few years back. From my observation, the dust hasn't completely settled in regard Google Checkout and ZenCart integration, but I was wondering if anyone was doing work with adding Affiliate software integration to the mix.

Thanks in advance for any assistance.

Sincerely,

Jeff Sohler
https://www.EnrichmentUnlimited.com

Don't resist LIFE! Accept every moment as if you had chosen it.

jsohler:

At present, the problem is that they also want to employ an affilaite program. I used to recommend another product, but have now switched to recommending JROX because I've heard good things about thier support and impressed by their activity here on the ZenCart forums.

JROX has the best support out here. I switched to them to host my sites. Every time I needed support, the response time was measured in minutes, not days. They were always able to help me, smart people over there. Can't say enough good things about them. <shameless unpaid plug>

jsohler:

From my understanding, Google Checkout uses a callback URL to let ZenCart know when the status of an order has changed. Based on that, I would imagine that JROX integration code would need to be incorporated into "googlecheckout/responsehandler.php", or some other routines that are initiated from Google Checkout.

I'm going to be putting up a test host to see if I can get this going myself. If I can't get them both working together. If you make any progress, let me know.
.

Hello,

We would like to test this option as well. We'll look at the Google Integration Code and see what we can do to get this integrated with JAM.

Jroxonline,

We're still waiting for the Google Leve 2 Checkout module that's available here on the ZenCart site to stabalize.

MagneticOne claims to offer a complete Google Checkout Level 2 module that supports attribute based pricing, taxes and standard/custom shipping modules.

I'm asking for feedback to find out how stable their module is, as we may move forward with it because we want to take advantage of the FREE merchant processing the Google is offering through the end of the year. It may actually be worth paying for a module that is stable and complete now (if it is).

I'm hoping that you might also work with them on integration, as I would imagine it might be slightly different.

Please keep us posted!

Sincerely,

Jeff Sohler
https://www.EnrichmentUnlimited.com

I'm working on this right now. I tried integrating jrox by hand into the google checkout responsehandler.php

So far it doesn't work. I finally figured out that the reason: it checks for cookies. responsehandler.php is getting run on the server, not the end users local computer (with the cookie). I will post a solution if/when i find one.

Brian

krypton1,

Any chance you can send us that code so we can play with it as well? We're not familiar with the google checkout process yet, but it sounds like they do something similar to what Paypal does with IPN.

Do they allow you to add custom variables to the Google checkout button before it is clicked?

Okay... We got something working for the Zencart Google Checkout Module and JAM integration.

First, we used the following to test:

1. Zencart 1.3.6 default install from Fantastico (no addon modules)
2. The Google Checkout Module for Zen Cart, the latest available download available here:

http://www.zen-cart.com/index.php?main_page=product_contrib_info&cPath=40_48&products_id=314

Here's the instructions.

1. First, make sure you integrate the Google Checkout Module for Zen Cart per their instructions.

2. Test it using the Google Checkout Sandbox, and make sure Google Checkout is working for you as expected.

3. When you transactions are posting properly to Zen Cart, you can now make some edits to the module.

4. Open up and edit /googlecheckout/gcheckout.php file and make the following edits starting at or around line 160:

$gcheck->push('merchant-private-data');
$gcheck->element('session-data', $private_data);
$gcheck->element('product-data', $product_list);
$gcheck->element('ip-address', $_SERVER['REMOTE_ADDR']); //add ip address of customer. - added by colosports
** if (!empty($_COOKIE['jrox']))
{
$gcheck->element('jam-cookie', $_COOKIE['jrox']);
}**
$gcheck->pop('merchant-private-data');

5. Save this file. Open up /googlecheckout/responsehandler.php and make the following edits at or around line 212:

                       'class' => $order_totals[$i]['code'],
                            'sort_order' => makeSqlInteger($order_totals[$i]['sort_order']));
    zen_db_perform(TABLE_ORDERS_TOTAL, $sql_data_array);
   

   }

   ** ##############################

   SET JAM AFFILIATE COOKIE

   ##############################
   if(isset($data[$root]['shopping-cart']['merchant-private-data']['jam-cookie'])) {
   $jam_cookie = $data[$root]['shopping-cart']['merchant-private-data']['jam-cookie'];
   $url = "http://www.domain.com/affiliates/sale.php?amount=".$data[$root]['order-total']."&trans_id=".$data[$root]['google-order-number']."&custom_mid=".$jam_cookie;
   $ch = curl_init($url);
   curl_setopt($ch, CURLOPT_HEADER, 0);
   curl_setopt($ch, CURLOPT_RETURNTRANSFER, 1);
   $resp = curl_exec($ch);
   curl_close ($ch);
   }
   ##############################

   END JAM AFFILIATE COOKIE

   ##############################**
   break;
   }
   case "order-state-change-notification": {
   process_order_state_change_notification($root, $data, $message_log);
   break;
   }

6. Save the file and upload. Make sure to change https://www.domain.com/affiliates to point to your JAM install.

7. Test it. Click on an active affiliate URL, do a test transaction and select Google Checkout as your payment option. Check to make sure the transaction is inserted into Zen Cart as well as the commission being generated in JAM.

Holler if you have any questions.

Ryan

lol!! Ryan!

I stayed up all night last night coming up with my own fix for this. After much hours of head banging I finally wake up this morning, and come here to proudly display it to the world, and wham...you beat me to it.

Damn!

I did it almost the same way except I used the IP address instead of the cookie (and it required a small change in affiliate/sale.php) so I think your version is better.

Oh well, at least we got it working. This is huge since Google is offering free processing through all of 2007, a ton of people are going to want to use this fix.

Thanks!
Brian

PayPal is offering free credit card transaction processing too and $100 Yahoo Ad Word credit.

You can sign up here: **http://www.zen-cart.com/getpaypal**

jnetmcp

www.infaithwear.com

Inspire Change...

jroxonline:

Okay... We got something working for the Zencart Google Checkout Module and JAM integration.
First, we used the following to test:

1. Zencart 1.3.6...
   Holler if you have any questions. Ryan

Ryan, do i still have to do the same thing, if using zencart 1.3.8a?

thanks in advance.