Payment currency in EU

Memberships & subscriptions
1

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.

2

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 :relaxed:

2 Likes
3

Ok thanks for the information, I’ll try on a replica :slight_smile:

Are you planning to add other currencies?

4

Yes definitely :relaxed:

1 Like
5

We really need this :slight_smile: 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.

6

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… :slight_smile: I need to change the complete json string or there is a way to just change the value? thanks

7

Yes, multiple or customizable currencies would help a lot. Thanks!

8

@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

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!

9

Thanks! Yes I totally understand that this is not officially supported.

1 Like
10

Humm unable to make this work for the moment… It crash my subscription admin page :slight_smile: Maybe I didn’t update correctly the json value. I will try again I can’t bill my user in USD.

11

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. :frowning:

12

Well, thanks for the information. Tomorrow I will try on a reply

13

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.

1 Like
14

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.

15

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

16

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.

1 Like
17

@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.

18

I wasn’t aware that happens in other countries although it makes sense.

19

@egg @Kevin If I make this change, will I have update problems when you release the official version?

20

@giacomosilli

It’s definitely a possibility, though at this point I’d say it’s unlikely