currency incorrectly converted at paypal via payflow pro

[tomarriola]

I've got a problem with currency conversion. I offer payment in US dollars, euros and canadian dollars.

Customers can select the currency they like and checkout. All the while they see properly converted currency amounts. They get an email from the store stating the amount paid in the currency they choose.

Here is what my store shows a customer paid: 821.01EUR

Here is what paypal said the cutomer paid: 1298.92

What it appears to be occurring is that the 821.01 is seen as us dollars and converted to EU at the current exchange rate.

I use payflow pro and have included a copy of the debug email.

When people use EU currency and pay via paypal express the amount is correct.

I'm not able to do a test run in EU currency since I am the store owner. if someone could make a test purchase to the point of getting to paypal but not actually submitting payment-- perhaps you could see whats up.

I'd appreciate any help


Tom


payflow.verisign.com 443 "TRXTYPE=S
&TENDER=C
&USER=*****
&PWD=*****
&VENDOR=*****
&PARTNER=*****
&VERBOSITY=MEDIUM
&ACCT=4539XXXXXXXXxxxx
&EXPDATE=xxx
&CVV2=xxx
&AMT=1298.92
&CURRENCY=EUR
&COMMENT1[7]=( 93 )
&COMMENT2[137]= (FedEx International Priority
®)272.96 ZenSessName:zenid ZenSessID:e9a17364511d940e8fe60442ddf5e256
&INVNUM=Order:15914Cust:15995
&CUSTREF=Order:15914_Cust:15995_Time:0.88498200 1208105164
&NAME[14]=xxx xxx
&LASTNAME=xxx
&STREET=via xxx 31
&CITY=capriolo
&STATE=
&ZIP=25031
&COUNTRY=Italy
&SHIPTOFIRSTNAME=xxx
&SHIPTOLASTNAME=xxx
&SHIPTOSTREET=via xxx 31
&SHIPTOCITY=capriolo
&SHIPTOSTATE=
&SHIPTOZIP=25031
&SHIPTOCOUNTRY=Italy" 30 payflow.verisign.com
0

[tomarriola]

I made an error in requesting the following:

"I'm not able to do a test run in EU currency since I am the store owner. if someone could make a test purchase to the point of getting to paypal but not actually submitting payment-- perhaps you could see whats up."

The problem only occurs when selecting the credit card payment option-- which is payflowpro.

Tom

[tomarriola]

Is the problem this bit of code (below) in payflowpro.php?

It seems like its saying if the currency is 'CAD', 'EUR', 'GBP', 'JPY', 'USD', 'AUD' then change it to USD

Tom


// TRANSACTION INFO
$state_name_billing = $db->Execute("select zone_code from " . TABLE_ZONES . " where zone_name = '" . $order->billing['state'] . "'");
$state_name_shipping = $db->Execute("select zone_code from " . TABLE_ZONES . " where zone_name = '" . $order->delivery['state'] . "'");
$my_currency = $order->info['currency'];
if (!in_array($my_currency, array('CAD', 'EUR', 'GBP', 'JPY', 'USD', 'AUD'))) {
$my_currency = 'USD';
}

$transaction = array(
'TRXTYPE' => ((MODULE_PAYMENT_PAYFLOWPRO_TYPE == 'Authorization') ? 'A' : 'S'),
'TENDER' => "C",
'USER' => MODULE_PAYMENT_PAYFLOWPRO_USER,
'PWD' => MODULE_PAYMENT_PAYFLOWPRO_PWD,
'VENDOR' => MODULE_PAYMENT_PAYFLOWPRO_VENDOR,
'PARTNER' => MODULE_PAYMENT_PAYFLOWPRO_PARTNER,
'VERBOSITY' => ($this->debug=='ON' ? 'MEDIUM' : 'LOW'),

// ORDER INFO
'ACCT' => $order->info['cc_number'],
'EXPDATE' => $order->info['cc_expires'],
'CVV2' => $order->info['cc_cvv'],
'AMT' => number_format($order->info['total'], 2,'.',''),
'CURRENCY'=> $my_currency,
'COMMENT1'=> "( ".$_SESSION['cart']->count_contents(). " ) ". str_replace('&','',$order->info['comments']) ,
'COMMENT2'=> $order->info['shipping_method']. $order->info['shipping_cost']. ' ZenSessName:' . zen_session_name(). ' ZenSessID:' . zen_session_id(),
'INVNUM' => 'Cust:' . $_SESSION['customer_id'] . ' Order:' . $new_order_id ,
'CUSTREF' => 'Order:' . $new_order_id .'_Cust:' . $_SESSION['customer_id'] . '_Time:' . microtime(),

[DrByte]

Is the problem this bit of code (below) in payflowpro.php?

It seems like its saying if the currency is 'CAD', 'EUR', 'GBP', 'JPY', 'USD', 'AUD' then change it to USD

Tom

...

$my_currency = $order->info['currency'];
if (!in_array($my_currency, array('CAD', 'EUR', 'GBP', 'JPY', 'USD', 'AUD'))) {
$my_currency = 'USD';
}

No, that code is saying if it's *not* one of those currencies, then use USD.

[tomarriola]

I know you're a busy man Dr, but would you have to to look thru the payflowpro file to see why submitted a converted currency amount is again converted?

Admittedly it makes me money some extra cash -- but thats not the way I roll :)

Tom

[DrByte]

I will look into it. But first must get some sleep.

[tomarriola]

I'm still getting too much cash when people pay me with EUR. The amt is converted correctly on the store but is presented to paypal in a manner that gets it converted again.

Tom

[tomarriola]

With EUR I get more money than I should. With Canadian cash I get less.

A customer just had an order for 46.99 Canadian. This is the total from the shopping cart and from the email the store sent them.

However, payment via payflow pro tells me they paid $46.00 Canadian.

The 46.99 Canadian was again treated like dollars and converted to Canadian dollars-- ignoring the fact that it had already been converted.

I'm bummed and hoping for help

Tom

[tomarriola]

I'm not able to remedy this problem without help from the usual zenmasters.

Please

Tom

PS, There has been no reply anywhere else I've posted about this. Am I an idiot for being bothered about zencart/payflowpro overcharging? Is the silence telling me to shut and accept the extra cash?

[DrByte]

Apologies for the delay in responding.


Interestingly the Express Checkout module uses the very same logic for currency selection and conversion/exchange, yet works fine.

I must ask some questions:
1. In your Payflow Pro module, what have you selected for Currency preferences?
2. Which currencies are enabled in your store?
3. Which currency is set as default?
4. Which currency are you seeing these transactions "settled" in on the Payflow end? Are they showing up as EUR and CAD etc? or all in USD?