Zen Cart Logo

Currency mismatch

Locked

Views: 1,895

Results 1 to 9 of 9
This thread is locked. New replies are disabled.
22 Feb 2008, 7:30 AM
#1
enquirer66 avatar

enquirer66

Zen Follower

Join Date:
Sep 2007
Posts:
215
Plugin Contributions:
0

Currency mismatch

I have a log using PayPal Pro etc in the latest version which reads as follows:

IPN WARNING :: Currency/Amount Mismatch. Details:
PayPal email address = [email protected]
| mc_currency = GBP
| submitted_currency = USD
| order_currency = GBP
| mc_gross = 5.00
| converted_amount = 0.00
| order_amount = 0

Anyone know why this would be? Thx.

22 Feb 2008, 11:54 AM
#2
schoolboy avatar

schoolboy

Totally Zenned

Join Date:
Jun 2005
Location:
Cumbria, UK
Posts:
10,327
Plugin Contributions:
0

Re: Currency mismatch

Possibly a setting at PayPal itself. There is a facility there to specify currency options.

23 Feb 2008, 10:10 AM
#3
enquirer66 avatar

enquirer66

Zen Follower

Join Date:
Sep 2007
Posts:
215
Plugin Contributions:
0

Re: Currency mismatch

This is what PayPal had to say:

Our IPN system does not issue a warning. We also do not pass an order_currency variable. This would be something that your cart is passing, and then your system is issuing the warning. This is something most likely your shopping cart is picking up, and your IPN script is generating the warning.

Any ideas much appreciated/

24 Oct 2008, 3:09 PM
#4
jaypee avatar

jaypee

New Zenner

Join Date:
Jun 2008
Posts:
11
Plugin Contributions:
0

Re: Currency mismatch

Sorry if this is an old thread but I am also having this error.

IPN FATAL ERROR::Transaction did not validate
IPN WARNING::Currency/Amount Mismatch. Details: PayPal email address = @********.com
-> | mc_currency = GBP | submitted_currency = USD | order_currency = GBP | mc_gross = 120.58 | converted_amount = 268.27 | order_amount = 174.2

Submitted currency is USD. Does it mean our shop's cart submitted the currency in USD? I'm trying to think how this is possible. The customer is from UK. Also, it doesn't always happen, but there's at least one order each day that has this error.

(I don't own the shop, I'm just the programmer for my client)

25 Oct 2008, 12:18 AM
#5
drbyte avatar

drbyte

Sensei

Join Date:
Jan 2004
Posts:
63,513
Plugin Contributions:
176

Re: Currency mismatch

What version of Zen Cart?
What currency selection is active in your PayPal Website Payments Standard module settings?
Which currencies is the PayPal account configured to accept payment for?
What exchange rates do you have set up for your USD and GBP currencies?

29 Oct 2008, 7:43 PM
#6
jaypee avatar

jaypee

New Zenner

Join Date:
Jun 2008
Posts:
11
Plugin Contributions:
0

Re: Currency mismatch

What version of Zen Cart?
-- we didn't install the shop, but the footer of the admin says Zen Cart v1.3.5/v1.3.0

What currency selection is active in your PayPal Website Payments Standard module settings?
-- not sure what you mean by this. In this page:
admin/modules.php?set=payment&module=paypal
Transaction Curreny is set to Selected Currency

Which currencies is the PayPal account configured to accept payment for?
-- It is my client's Paypal account, and I'm guessing Euro, GBP, and Yen.

What exchange rates do you have set up for your USD and GBP currencies?
-- USD - 1.25999999
-- GBP - 0.79750001
(default is Euro - 1)

Also in addition to this, the client is receiving the payment even if it says it has an error. Also, the order_totals are missing in the zen_order_totals table.

I cannot reproduce the error since it seems random. The only reason I can think of is the session expired, but there's a part in the code that "builds" the session again even if the user is logged off.

29 Oct 2008, 7:47 PM
#7
drbyte avatar

drbyte

Sensei

Join Date:
Jan 2004
Posts:
63,513
Plugin Contributions:
176

Re: Currency mismatch

jaypee:

What version of Zen Cart?
-- we didn't install the shop, but the footer of the admin says Zen Cart v1.3.5/v1.3.0RED FLAG!
You're using Zen Cart v1.3.5, but you have a database version of 1.3.0 ?????????
That's a recipe for problems.

Additionally, there have been hundreds of updates and bugfixes in v1.3.6, v1.3.7, v1.3.7.1, and v1.3.8a since the version you're using, including some related to PayPal.
You'll likely find the symptoms resolved by upgrading. Might be worth setting up a test site with the new version to test and confirm, before upgrading the live site itself.

31 Oct 2008, 7:45 PM
#8
jaypee avatar

jaypee

New Zenner

Join Date:
Jun 2008
Posts:
11
Plugin Contributions:
0

Re: Currency mismatch

Well I knew you'd suggest an upgrade, but does anyone know WHY that is happening? it really seems random.

1 Nov 2008, 8:36 AM
#9
drbyte avatar

drbyte

Sensei

Join Date:
Jan 2004
Posts:
63,513
Plugin Contributions:
176

Re: Currency mismatch

Yes, it does seem random. And, I can't seem to replicate the issue using the current version. Granted, I don't have your site, your customized code, your database, your settings, your PayPal account, your PayPal Account settings, etc to simulate exactly ... so, it's hard to say for sure.