Page 1 of 1
Processing all in Canadian (CAD) with Paypal
Posted: Wed Mar 21, 2012 1:37 pm
by randybell
I have a site taking orders ok, but it is always processing in US funds to paypal. It is a Canadian site and I only want to process things in Canadian funds, is there a way to force this?
Re: Processing all in Canadian (CAD) with Paypal
Posted: Wed Mar 21, 2012 1:50 pm
by dirtboy
goto System > Settings > Local and make sure your default currency is set to Canadian Dollar.
Re: Processing all in Canadian (CAD) with Paypal
Posted: Fri May 04, 2012 6:06 am
by ruspect
randybell wrote:I have a site taking orders ok, but it is always processing in US funds to paypal. It is a Canadian site and I only want to process things in Canadian funds, is there a way to force this?
It does not work, as by default Opencart uses ISO Code - CDN instead of actual code which is CAD used by paypal.
I do have the same problem and have no idea how to resolve it. I know there is a patch to fix the issue but vqmode has to be installed, I dont have one and dont wanna install it as Im not so good with it
If smb know the way to change ISO Code to make OC works fine, please share it with as.
Thx
Re: Processing all in Canadian (CAD) with Paypal
Posted: Thu Aug 01, 2013 11:14 pm
by ChrisWhiting
Was this resolved, because I am having the very same problem.
Re: Processing all in Canadian (CAD) with Paypal
Posted: Thu Aug 01, 2013 11:42 pm
by Qphoria
ruspect wrote:
It does not work, as by default Opencart uses ISO Code - CDN instead of actual code which is CAD used by paypal.
No it doesn't. OpenCart doesn't come with a CDN currency code by default. CDN is something you (and many other Canadians) incorrectly added because somehow 90% of the people in the nation of Canada don't know their own currency code! CAD CAD CAD CAD CAD!!!
So now you need to do the following
1. Fix your currency code in the System->Localisation->Currency area
2. Use phpmyadmin to update all existing order records to use "CAD" where it currently uses "CDN" by running this replace command.
Replace or remove the xxx_ part of the table to reflect your database prefix
Code: Select all
UPDATE `xxx_order` SET currency_code = REPLACE(currency_code, 'CDN', 'CAD');
Or if your store is v1.4.x you would use
Code: Select all
UPDATE `xxx_order` SET currency = REPLACE(currency, 'CDN', 'CAD');