Configure accepted AVS result codes

To configure the Address Verification Service (AVS) result codes that a merchant will accept:

  1. Open the DB2 Command Window.

  2. Connect to the WebSphere Commerce database.

  3. Add the Payments common AVS codes that you want to accept using an SQL statement. The syntax of the SQL statement will look similar to the following example:
    update STORE set AVSACCEPTCODES='CommonAVSCode1, CommonAVSCode2...' 
  where STORE_ID=StoreReferenceNumber

where CommonAVSCode1, CommonAVSCode2... is the comma delimited string of the common AVS codes that the merchant wants to accept.

StoreReferenceNumber is the value of the STORE_ID field in the
STORE table. By default, only the common AVS code of 0 is accepted. The following list is the Payments defined common AVS codes and their meaning:

0 = Both street address and ZIP code match. 1 = Street address matches, but ZIP code does not. 2 = ZIP code matches, but street address does not. 3 = Neither street address nor ZIP code match. 4 = AVS result not available.

0 is always acceptable, whether or not it appears in the AVSACCEPTCODES column of the
STORE table.

Related concepts

Related reference