Support

Home Forums Event Espresso Premium Problem with Currency and Stripe

Problem with Currency and Stripe

Posted: September 26, 2017 at 2:25 pm


projectmgrIAABC

September 26, 2017 at 2:25 pm

Hi, we are running a conference in Chile. I have the Chilean pesos set correctly in registration which means I had to reverse how commas and decimals appear in the amount. The problem is when it goes to the payment screen using Stripe, the decimal is in the wrong place (so a $120 ticket in Chilean Pesos now shows as $120,000.) I’m not sure what to do next. Is this something to fix in EE or in Stripe?


Josh

  • Support Staff

September 26, 2017 at 2:46 pm

Hi there,

We received your request for priority support, and I’m logged in to your site and reviewing how the settings and prices are set.

This does appear to be something you can fix within your Event Espresso settings and/or in the Country settings.

Stripe lists the Chilean Peso as a Zero-decimal currency, they explain more here:

https://stripe.com/docs/currencies#zero-decimal

So in this case, your currency settings in Event Espresso > General Settings > Countries has the decimal places set to 0, but the price entered in the ticket editor is 120.000. I think Stripe will want that to be 120, so the way forward will be to remove the 3 zeros from the end of the price.


projectmgrIAABC

September 26, 2017 at 9:29 pm

Thanks, I just tried that but when I hit the payment screen with Stripe, it lists the price as 12.000 CLP. It should be 120.000. So, if I put the price in the ticket as 1200, then it appears correctly in Stripe as $120.000 CLP. LOL, so I’m stuck. One thought I had – could I just remove the price field that appears after the ticket on this page https://iaabcconference.org/espanol/registration/ and this page https://iaabcconference.org/espanol/registration-checkout/? I was thinking I could just then put the price in as part of the ticket description and the registrants wouldn’t be confused by seeing it listed in the wrong way under the Price field.


Josh

  • Support Staff

September 27, 2017 at 6:31 am

There would be other places to remove the price display too. There is the setting in Event Espresso > General Settings > Countries where you can set the number of decimal places to be 0, 1, 2, or 3. Have you tried that?


projectmgrIAABC

September 27, 2017 at 12:57 pm

Thanks, I tried playing with the decimals and it seems like it’s not translating to Stripe. So if I enter it correctly in EE with 3 decimals and a comma serving as the separator instead of a decimal ($120,000), it would be $120,000 that registrants see. But when it gets to Stripe it’s $12.000. If I change the decimal point in EE then it shows wrong on the website registration but correct on Stripe. If change the ticket price to $120 without the zeros after the decimal, it still shows up in Stripe as $12.000. Could this possibly be an issue with Stripe instead of EE?


Josh

  • Support Staff

September 27, 2017 at 2:42 pm

I think this is an issue with Event Espresso’s Stripe integration. It doesn’t appear to support what Stripe calls the Zero Decimal currencies.

https://stripe.com/docs/currencies#zero-decimal

There should be a way to work around this. I don’t think you sent FTP access but I can either show you where to edit the gateway or share a modified file that will add that support. I’ll need a few minutes to put something together.


projectmgrIAABC

September 27, 2017 at 2:54 pm

Ok, sounds good. Do you need FTP access info? I can put that together if you need it.

Thank you!


Josh

  • Support Staff

September 27, 2017 at 3:00 pm

If you can send those via the secure form on the redeem a support token page I can apply the temporary fix to the Stripe add-on. A future version of the Stripe add-on should include a more permanent fix that will deal with all of the Zero Decimal Currencies, but we’re only concerned about getting things working today for your sites.


Josh

  • Support Staff

September 27, 2017 at 4:00 pm

Can you help me verify a few things so I understand how the prices should be displayed correctly? The first thing is the actual ticket price. Since I’m not familiar with the Chilean Peso I used a conversion tool to convert 120 Chilean Pesos to US Dollar and that was $0.19 US dollars, so that didn’t seem like the right amount. Then I tried this:

https://slack-files.com/T02SY781D-F79SHN1DH-ae82678c01

which seems like a typical ticket price amount. Am I way off on that?

Also, may I ask what does the format for the price look like? For example is the format used on this site what’s expected?

https://www.expatistan.com/cost-of-living/santiago-chile


projectmgrIAABC

September 27, 2017 at 4:10 pm

It should look like the image on Slack. So $120,000 Chilean Pesos is about $190 US which is our ticket price. Yes, on that expat site it’s correct. The comma takes the place of a decimal in U.S. dollars, and has 3 instead of 2 decimal places, so CH$467,739 would be $467.74 if you were writing the way it would be in the U.S.


Josh

  • Support Staff

September 27, 2017 at 5:04 pm

I was more under the impression that the comma worked more like a separator.

e.g
CH$434 Bread for 2 people for 1 day (note no decimal used here)
CH$1,448 2 liters of Coca-Cola
CH$706,445 Monthly rent for 85 m2 (900 Sqft) furnished accommodation in EXPENSIVE area


projectmgrIAABC

September 27, 2017 at 5:25 pm

The way the Chileans who are hosting the conference said it should be is that comma separates dollars and cents, unlike in the U.S. where it would be a dot. So $120.000,000 Chilean would be about $190 U.S. $1,200 CLP would be about $2 U.S. If I put $120.000 in the event ticket price, Stripe gives me $12.000.000 which is about $20,000 U.S. The exchange rate is about 1 CLP is equal to .00157 USD. I’m wondering now if Stripe is not understanding the comma because it’s listing the amount with two periods instead of a period between 12 and 000 and a comma between 000 and 000.


Josh

  • Support Staff

September 27, 2017 at 8:15 pm

The comma isn’t being sent to Stripe. Stripe expects API requests amounts to be provided in a currency’s smallest unit. For example, to charge $10 USD, they want an amount value of 1000 (i.e, 1000 cents).

For zero-decimal currencies like the Chilean Peso, Stripe still expects amounts as an integer but without multiplying by 100. For example, to charge CH$500, they expect an amount value of 500. I’m checking with the developers to work in a reliable way to make that switch so the Stripe Gateway knows which type of amount to send to Stripe.


Josh

  • Support Staff

September 28, 2017 at 11:26 am

Ok I loaded a modified version of the Stripe gateway add-on that handles the zero-decimal currency. Eventually there will be an update to the Stripe Gateway that will include support for zero-decimal currencies, but for now you can use the modified copy.


projectmgrIAABC

September 28, 2017 at 1:47 pm

Thanks! It’s still adjusting correctly. It now says 120 CLP on the Stripe payment page. But that’s about .18 cents US. So for Stripe’s purposes it should be 120000 CLP.


Josh

  • Support Staff

September 28, 2017 at 1:51 pm

It looks like you’ve set the price to be 120 CLP. The price actually needs to be set to 120000 CLP to convert to 188 USD. Here’s a link to that screenshot that shows the conversion:

https://slack-files.com/T02SY781D-F79SHN1DH-ae82678c01


Josh

  • Support Staff

September 28, 2017 at 2:04 pm

Further to the above, you can change the way the price is displayed in Event Espresso > General Settings > Countries. For example you may want to change the Currency Decimal Places to 0. This way when you set a ticket price to:
120000 it will display like this:

120,000 CLP
instead of
120,000.000 CLP


projectmgrIAABC

September 28, 2017 at 2:09 pm

Got it, I change the decimal places to 0 and flipped the comma and decimal point. Just tried it with Stripe and it’s working!! Thank you SO MUCH!!!!


Josh

  • Support Staff

February 27, 2018 at 12:39 pm

Hi again,

There was an update to the Stripe add-on released today and it includes a more permanent fix to handle zero decimal currencies.

The support post ‘Problem with Currency and Stripe’ is closed to new replies.

Have a question about this support post? Create a new support post in our support forums and include a link to this existing support post so we can help you.

Support forum for Event Espresso 3 and Event Espresso 4.
Documentation for EE3 and EE4
Documentation for Event Espresso 3

Documentation for Event Espresso 4

Status: closed

Updated by  Josh 9 months, 2 weeks ago ago

Topic Tags

Notifications

This topic is:
pending
Do NOT follow this link or you will be banned from the site!