I am not a 100% sure that I have constructed the paypal IPN page correctly (attached). I have been trying a number of combinations and reading everything I can to get this payment process completed.
To get the variables for the UE mail receipt I had to first add a cart display to the page. I don't think that it should be displayed on the IPN page? I did add the email version of the cart display in the body of the UE mail.
I believe that the eCart Data Manipulation server behaviors are to insert and not for updating a record. So to update the db I used DataAssist Update-Single Record Update, trigger: from any post, with the key column as the OrderReferenceID and the value from the pp post "invoice" form value. Durring the previous steps I had set the OrderReferenceID to the cart sessionID and it is created and stored in the tb on the confirm page. I am not sure how to confirm that it is being passed to pp as the "invoice" variable. My orderdetail table links with the record OrderID from the order table.
Please take a look and advise if I am close and what I need to correct so that we can start processing orders. P&T