# Payment currency in EU
**URL:** https://forum.ghost.org/t/payment-currency-in-eu/9791
**Category:** Memberships & subscriptions
**Created:** [October 26, 2019, 3:38pm UTC](https://forum.ghost.org/t/payment-currency-in-eu/9791 "2019-10-26T15:38:07Z")
**Posts on this page:** 20
**Page:** 1
### Author:  [@giacomosilli](https://forum.ghost.org/u/giacomosilli)
#### Post date: [October 26, 2019, 3:38pm UTC](https://forum.ghost.org/t/payment-currency-in-eu/9791/1 "2019-10-26T15:38:07Z")
I read somewhere that officially, at the moment, only the dollar is supported.
Is there any workaround to also use the euro? until it is officially supported by Ghost.
---
### Author:  [@egg](https://forum.ghost.org/u/egg)
#### Post date: [October 28, 2019, 3:27am UTC](https://forum.ghost.org/t/payment-currency-in-eu/9791/2 "2019-10-28T03:27:56Z")
A **very not officially supported** work-around is to change the value of `members_subscriptions_settings` in the `settings` table of the database!
If you’re going to do this, be careful, take backups and don’t expect too much support until we have official first class support!
Good luck, have fun 😌
---
### Author:  [@giacomosilli](https://forum.ghost.org/u/giacomosilli)
#### Post date: [October 28, 2019, 9:05am UTC](https://forum.ghost.org/t/payment-currency-in-eu/9791/3 "2019-10-28T09:05:22Z")
Ok thanks for the information, I’ll try on a replica 🙂
Are you planning to add other currencies?
---
### Author:  [@egg](https://forum.ghost.org/u/egg)
#### Post date: [October 28, 2019, 9:06am UTC](https://forum.ghost.org/t/payment-currency-in-eu/9791/4 "2019-10-28T09:06:29Z")
Yes definitely 😌
---
### Author:  [@OZRay911](https://forum.ghost.org/u/OZRay911)
#### Post date: [November 12, 2019, 4:47pm UTC](https://forum.ghost.org/t/payment-currency-in-eu/9791/5 "2019-11-12T16:47:20Z")
We really need this 🙂 I will try the workaround I need to support CAD currency.
There is a webhook/api in Ghost that could be used to grab payment using PayPal? Catch the result using Zapier and push the newly subscription email back to Ghost using Zapier again maybe? I’m doing a lots of funky integration using Zapier it’s pretty powerful.
---
### Author:  [@OZRay911](https://forum.ghost.org/u/OZRay911)
#### Post date: [November 28, 2019, 8:25am UTC](https://forum.ghost.org/t/payment-currency-in-eu/9791/6 "2019-11-28T08:25:31Z")
The value is stored as a json? Do you mind pointing me out how to modify the usd value to cad I will test this and reply with the result? I’m not familiar with UPDATE command in mysql… 🙂 I need to change the complete json string or there is a way to just change the value? thanks
---
### Author:  [@dsecareanu](https://forum.ghost.org/u/dsecareanu)
#### Post date: [November 28, 2019, 10:59am UTC](https://forum.ghost.org/t/payment-currency-in-eu/9791/7 "2019-11-28T10:59:16Z")
Yes, multiple or customizable currencies would help a lot. Thanks!
---
### Author:  [@egg](https://forum.ghost.org/u/egg)
#### Post date: [November 28, 2019, 3:02pm UTC](https://forum.ghost.org/t/payment-currency-in-eu/9791/8 "2019-11-28T15:02:32Z")
@OZRay911 Yeah the value is stored as a string of JSON, so you’ll need to update the entire string with your new version.
The command would look something like
```auto
UPDATE
settings
SET
value = '{new json string in here}'
WHERE
key = 'members_subscription_settings';
```
Please do not forget:
> A **very not officially supported** work-around is to change the value of `members_subscriptions_settings` in the `settings` table of the database!
---
### Author:  [@OZRay911](https://forum.ghost.org/u/OZRay911)
#### Post date: [November 28, 2019, 3:46pm UTC](https://forum.ghost.org/t/payment-currency-in-eu/9791/9 "2019-11-28T15:46:50Z")
Thanks! Yes I totally understand that this is not officially supported.
---
### Author:  [@OZRay911](https://forum.ghost.org/u/OZRay911)
#### Post date: [November 28, 2019, 9:11pm UTC](https://forum.ghost.org/t/payment-currency-in-eu/9791/10 "2019-11-28T21:11:05Z")
Humm unable to make this work for the moment… It crash my subscription admin page 🙂 Maybe I didn’t update correctly the json value. I will try again I can’t bill my user in USD.
---
### Author:  [@OZRay911](https://forum.ghost.org/u/OZRay911)
#### Post date: [November 28, 2019, 10:42pm UTC](https://forum.ghost.org/t/payment-currency-in-eu/9791/11 "2019-11-28T22:42:48Z")
Well… I have been warned… Everything is working but now the lab page the membership section is totally broken. I click on the Expand and do nothing, after the 2 expand buttons the page is empty. So be aware guys that this is not black and white changes. ☹
---
### Author:  [@giacomosilli](https://forum.ghost.org/u/giacomosilli)
#### Post date: [November 28, 2019, 11:22pm UTC](https://forum.ghost.org/t/payment-currency-in-eu/9791/12 "2019-11-28T23:22:28Z")
Well, thanks for the information. Tomorrow I will try on a reply
---
### Author:  [@OZRay911](https://forum.ghost.org/u/OZRay911)
#### Post date: [November 29, 2019, 12:42am UTC](https://forum.ghost.org/t/payment-currency-in-eu/9791/13 "2019-11-29T00:42:33Z")
Working! Ho yeah! Ok after a day of trying many things it’s now working, I have Ghost membership charging in Canadian currency! So Fabien (unsupported) tips is in fact working. The only way in my case I have been able to make it work is by first dump the DB to an SQL file, isolate the settings table creation and value part, modify the “usd” (x2) for “cad” drop the settings table from the db and run the SQL table creation and value for settings. Now working my users can subscribe in CAD. Please note that this is not changing USD from the admin page/panel but in the subscription page it’s the correct currency and also on Stripe it’s charged in CAD. Thanks for the tips Fabien.
---
### Author:  [@anand](https://forum.ghost.org/u/anand)
#### Post date: [November 30, 2019, 5:58pm UTC](https://forum.ghost.org/t/payment-currency-in-eu/9791/14 "2019-11-30T17:58:38Z")
Why not we have dual currency? Like US$ for worldwide and one local currency. On frontent we might have a toggle button for users to change it of their choice.
In India we can’t charge other fellow Indians in foreign currencies. We must accept Indian rupees.
This thing will probably fix many things.
---
### Author:  [@giacomosilli](https://forum.ghost.org/u/giacomosilli)
#### Post date: [January 13, 2020, 1:20pm UTC](https://forum.ghost.org/t/payment-currency-in-eu/9791/15 "2020-01-13T13:20:21Z")
What’s new about this update? I am **not** asking for ETA, but only if it is under development. Otherwise I proceed with the solution proposed by @egg
Thank you
---
### Author:  [@Sanjay\_Kumar](https://forum.ghost.org/u/Sanjay_Kumar)
#### Post date: [February 12, 2020, 6:34pm UTC](https://forum.ghost.org/t/payment-currency-in-eu/9791/16 "2020-02-12T18:34:25Z")
I tried to change to inr and CAD both but the changes aren’t reflected.
Here is query I used to change the JSON:
```
`UPDATE settings s SET value = JSON_REPLACE(s.value, "$.paymentProcessors.config[0].plans[0].currency", "CAD") WHERE s.key = "members_subscription_settings"`
```
`UPDATE settings s SET value = JSON_REPLACE(s.value, "$.paymentProcessors.config[0].plans[1].currency", "CAD") WHERE s.key = "members_subscription_settings"`
Please help me fix this, this has been a pain since last few days. Otherwise, I will have to go back to Wordpress. Also let me know, if INR is supported or not.
---
### Author:  [@Kevin](https://forum.ghost.org/u/Kevin)
#### Post date: [February 12, 2020, 9:40pm UTC](https://forum.ghost.org/t/payment-currency-in-eu/9791/17 "2020-02-12T21:40:43Z")
@Sanjay_Kumar are you restarting Ghost each time you make manual changes to the settings table? Settings are cached to avoid unnecessary db queries, making changes via the API resets that cache but manual db changes will not.
---
### Author:  [@gregpozo](https://forum.ghost.org/u/gregpozo)
#### Post date: [February 13, 2020, 9:51am UTC](https://forum.ghost.org/t/payment-currency-in-eu/9791/18 "2020-02-13T09:51:31Z")
I wasn’t aware that happens in other countries although it makes sense.
---
### Author:  [@giacomosilli](https://forum.ghost.org/u/giacomosilli)
#### Post date: [February 13, 2020, 2:33pm UTC](https://forum.ghost.org/t/payment-currency-in-eu/9791/19 "2020-02-13T14:33:14Z")
@egg @Kevin If I make this change, will I have update problems when you release the official version?
---
### Author:  [@egg](https://forum.ghost.org/u/egg)
#### Post date: [February 13, 2020, 3:57pm UTC](https://forum.ghost.org/t/payment-currency-in-eu/9791/20 "2020-02-13T15:57:31Z")
@giacomosilli
> [@egg](#):
>
> A **very not officially supported** work-around is to change the value of `members_subscriptions_settings` in the `settings` table of the database!
It’s definitely a possibility, though at this point I’d say it’s unlikely
[Next page](https://forum.ghost.org/t/payment-currency-in-eu/9791.md?page=2)