Storing the CV2 code is on your own risk because this is against the VISA security guidelines. By default only the Credit Card number will be stored.

To also store the CV2 code you could execute the script below via host -> SQL (turn on the ‘Run As Script’ option). You could also add a check for the CardType parameter to the stored proc below to store only the data of certain Credit Cards e.g. Amex only. In this case you must display the CC type selector and make it mandatory via cart module options. Possible values are: ‘VISA’, ‘MC’, ‘AMEX’, ‘DC’, ‘Discover’, ‘JCB’, ‘DELTA’, ‘SOLO’, ‘SWITCH’, ‘MAESTRO’, ‘CIRRUS’.

if exists (select * from sysobjects where id = object_id(N'{databaseOwner}[CAT_SaveCCData]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)

drop procedure {databaseOwner}[CAT_SaveCCData]

GO

CREATE procedure {databaseOwner}CAT_SaveCCData

(

            @TransactionID nvarchar(255) = Null,

            @AuthCode nvarchar(50),

            @AvsCode nvarchar(250),

            @TransactionType nvarchar(50),

            @OrderID nvarchar(250),

            @Number nvarchar(255),

            @Amount money,

            @Year int,

            @Month int,

            @Description nvarchar(255),

            @FirstName nvarchar(50),

            @LastName nvarchar(50),

            @ErrorMessage ntext = Null,

            @Code nvarchar(255),

            @Address nvarchar (255) ,

            @City nvarchar (50) ,

            @Country nvarchar (50) ,

            @Email nvarchar (50) ,

            @Phone nvarchar (50) ,

            @StateProvince nvarchar (50) ,

            @ZipPostal nvarchar (50) ,

            @CardType nvarchar (20) ,

            @ClientIP nvarchar (50)

)

AS

Insert Into Transactions

(

            TransactionID,

            AuthCode,

            AvsCode,

            TransactionType,

            OrderID,

            Number,

            Amount,

            Year,

            Month,

            Description,

            FirstName,

            LastName,

            ErrorMessage,

            TransactionDate,

            Code,

            Address,

            City,

            Country,

            Email,

            Phone,

            StateProvince,

            ZipPostal,

            CardType,

            ClientIP

)

Values

(

            @TransactionID,

            @AuthCode,

            @AvsCode,

            @TransactionType,

            @OrderID,

            @Number,

            @Amount,

            @Year,

            @Month,

            @Description,

            @FirstName,

            @LastName,

            @ErrorMessage,

            GetDate(),

            @Code,

            @Address,

            @City,

            @Country,

            @Email,

            @Phone,

            @StateProvince,

            @ZipPostal,

            @CardType,

            @ClientIP

)

GO

Please note that storing the CV2 code is against the requirements from the VIA PCI DSS Compliance Acceleration Program. Using this script is at your own risk.

This code works with all CATALooK.netStore version >= 5.9.4.