Using the Update record wizzard for updating worldpay payment response
Is it possible to use the Update Record wizzard on a new template generated page called wp_payment_response.php to update a column called WPtransID in the orders table. This is to record the transId parameter returned by the Worldpay payment response.
The confirm page is set up to pass the OrderID to worldpay.
Cant seem to get the script provided by Airfox to update the table so trying to do it from scratch (this is on another thread called "Worldpay confirmation emails").
The worldpay payment response is enabled, password is set, payment response URL correctly added to worldpay merchant interface.
If this can be done this way please could you help with the steps required or is there another way.
The objective is to use the payment response to update the orders table with the worldpay transId and also to generate a UE email detailing the contents of the cart and other parameters to be sent to the customer and merchant.