Hi folks.
First, thanks for a great product. On the whole, my first zen cart experience has gone extremely well so far. I am having an issue with PayPal Express Checkout...it chokes when customers select Japanese yen (JPY) as their currency. This is a big deal as the core focus of the site is the Japanese market.
Here are the background details:
-fresh zc install of v1.3.8a
-manually updated Japanese language pack (used on front end only) from v1.3.0
-running on php server(s)
-hosted with mosso
-very basic zc set-up for now, no coupons, downloads, or taxes...only flat shipping
-default currency is US Dollars
Here is the problem:
-paypal express checkout throws errors when Japanese Yen (JPY) is the selected currency,but appears to work fine for USD, GBP, EUR, AUD, CAD
-error logs show that it fails on first API call, 'SetExpressCheckout'
-error shown on front end is 10401 (order total invalid)
-errors in log suggest something else/more is going on, as the above error is joined by 11059 (conflicting currency codes) and 10426 (order total invalid)
Here is the troubleshooting done so far:
-confirmed client has JPY balance opened in their PP account
-confirmed that offline card processing works in JPY through virtual terminal
-changed formatting of JPY to exactly match other currencies (2 decimal places, '.' for decimal point, ',' for thousands separator, currency symbol on left)
(note: requirement for decimal places in JPY is confusing and meaningless, as no consumer transactions are conducted using fractions of yen)
-confirmed the settings for JPY formatting above are valid as far as PayPal is concerned
-placed test order in yen with customer address in US - same errors
-placed test order in yen with customer address in Japan - same errors
-considered exchange rate may be an issue, as JPY generally trades in excess of 100 to 1USD. This results in order totals regularly exceeding 10,000 'units' and PayPal does seem to cap transactions at $10,000 USD.
-placed test order for product priced at 1JPY (about $0.01 USD) - same errors
-still curious about exchange rate/amount ceilings, added Hungarian Forints (HUF, trades roughly 150HUF to 1USD), as well as Hong Kong Dollars (HKD, trades around 8HKD to 1USD)
-placed test order in excess of 10,000HUF - same errors
-placed test order in excess of 10,000HKD - no error!
-contacted PayPal, they are very helpful but haven't found the problem
It's a slippery one -either really complicated or really simple! Any thoughts or similar experiences?
Bookmarks