Database Structure

This plugin adds a table to your Concrete5 database: CoreCommerceSagepayOrderStatus

id 1

coreOrderID1

coreInvoice000001

spVendorTx000001-1-14-12-03-14-48-03-TEST

spVPSTx{3E8026A4-CA96-559C-1B53-38C92B0C3B42}

spStatusOK

SpStatusDetail0000 : The Authorisation was Successful.

spResponse

a:16:{s:12:"VendorTxCode";s:31:"000001-1-14-12-03-14-48-03-TEST";s:7:"VPSTxId";s:38:"{3E8026A4-CA96-559C-1B53-38C92B0C3B42}";s:6:"Status";s:2:"OK";s:12:"StatusDetail";s:40:"0000 : The Authorisation was Successful.";s:8:"TxAuthNo";s:6:"953002";s:6:"AVSCV2";s:24:"SECURITY CODE MATCH ONLY";s:13:"AddressResult";s:10:"NOTMATCHED";s:14:"PostCodeResult";s:10:"NOTMATCHED";s:9:"CV2Result";s:7:"MATCHED";s:7:"GiftAid";s:1:"0";s:14:"3DSecureStatus";s:10:"NOTCHECKED";s:8:"CardType";s:4:"VISA";s:11:"Last4Digits";s:4:"0006";s:11:"DeclineCode";s:2:"00";s:6:"Amount";s:5:"18.00";s:12:"BankAuthCode";s:19:"999777

coreStatus2

coreCustomerlastname, firstname

coreEmail[email protected]

orderAmount18.0000

dateAdded2014-12-03 14:48:04

lastUpdated2014-12-03 14:49:11