JROX JAM not tracking all the way to sale?

Using 1.3.8
Jrox JAM affiliate tracking from link
checkout_success page shows the info on the Source Code that it is trying to send Sale $ and Order # :

could the tracking cookie from the link be getting knocked out when the customer goes from unsecure to SSL secure pages on my site --> shopping cart?

-Clicks are getting registered.
-I am using the check/money order method of payment. (Credit Card Payment is not on test and will only proccess real sales)
-Shopping cart only goes SSL secure once customer logs-into account.
-My site has its own SSL ( https://www.paynemasonexclusive.com/exclusive.html )

Any thoughts?

Your post is somewhat cryptic. Apparently something's not working. But from the browser code you posted, it's apparently pulling the right data from Zen Cart. Although your URL looks funny, but that'll be how you typed it in.

I'm having the same issue.. I installed the the program works, downloaded and installed the zen-cart intergration from the jam website... login works everything made a fake login account posted my banner made a order with a money order, and it didn't record the order on jam ?Same issue as listed above

I'm having this problem too, and am on the JROX forums looking for an answer too.

Basically, the issue is that JAM is not recording commissions as a result of the checkout_success footer integration. It does however count the affiliate clicks. Also, according to my and danwebman's source code the correct sale/id info is being generated.

The problem is that JAM's "sale.php" page doesn't seem to be getting the information that the intergration code is sending.

My only difference from danwebman is that only my Zen checkout uses SSL, and the rest of the site doesn't.

Additional:

Here's the intergration code I use (generates what it's supposed to according to the page source)

$JAM = $db->Execute("select * from " . TABLE_ORDERS_TOTAL . " where orders_id = '".(int)$orders->fields['orders_id']."' AND class = 'ot_subtotal'");
$TotalAmount = number_format($JAM->fields['value'],2,'.',',');
$TransID = $JAM->fields['orders_id'];
echo "<script language="JavaScript" type="text/javascript" src="https://www.MYSITEHERE.com/affiliates/sale.php?amount=".$TotalAmount."&trans_id=".$TransID."></script>";

On your Zen Cart site, when your checkout-success is displayed on-screen, if you use your Browser's menu to View Source, and you see a valid link to your JAM site, with order number and amount inserted in the proper places, then the Zen Cart side of things is fine.

Thus, if the order is not being recorded on the JAM side, then I suspect you've got something incorrectly set up on the JAM side. Maybe you didn't set up a program to which the sales will be tracked? etc?

What happens of you copy-and-paste the JAM URL from your View Source into your browser's address bar and go to that page directly? If you get a page-not-found or forbidden or some other sort of error, then maybe you've set up the wrong URL in your Zen Cart side?

So I entered the https: that I got out of my checkout_success Source Code:

The https: from my previous post:
https://www.paynemasonexclusive/affiliates/sale.php?amount=13.00&trans_id=17

and got nothing... what should be comming thru there? Where should i look for help... JROX JAM has no live support-no phone #- and forums have been a ghost town for support??? I have to take care of this asap andI'm willing to try anything. I know there are a ton of people with my same problem, because I keep getting mail from them, unfortunately no-one with a solution! Past or Present. I want to be able to help them with this misery too!!! Anyone please contribute and help, this is essential to my business that it gets taken care of immediately. Thanks,

Dan

p.s.- I too have a site that only goes SSL secure in the shoping cart when the custome logs-in, like I said in my first post. The rest of the site is not secure. Is there any way the tracking cookie from my affiliate link is getting messed up along the way to the checkout success?? I don't know, I'm trying to think of everything!

Also this is comming up on the thank you page source code:

---without the .com---even though I have the code correctly with:

if (isset($zv_orders_id) && (int)$zv_orders_id > 0 && isset($order_summary) && is_array($order_summary)) {

if (!isset($_SESSION['affiliate_order_id']) || $_SESSION['affiliate_order_id'] != $zv_orders_id ) {

  $_SESSION['affiliate_order_id'] = $zv_orders_id;

 $commissionable_order_formatted = number_format($order_summary['commissionable_order'], 2, '.', '');

 echo '<script language="javascript" type="text/javascript" src="https://www.paynemasonexclusive.com/affiliates/sale.php?amount=' . $commissionable_order_formatted . '&trans_id=' . $order_summary['order_number'] . '"></script>';

}

}

Does that mean that there is something written wrong elsewhere? Another file? Where is this code going?

danwebman:

Is there any way the tracking cookie from my affiliate link is getting messed up along the way to the checkout success??
I know the cookie has nothing to do with how Zen Cart prepares the output to send to JAM. But it may be related to what happens after the sale is transmitted. Perhaps you have something configured wrong in your JAM setup?

Then I can't quite figure out where the hang up is? I am now getting a generated code from my checkout_success page Source code that points directly to my JAM folder in my directory:

.....https://www.paynemasonexclusive.com/jamaffiliates/sale.php?amount=48.00&trans_id=23....

It should communicate with the /jamaffiliates/sale.php file and then that /sale.php file will send it to JROX JAM? If that is correct, how can I check if the /sale.php is working?

danwebman:

.....https://www.paynemasonexclusive.com/jamaffiliates/sale.php?amount=48.00&trans_id=23....

It should communicate with the /jamaffiliates/sale.php file and then that /sale.php file will send it to JROX JAM? If that is correct, how can I check if the /sale.php is working?

Assuming that sale.php is part of the JAM software installed in your "jamaffiliates" folder, then that IS your JROX JAM. So, yes, it should be receiving that data and recording the sale.

If it's not doing that, then ... well ... that's a question for the JROX folks.

this looks correct, but you should check your /includes/config.php for JAM to see if your JAM cookie domain is correctly set:

define("COOKIE_DOMAIN", "yourdomain.com");

it should be the full domain only, no subdomains.

So just to post my Successful Solution to this issue due to the fact I saw a ton of posts on this subject:

1)Make sure your Affiliate Tracking Code you place in the checkout_success/tpl_footer.php is set up to communicate with the folder you have set up in your domain folder under (whatever you named the first folder when you uploaded all the JAM files)
ex: .....<"img src="http:https://www.YOURDOMAIN.com/NAME_OF_JAM_FOLDER/sale.php.........
----(you can check to see IF and WHAT the affiliate code is generating by viewing the source code when you are on the checkout_success page otherwise known as Thank You! page. Just click on the VIEW tab of your browser--->and click SOURCE)

2)Make sure your code in that sale.php document is all correct and communicates the code from your checkout_sucess page:
-http://forums.jrox.com/index.php/topic,3325.0.html

3. Go to your NAME_OF_JAM_FOLDER/includes/config.php
   and imput all of the obvious places to put your info:
   ex: define("COOKIE_DOMAIN", "yourdomain.com");

it should be the full domain only, no subdomains. (like: www.)
-there are a group of places you will see it is asking for: yourdomain.com
I assume it was supposed to be written to the file automatically for me at some point during installation etc... but didn't?

****So these fixes got me out of the doghouse with this JROX JAM after days!! of frustration and limited help. I don't know what will work for you, but I will tell you that expect to try and solve it on your own. Help is limited! These steps got me working. I hope I can help you! ******
THANKS!!! To everyone who contributed and offered help!! It all helped me take steps toward my glorious day of success :) Thank You,

Dan

Thanks Dan, jroxonline, and DrByte; I've gotten mine working too ... mostly.

I too was missing the URL in:

define("COOKIE_DOMAIN", "yourdomain.com"

Now the new problem. It won't record commissions from the Internet Explorer browser (V6 or V7).

So far my theory is that it must be a Javascript issue. Although I use Javascript heavily on the rest of the site without a problem, and the code IS generated on the checkout_success page ...

If your JAM config.php content shows the COOKIE_DOMAIN define exactly as you posted above, then you've got a syntax error. You need a closing ) and ;

Thank you DrByte. I had copy/pasted that from another post - my bad.

My actual line appears to be correct:

define("COOKIE_DOMAIN", "mysite.com");

Well, if the customer visits your site via the affiliate URL, then the cookie should be set. Then, after they complete the sale, if the javascript is properly showing on the browser, the cookie and the javascript should combine together when talking to the affiliate sale.php script, thus recording the sale.

If it's not doing that and you've confirmed that the javascript is showing in your browser HTML, you'll need to get support from the JAM site.

It most likely how you have the tpl_footer.php directing... you have to have it point to where your sale.php is located. I found my error in the footer it says to put it like this:
File: includes/templates/custom/checkout_success/tpl_footer.php
if (isset($zv_orders_id) && (int)$zv_orders_id > 0 && isset($order_summary) && is_array($order_summary)) {
if (!isset($_SESSION['affiliate_order_id']) || $_SESSION['affiliate_order_id'] != $zv_orders_id ) {
$_SESSION['affiliate_order_id'] = $zv_orders_id;
$commissionable_order_formatted = number_format($order_summary['commissionable_order'], 2, '.', '');
echo '<script language="javascript" type="text/javascript" src="http://www.yourdomain.com/affiliates/sale.php?amount=' . $commissionable_order_formatted . '&trans_id=' . $order_summary['order_number'] . '"></script>';
}
}

Most likely the http://www.yourdomain.com/affiliates/sale.php?amount= is wrong...
Try replacing that with this:
http://www.yourdomain.com/jamaffiliates/sale.php?amount=

look through your ftp program and see where you installed your jama and find the sale.php file. Then direct the domain above to that sale.php

-Ryan

I am also having this same problem and I have gone through all the tips here for changing the files, but the commission is still not caluclating. It's recording the clicks as others have said.

I checked the source code and it does not look like it is pulling anything from the sale.php

I want to double check that I did place the tpl.footer in the right place:

In includes/templates/classic I then added the new folder checkout_success with the tpl.footer

I had edited the file as instructed and checked, and rechcked.

It seems like it may be in the wrong place because how does the current checkout page know to communicate with this new footer file I created?

I'm so confused!! :blush:

if the checkout_success page HTML source does not show the JAM code, then you may have put the template override file in the wrong theme folder.

also, if you are using a shared SSL certificate, you will have issues with tracking in Internet Explorer as that browser does not allow tracking via third party domains without a P3P privacy policy.

you will have to setup a P3P privacy policy on the domain where JAM is installed so that tracking is allowed on third party domains.