In the orders table, that's automatically created by the eCart Checkout Wizard, there are the following 5 fields:
TransactionCode
TransactionID
SecurityKey
AuthorizationNumber
SignatureString
Whilst the order and order details are being stored to the relevant database tables, these fields are blank which means we've no way of cross referencing the orders in Sage Pay.
There is also an OrderComplete field which just defaults to a value of 0. Is that field simply to allow us to build in a "dispatched" notification - updating that value to a 1 for example to signify that it's been dispatched (and therefore completed)?
Thank you.
NJ