Transaction Log

ChannelAdvisor Complete supports a variety of payment processing options for orders. Each time a buyer completes a purchase through the system, a transaction record will be created in the Transaction Log. These records include information used to refund/credit buyers (also sometimes referred to as cancelling a sale) to track gateway/credit card provider transactions and understand fraud codes.

You will find the following information helpful when refunding buyers and processing payments:

Refunding an eBay or Standard Store Buyer

You can process a partial or full refund to a buyer for cleared payments using the 'Process Credit' icon on the Transaction Log. Please note that in order to process a refund for a PayPal payment, you must first enable 'Refund Processing' directly in your account on the PayPal site.

Select Sales > Orders/Transactions > Transaction Log
Click the 'Process Credit' icon in the Command column
The order information will appear on the Credit page
Enter the 'Credit Amount' to be refunded to the buyer. This amount cannot exceed the Total Order Value
Click 'Process'
A Credit amount row will appear in the Transaction Log to record the refund.

Transaction Log Data

The following data elements are available in the Transaction Log:

Field Name	Definitions of Transaction Log Data Elements
Order ID	The unique identification number used to distinguish one order log from another. The order ID shown in the Transaction Log will match the order ID displayed in the All Sales View
Commands	The checkout icon provides a direct link to the unique checkout for the selected transaction. For fully integrated ChannelAdvisor clients, this link will lead to the e-commerce shopping cart link provided via integration. For partial or non-integrated ChannelAdvisor clients, this link will lead to a ChannelAdvisor Checkout URL. The Sales Status Log provides the user a list of all status changes processed for a sales transaction, including the date and time stamp, the user processing the change and the message logging the exact status information affected. The Process Creditcommand will display a new page to process credits to buyers for completed purchases. A credit card must have been used as the payment method in order to process a transaction reversal credit. Each transaction can have an unlimited number of reversals up to the total amount the buyer was initially billed. For example, if the initial amount billed was $100 and a credit was processed in the amount of $50 this leaves an amount that can be credited later at $50. Two days later, a credit amount of $25 is processed and the remaining balance is $25.
Order Value	The total amount paid by the buyer for a transaction
Date	The date on which the order was generated or the transaction process was logged
Description	The detailed description of the transaction that was processed and logged. For example, a tax calculation, a credit card authorization or credit card charges.
Auth Code	The code returned directly from the gateway/credit card provider when a credit card authorization is made.
AVSCode	The code returned directly from the gateway/credit card provider when a credit card charge is made.
CVVCode	The code returned directly from CyberSource when a credit card's CVV number is entered and approved.
Fraud Score	The Fraud Score is determined by the gateway/credit card provider and is populated in this field. The scores can range between one and one hundred. One hundred is the most suspicious and one is the lease suspicious. ChannelAdvisor Complete will prevent transactions from completing that exceed the configured fraud check security level defined in payment settings, see Customizing Payment Settings.
Fraud Reason	The Fraud Reason is determined by the gateway/credit card provider and is populated in this field. Fraud Reasons codes are defined below.
Transaction Message	The message text sent from the gateway/credit card provider for each processed transaction. These messages might be about invalid data, approved, declined, or errors in the transaction.
Reference Number	The unique identification code used to reference a gateway/credit card provider for each transaction.

Fraud Reason Codes

These codes will appear on the transaction log to help you determine and label the type of fraud.

Fraud Code	Definitions of Fraud Codes
a.	Excessive address change. The customer had two or more billing address changes in the last six months.
b.	Bin number mismatch. The customer's Visa or MasterCard credit card was issued in a different country than the country specified in the billing address.
c.	High count of unique credit cards. The customer used more than six unique credit cards in the last six months.
d.	Host hedge. The customer had a risky domain (IP) or email address.
e.	Fraud list Flag. The credit card number, street address, email address, or IP address for this order appears on the negative list for your merchant ID.
f.	Geo-location Inconsistencies. The customer(tm)s email domain, phone number, billing address, shipping address, or IP address is suspicious.
g.	Name Change. The card holder had two or more name changes in the last six months.
h.	Internet Inconsistencies. The internet address and email domain are inconsistent with the billing address.
i.	Nonsensical Input. The customer name and address fields contain words or language having no meaning.
j.	Obscenities. The customer input contains obscene words.
k.	Phone Inconsistencies. The customer phone number is suspicious.
l.	Risky Transaction. Characteristics in this order display multiple high-risk correlations between the transaction, consumer and merchant information.
m.	Time hedge. The customer is attempting a purchase outside of the expected hours for purchase of an item.
n.	Unverifiable Address. The billing or shipping address is not verifiable.
o.	Velocity. The credit card was used more than three times in the past fifteen minutes.
p.	Warning. The billing or shipping address is similar to an address previously marked as suspect.
q.	Gift Order. The street address, city, state, or country of the billing and shipping addresses do not correlate.
r.	Unclear request. The information in the request contains an unusual or unexpected value and a default value was substituted. Although the transaction can still be processed, examine the request carefully for abnormalities in the order.

Reference

Refunding an eBay or Standard Store Buyer

Select Sales > Orders/Transactions > Transaction Log
Click the 'Process Credit' icon in the Command column
The order information will appear on the Credit page
Enter the 'Credit Amount' to be refunded to the buyer. This amount cannot exceed the Total Order Value
Click 'Process'
A Credit amount row will appear in the Transaction Log to record the refund.

Transaction Log Data

The following data elements are available in the Transaction Log:

Field Name	Definitions of Transaction Log Data Elements
Order ID	The unique identification number used to distinguish one order log from another. The order ID shown in the Transaction Log will match the order ID displayed in the All Sales View
Commands	The checkout icon provides a direct link to the unique checkout for the selected transaction. For fully integrated ChannelAdvisor clients, this link will lead to the e-commerce shopping cart link provided via integration. For partial or non-integrated ChannelAdvisor clients, this link will lead to a ChannelAdvisor Checkout URL. The Sales Status Log provides the user a list of all status changes processed for a sales transaction, including the date and time stamp, the user processing the change and the message logging the exact status information affected. The Process Creditcommand will display a new page to process credits to buyers for completed purchases. A credit card must have been used as the payment method in order to process a transaction reversal credit. Each transaction can have an unlimited number of reversals up to the total amount the buyer was initially billed. For example, if the initial amount billed was $100 and a credit was processed in the amount of $50 this leaves an amount that can be credited later at $50. Two days later, a credit amount of $25 is processed and the remaining balance is $25.
Order Value	The total amount paid by the buyer for a transaction
Date	The date on which the order was generated or the transaction process was logged
Description	The detailed description of the transaction that was processed and logged. For example, a tax calculation, a credit card authorization or credit card charges.
Auth Code	The code returned directly from the gateway/credit card provider when a credit card authorization is made.
AVSCode	The code returned directly from the gateway/credit card provider when a credit card charge is made.
CVVCode	The code returned directly from CyberSource when a credit card's CVV number is entered and approved.
Fraud Score	The Fraud Score is determined by the gateway/credit card provider and is populated in this field. The scores can range between one and one hundred. One hundred is the most suspicious and one is the lease suspicious. ChannelAdvisor Complete will prevent transactions from completing that exceed the configured fraud check security level defined in payment settings, see Customizing Payment Settings.
Fraud Reason	The Fraud Reason is determined by the gateway/credit card provider and is populated in this field. Fraud Reasons codes are defined below.
Transaction Message	The message text sent from the gateway/credit card provider for each processed transaction. These messages might be about invalid data, approved, declined, or errors in the transaction.
Reference Number	The unique identification code used to reference a gateway/credit card provider for each transaction.

Fraud Reason Codes

These codes will appear on the transaction log to help you determine and label the type of fraud.

Fraud Code	Definitions of Fraud Codes
a.	Excessive address change. The customer had two or more billing address changes in the last six months.
b.	Bin number mismatch. The customer's Visa or MasterCard credit card was issued in a different country than the country specified in the billing address.
c.	High count of unique credit cards. The customer used more than six unique credit cards in the last six months.
d.	Host hedge. The customer had a risky domain (IP) or email address.
e.	Fraud list Flag. The credit card number, street address, email address, or IP address for this order appears on the negative list for your merchant ID.
f.	Geo-location Inconsistencies. The customer(tm)s email domain, phone number, billing address, shipping address, or IP address is suspicious.
g.	Name Change. The card holder had two or more name changes in the last six months.
h.	Internet Inconsistencies. The internet address and email domain are inconsistent with the billing address.
i.	Nonsensical Input. The customer name and address fields contain words or language having no meaning.
j.	Obscenities. The customer input contains obscene words.
k.	Phone Inconsistencies. The customer phone number is suspicious.
l.	Risky Transaction. Characteristics in this order display multiple high-risk correlations between the transaction, consumer and merchant information.
m.	Time hedge. The customer is attempting a purchase outside of the expected hours for purchase of an item.
n.	Unverifiable Address. The billing or shipping address is not verifiable.
o.	Velocity. The credit card was used more than three times in the past fifteen minutes.
p.	Warning. The billing or shipping address is similar to an address previously marked as suspect.
q.	Gift Order. The street address, city, state, or country of the billing and shipping addresses do not correlate.
r.	Unclear request. The information in the request contains an unusual or unexpected value and a default value was substituted. Although the transaction can still be processed, examine the request carefully for abnormalities in the order.

Reference

Your rating:

Your rating: None

Related Topics:

Your rating:

Your rating: None

Page last updated: Tue, 02/26/2013 - 11:56

ChannelAdvisor Strategy and Support Center

How To

Transaction Log

Refunding an eBay or Standard Store Buyer

Transaction Log Data

Fraud Reason Codes

Reference

Refunding an eBay or Standard Store Buyer

Transaction Log Data

Fraud Reason Codes

Reference

Related FAQs

Tags