Order Status in Orders Table
In the orders table there is the Order status field. How do I have this update dependant on the status of the order.
I may be getting the use of this field wrong but in my way of thinking the orders get saved to the database upon checkout, the user then goes off to Paypal and Pays.
I want to save the staus of the payment in the database OrderStaus =1 for Payment Received or OrderStatus2=PaymentFailed.
How would I get this info into the database based on the status of the order?
Otherwise I don't see the point of even updating a record into the orders table if it doesn't complete.