Hi,

When the french culture is used on the dnn website (both french language packs are installed for the entire site & the Smith module), the URL sent to PayPal (standard) formats the amount according to the french culture (ie the decimal separator is a comma) that causes the following error message to be displayed once arrived on the PayPal website (actually using the PayPal sandbox for testing purpose - do not known if a similar problem exists on the real PayPal site) :

Le lien que vous avez utilisé pour accéder au système PayPal contient un montant d'objet incorrectement formaté. (The link you have used to enter the PayPal system contains an incorrectly formatted item amount.)

The URL used to access PayPal service (logged in the event viewer indicates "amount=538,20" (comma decimal separator)). If I set the my website culture to en-US, the URL shows "amount=538.20" (dot decimal separator) and the payment can be done (no error on the PayPal website).

 

Can you please fix the error ?

 

All french language file (that were downloaded from your website) suffixes must be renamed from ".fr.resx" to ".fr-fr.resx" in order the smith cart modules to be french localized. I don't know if this problem comes from the main website language pack (downloaded from www.dotnetnuke.fr) or if the language files must be fully qualified to be considered (I know that in dotNet, if the fr-fr does not exist, the .fr resource file is automatically taken - and that is not the case here).

 

EDIT : from this post, I discovered that this was a known bug that was fixed in version 4.64 available since 10/15/11 (so it is a regression bug):

"Also, we have fixed the following Paypal Standard bugs that you will be interested in:

• Amount field - There was an issue with amount formatting for PayPal Standard payment request. It has to always use point decimal separator no matter the currency. The bug only applies if you have configured your store for a currency that doesnt use decimal places (i.e. EURO uses commma as decimal seperator)."

Hi Rico,

This issue has been addressed and the solution will be included in the release of SmithCart v.4.90.

Thanks,

Hi,

 

The problem reappeared with the version 5.0 ("Le lien que vous avez utilisé pour accéder au système PayPal contient un montant d'objet incorrectement formaté.")

My configuration is slightly different from the one described above : now I use a French localized DotNetNuke install (version 6.2.0) with Smith Cart 5.0 with no langage pack installed.

I noticed that the URL passed to PayPal contains '%2c' (ie the comma) to represent the decimal separator. When I change '%2c' to '.' in the URL (or change my website localization to en-US), no error is displayed at PayPal side.

 

From the Smith Cart change log page :

Smith Cart DNN Module - 4.65 -  Beta Release 10/12/11

Bug Fixes

PayPal Standard

Amount field - There was an issue with amount formatting for PayPal Standard payment request. It has to always use point decimal separator no matter the currency.

 

Can you please fix this regression bug (and make sure it will not appear again) ?

Thanks.

Hi Scott and thanks for the support.

 

My currency is set to 'Euro - €', but I have tried with 'France Euro - €' and the problem occurs too.

But I do not understand why you ask me that, as I told you that the decimal separator in the URL sent to PayPal contains the character '%2c' for decimal separator instead of the dot. And as you mentioned in the bug fix :

Amount field - There was an issue with amount formatting for PayPal Standard payment request. It has to always use point decimal separator no matter the currency.

 

So the currency defined in the BuyNow settings MUST NOT change the decimal separator character in the URL sent to PayPal....

Please fix this. Thanks

Hi SmithCart support.

I have just tested it on a Dnn 6.2.4 with SmithCart 5.22 fresh install, using PayPal standard payments, and the URL sent to PayPal still contains %2C for the decimal separator

From the Dnn event viewer:
https://www.sandbox.paypal.com/cgi-bin/webscr?cmd=_cart&upload=1&business=XXX&email=XXX¤cy_code=EUR&item_name_1=Product&amount_1=200%2c00&quantity_1=2&tax_1=0%2c00&shipping_1=0%2c00&custom=3&return=http%3a%2f%2fXXX%2fBuyNow%2ftabid%2f84%2fctl%2fConfirm%2fmid%2f413%2fhosted%2f1%2flanguage%2ffr-FR%2fDefault.aspx%3fsuccess%3d1&cancel_return=http%3a%2f%2fXXX%2fBuyNow%2ftabid%2f84%2fctl%2fConfirm%2fmid%2f413%2fhosted%2f1%2flanguage%2ffr-FR%2fDefault.aspx%3fsuccess%3d0&first_name=h&last_name=h&address1=h&city=h&state=h&zip=h&country=FR&discount_amount_1=0

As you can see, the decimal separator (in red above) is incorrect for french culture.

How can we resolve this issue?