rshaltry
17th January 2008, 04:51 PM
We are experiencing an issue with Post Affiliate Pro 3.1.1 where items are being credited as transactions multiple times (2-3 times). Our integration is with E-Commerce Templates using the 'sale.php' hidden image tracking script.
Our Post Affiliate Pro software has a campaign setup for each item, as each item purchased has a different per-sale commission amount that is associated. What we've done is modified the 'incemail.php' file within the E-Commerce Templates system to output the sale.php image HTML code for each item ordered. If a user orders more than one of an item, the code is output multiple times (e.g. item quantity of 2 gets 2 HTML image tags outputted). We are passing the following variables to the sale.php script in these HTML image tags:
- TotalCost (price of item)
- ProductID
- OrderID
- data1 (product ID)
Everything works perfectly with the tracking of orders in the system; products are credited their appropriate commission value and all variables are passed as expected. In the Transaction section of the Merchant administration console, we expect to see multiple items for each OrderID, but what we're seeing is duplicate items when only a single item of that ProductID was ordered. We discovered this with an audit of the items in the orders in the affiliate transactions as compared to the items in the orders within the E-Commerce Templates system.
We've figured out the problem to be with printing and print preview of the checkout completion page, which sends an additional request to the 'sale.php' in generating the print or print preview view for the page. Not everybody prints these confirmation pages, which is why we're not seeing this with every single order that is placed (roughly 50% though, which is troubling).
I had initially thought that one of the settings under the "Fraud Protection" section of the Tools/Settings screen would solve the issue, but not based on the fact that we have each product setup as its own campaign and that the identical Order IDs from the same IP address are to be expected quite frequently (when multiple items are being ordered on the same order).
I'm wondering if anyone else has experienced this issue with the sale.php tracking code and if there is some way to prevent the HTML image tag from being called duplicate times from the print and print preview views. Any help, assistance, or suggestions would be greatly appreciated.
Our Post Affiliate Pro software has a campaign setup for each item, as each item purchased has a different per-sale commission amount that is associated. What we've done is modified the 'incemail.php' file within the E-Commerce Templates system to output the sale.php image HTML code for each item ordered. If a user orders more than one of an item, the code is output multiple times (e.g. item quantity of 2 gets 2 HTML image tags outputted). We are passing the following variables to the sale.php script in these HTML image tags:
- TotalCost (price of item)
- ProductID
- OrderID
- data1 (product ID)
Everything works perfectly with the tracking of orders in the system; products are credited their appropriate commission value and all variables are passed as expected. In the Transaction section of the Merchant administration console, we expect to see multiple items for each OrderID, but what we're seeing is duplicate items when only a single item of that ProductID was ordered. We discovered this with an audit of the items in the orders in the affiliate transactions as compared to the items in the orders within the E-Commerce Templates system.
We've figured out the problem to be with printing and print preview of the checkout completion page, which sends an additional request to the 'sale.php' in generating the print or print preview view for the page. Not everybody prints these confirmation pages, which is why we're not seeing this with every single order that is placed (roughly 50% though, which is troubling).
I had initially thought that one of the settings under the "Fraud Protection" section of the Tools/Settings screen would solve the issue, but not based on the fact that we have each product setup as its own campaign and that the identical Order IDs from the same IP address are to be expected quite frequently (when multiple items are being ordered on the same order).
I'm wondering if anyone else has experienced this issue with the sale.php tracking code and if there is some way to prevent the HTML image tag from being called duplicate times from the print and print preview views. Any help, assistance, or suggestions would be greatly appreciated.