To configure the Address Verification Service (AVS) result codes that a merchant will accept:
- Open the DB2 Command Window.
- Connect to the WebSphere Commerce database.
- 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:
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, and 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.
Note that 0 is always acceptable, whether or not it appears in the AVSACCEPTCODES column of the STORE table.