BV Commerce Forum
»
BV Commerce Support
»
General Support
»
SP3 Suggestion #4 - Payment Fields, Specifically Credit Cards
Rank: Member
Joined: 4/10/2006(UTC)
Posts: 462
|
Hi,
It would be very beneficial to add database fields and object fields to order payments that contain the response codes for AVS and CVV.
I would assume that there would be some type of similiar code response from Paypal Express indicating whether a confirmed address was found and whether the customer was a verified member. As I'm not familiar at all with Googlecheckout I'm unaware what these type of fields would be called but I am going to assume that have some type of system to validate a user.
In our specific case it would allow us to add functionality through a workflow task that could automatically update the public order notes and order status based on result of the transaction and the information contained in these "Verification Codes".
For example, if a credit card is declined and the CVV response was 'N', we could automatically add a public note letting the customer know that the most likely reason for the credit card decline was a "security code mismatch". Or similiarly, as our company policy requires an AVS match, a note could be added for "Billing Address Mismatch", when the AVS response is 'N'.
It could also be used for a task that send an e-mail to the customer, allowing the task to choose the correct e-mail to send, so the customer will know what went wrong and how to rectify the situation. |
Netriplex Corporation<br /> |
|
|
|
|
|
Rank: Member
Joined: 4/10/2006(UTC)
Posts: 462
|
Adding to this idea a bit.
Essentially, I think all of the information that is currently included as a private note when a card is authorized should be recorded into a db field as well as some of the "extra information" that is added as a note that I think should be a piece of the order itself. Also, I think the payment screen should give a complete timestamp of when a payment was completed like in the old bv2004 system. It currently only shows a date which is not always helpful.
The Customer IP and Customer Host could also be beneficial to some workflow tasks we'd like to implement but I do not think they are a part of the database to retrieve easily at a later point. Our use for them would be for Geo-ip lookup to help spot fradulent orders. Obviously geo-ip is not an exact science but it can help weed out the orders placed from syria using a satelitte internet connection. |
Netriplex Corporation<br /> |
|
|
|
|
|
Rank: Member
Joined: 4/22/2004(UTC)
Posts: 280
|
Agree. These would be very helpful.
Linette
|
|
|
|
|
|
Rank: Member
Joined: 7/3/2007(UTC)
Posts: 79
|
Hi,
I agree totally. As a UK based E-Commerce site that already uses Worldpay, we rely heavily on the AVS & CVV results (along with other checks) to determine whether an order is fraudulent or not. Not having these in the database means we have to match orders to emails from Worldpay containing this information, which from experience is laborious to say the least, especially when processing 500+ transactions a day at peak trading.
Regards,
Jason
Needapresent.com
|
|
|
|
|
|
Rank: Member
Joined: 4/10/2006(UTC)
Posts: 462
|
|
Netriplex Corporation<br /> |
|
|
|
|
|
Rank: Member
Joined: 11/5/2003(UTC)
Posts: 1,786
|
There are custom fields in the payment response objects that allow payment processors to store anything they wish in the database. I don't know if all payment processors store AVS and CVV response codes but it is a good suggestion.
|
|
|
|
|
|
Forum Jump
You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.