Post by randybell » Wed Mar 21, 2012 1:37 pm

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?

Newbie

Posts

Joined
Mon Jan 23, 2012 8:32 am

Post by dirtboy » Wed Mar 21, 2012 1:50 pm

goto System > Settings > Local and make sure your default currency is set to Canadian Dollar.

“Anyone who stops learning is old, whether at twenty or eighty. Anyone who keeps learning stays young. The greatest thing in life is to keep your mind young.”
- Henry Ford


User avatar
Active Member

Posts

Joined
Wed Mar 07, 2012 3:04 pm

Post by ruspect » Fri May 04, 2012 6:06 am

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 :crazy:
If smb know the way to change ISO Code to make OC works fine, please share it with as.
Thx

Newbie

Posts

Joined
Fri May 04, 2012 5:57 am

Post by ChrisWhiting » Thu Aug 01, 2013 11:14 pm

Was this resolved, because I am having the very same problem.

Newbie

Posts

Joined
Thu Oct 14, 2010 2:49 am

Post by Qphoria » Thu Aug 01, 2013 11:42 pm

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');

Image


User avatar
Administrator

Posts

Joined
Tue Jul 22, 2008 3:02 am
Who is online

Users browsing this forum: No registered users and 152 guests