Decimal comma is wrongly passed to Stripe

  • Resolved Touda

    (@touda)


    4 years, 2 months ago

    Hi, I want to inform of something not working with the locale settings regarding decimal comma (which is used in some countries like France or Spain to separate decimals instead of the point).

    Even though we got Spanish locale selected, and quantities appear correctly at the WP dashboard, when users click on our donations buttons and go to stripe payment page, 26,15 euros for example (which is Spanish form or 26.15 euro) turn into 2,615.00 euro !!!

    Looking at https://docs.wpsimplepay.com/articles/currency-locale-date-settings/ we have read:

    Separators Use a comma when formatting decimal amounts and use a period to separate thousands. If enabled, amounts will be formatted as “1.234,56” instead of “1,234.56”. Also set the option in your Stripe dashboard under Business > Data.

    But we neither find that Business > Data section at our Stripe panel nor that link takes to a page that makes any sense about this comma issue ??

    Stripe support has told us that there’s no place at their dashboard to configure the decimal separator, so we are completly at a lost! Can anybody here please help us? Thank you in advance.

    Our related settings are:
    Stripe Setup > Account Country = Spain
    Stripe Setup > Stripe Checkout Locale = Auto-detect (before, it was Spain, but problem was the same)
    General > Currency Options:
    Currency = Euro
    Currency Position = Right with space
    Separators = Use a comma

    System report:

    
### WordPress Installation ###

Site Name: 15/15\15
Home URL: https://www.15-15-15.org/webzine
Site URL: https://www.15-15-15.org/webzine
SSL/HTTPS Enabled: Yes
Version: 5.5.1
Locale: es_ES
Multisite: No
Permalinks: /%year%/%monthnum%/%day%/%postname%/
WP Memory Limit: 256 MB
WP Debug Mode: No
Script Debug: No

### WP Simple Pay Lite Settings ###

WP Simple Pay Lite Lite Version: 2.5.2
Stripe TLS: Cannot test TLS 1.2 support until your Stripe Test Secret Key is entered.
Simple Pay Test or Live Mode: Live Mode

### Active Theme ###

Theme: Fox - 4.4.3.1
Child Theme: No
Parent Theme: -

### Active Plugins ###

bbPress Notify: 0.2.2
Subscribe to Comments Reloaded: 200813
XCloner - Site Backup and Restore: 4.2.153
Download Manager: 3.1.09
Open Graph and Twitter Card Tags: 3.0.0
User Role Editor: 4.56.1
Really Simple SSL: 3.3.5
AddToAny Share Buttons: 1.7.42
WP Simple Pay Lite: 2.5.2
Shortcode Widget: 1.5.2
Geo Mashup: 1.13.3
Classic Editor: 1.6
WP Terms Popup: 2.0.1
Polylang: 2.8.2
Head Meta Data: 20200805
Members: 3.1.3
WP-PageNavi: 2.93.3
Yet Another Stars Rating: 2.4.9
Phoenix Media Rename: 2.2.5
CSS Plus: 1.5.1
Contact Form 7: 5.2.2
Better Search Replace: 1.3.3
bbPress: 2.6.5
Regenerate Thumbnails: 3.1.3
Akismet Anti-Spam: 4.1.6
Wordfence Security: 7.4.11
MailPoet 2: 2.14
My Calendar: 3.2.8
Google XML Sitemaps: 4.1.1
Co-Authors Plus: 3.4.3
Stray Random Quotes: 1.9.9
Widget Clone: 1.1.2

### Server Environment ###

Web Server: Apache
PHP Version: 7.3.22
MySQL Version: 5.7.31
Server Timezone: UTC
Display Errors: No
Server PHP Memory Limit: 256M
Upload Max Filesize: 32M
Post Max Size: 32M
Max Execution Time: 30
Max Input Vars: 1000
cURL Enabled: Yes
cURL Version: 7.72.0
OpenSSL/1.1.1g
mbstring (Multibyte String) Enabled: Yes
fsockopen: Yes
SOAP: Yes
SUHOSIN: No
WP Remote POST: Yes
WP Remote GET: Yes

### Client Information ###

IP Address: 209.42.193.83
Browser: Firefox 60.0 (Linux)

    The page I need help with: [log in to see the link]

Viewing 9 replies - 1 through 9 (of 9 total)
  • Plugin Author Spencer Finnell

    (@spencerfinnell)

    Hello @touda,

    I apologize for the the issue. There does appear to be a conversion issue when using the comma separator setting. For the time being please uncheck that setting and enter your values with a period (.) decimal separator.

    Stripe Checkout will show the comma (,) as the decimal separator when setting your Stripe Checkout Locale in Simple Pay Lite > Settings > Stripe Setup.

    Thread Starter Touda

    (@touda)

    Thanks for the quick answer, Spencer.

    1) Unchecked the “use comma” option.
    2) All quantities then appeared multiplied x100 in the forms. Corrected them.
    3) Tried the buttons at our donations page. But now they simply don’t work at all. Connection with Stripe seems to be broken ??

    • This reply was modified 4 years, 2 months ago by Touda.
    Plugin Author Spencer Finnell

    (@spencerfinnell)

    Hello @touda

    It looks like your reCAPTCHA settings are misconfigured. Please double check your settings against the documentation here: https://docs.wpsimplepay.com/articles/recaptcha/

    Thread Starter Touda

    (@touda)

    It’s strange. We are not using reCAPTCHA, Spencer.

    Plugin Author Spencer Finnell

    (@spencerfinnell)

    Hello @touda,

    Please double check your settings in “Simple Pay Lite > Settings > General”. WP Simple Pay is outputting reCAPTCHA information, so there is some value there. We do recommend configuring reCATPCHA based on the guide here: https://docs.wpsimplepay.com/articles/recaptcha/

    Thread Starter Touda

    (@touda)

    I absolutely do not know where that “reCAPTCHA” information is coming from! We never used reCAPTCHA! And of course we don’t want to be forced to use it.

    But I can see that “Site Key” and “Secret Key” fields have been automatically filled somehow! :-O

    So we will remove them and leave those fields empty. I hope that tells the plugin that we don’t want to use any captcha.

    Thread Starter Touda

    (@touda)

    There’s no way to remove those fields’ content! I left them empty and after saving changes, they are back with the same information: “Site Key” has the value of the Admin username and I cannot see what’s at the “Secret Key” field because it’s not readable ??

    How can we tell the plugin that we won’t use reCAPTCHA?

    Plugin Author Spencer Finnell

    (@spencerfinnell)

    Hello @touda,

    Your buttons are redirecting to Stripe Checkout for me now — it does appear you have cleared out the reCAPTCHA settings. Are you sure the values shown in the fields aren’t from your browser’s autocomplete suggestions?

    Thread Starter Touda

    (@touda)

    Yes, now I can see it works. No idea how! ??

    And I don’t think I would have accepted such a autocomplete if it was a suggestion. You might want to review your code for it seems to me that it’s taking some info for itself without suggesting a thing! :-/

    Thanks for all your help.

Viewing 9 replies - 1 through 9 (of 9 total)
  • The topic ‘Decimal comma is wrongly passed to Stripe’ is closed to new replies.