Affiliate Trail Integration

[AdrielGreene]

Hello ZenCart Community!

I've recently installed Zencart v1.3.9d with no addons.

I am attempting to integrate a 3rd party affiliate program called Affiliate Trail to my shop. The integration seems simple enough, I just add this code to my confirmation page:

<img src="http://www.yourdomain.com/affiliate/scripts/sale.php?TotalCost=
XXXXXX.XX&OrderID=XXXXXX&ProductID=XXXXXX" width=1 height=1>

Where src="the page on my domain"
Where TotalCost= the orders total cost

OrderID and ProductID aren't neccesary so the new code looks like:

<img src="http://www.yourdomain.com/affiliate/scripts/sale.php?TotalCost= XXXXXX.XX" width=1 height=1>

My question is therefore:

What is the variable that Zencart uses as a "TotalCost" once an order is confirmed?

[dbltoe]

sounds like a question for http://www.affiliatetrail.com/support/contact.htm

[AdrielGreene]

I've tried and I've gotta say - they are slow to respond. I'm also a bit afraid of a standard "use the total cost variable for ZenCart" message instead of a strait answer.

[dbltoe]

They are quick to list Zen Cart compatibility in one area of their site, but when it gets down to the actual list, ZC ain't there.

Just because particular shopping cart is not listed, do not worry, the chances are that XxYyZz product will work 100%

does not make me feel too confident.

I'd also be concerned about the product working with newer versions of PHP and MySql.

[AdrielGreene]

That lack of confidence is legitimate.

"As stated earlier virtually 100% of shopping carts will work with Affiliate Trail"

Tried to set this up for a friend using Godaddy Quick shopping cart and it was a no go. Their cart allows you to add some variables in the receipt, just not the total cost. Affiliate Trail should state this conditional.

[AdrielGreene]

Just received a response from affiliate trail. I haven't tested it yet but I will be confirming asap for others:

"
1. Locate the following file: /zencart/tpl_checkout_success_default.php.
2. Find this code in the file: fields['orders_id']; ?>
3. Copy/Paste the following code into the file (just under "fields['orders_id']; ?>")

$affcode = $db->Execute("select * from " . TABLE_ORDERS_TOTAL . " where orders_id = '".(int)$orders->fields['orders_id']."' AND class = 'ot_subtotal'");
$var1 = (number_format($affcode->fields['value'],2));
$var2 = $affcode->fields['orders_id'];
echo ("<img src=\"http://YOURSITE.com/affiliate/scripts/sale.php?TotalCost=$var1&OrderID=$var2\" width=1 height=1>");

NOTE: Do not forget to edit last line in this code - http://YOURSITE.com should be replaced with your URL where you installed Affiliate Trail.
"