Not sure if e-commerce is the correct forum to post.

We use a third party payment gateway and are allowed to place invisible image script to track our affiliate sales and check what the gateway is actually reporting to us. Image is placed on the "Thank You" (checkout_success) page that is displayed to the customer after the payment is processed. Tracking URL parameter data includes stuff like 1x1 pixel image src loaded from say sales.php, AFFILATE_ID, ORDERNUMBER, ORDERTOTAL etc.

My question is what script should we have on the sale.php page, so that the invisible image is loaded to the checkout_success page, data is collected and stored in SQL for further processing. What solutions do you use? Is there any free php script that will do the job?

the shopping cart im using has the affiliate system built-in and so do many carts, first see if your cart either has or can have this capability installed as a module because that's the easiest. because you also have to keep in mind what if the customer goes to sale.php and then goes to continue more shopping and then comes back again. the affiliate thing would have to be store-wide right?

If customer triggers sale.php this is actually the "checkout success" page. So, they can not continue more shopping with same shopping cart. I have just found a script named phphits and intend to modify it a little. Just was wondering if there is a script that will suit my needs without modifications.