Post by robocop1953 » Wed Nov 06, 2013 5:21 am

I think I had this problem before in opencart but cannot fathom how (or if) it was figured out? I have a main (U.S.A.) site and a duplicate sub-domain site (Canadian). Exact same site except for each countries pricing. Pricing is correct for the U.S site but the Canadian version seems to be adding in 'something' in addition to the correct price entered per product and I cannot figure out what is causing this? Product shows $16.99 has been entered which is correct but is displaying on the site as $17.74??? Currency default is set as U.S. dollars for the U.S. site and Canadian dollars for the Canadian site. Currency settings show U.S. default value as 1.0000 ... and Canadian site shows CAD value as 1.0442996 (as of today).

Active Member

Posts

Joined
Wed Jul 17, 2013 2:18 am

Post by butte » Wed Nov 06, 2013 12:00 pm

Inverted. Divide 1 by 1.0442996 to 0.9575796 so that Canadians might enjoy having the better currency for the time being -- the two for years and years have tended to be within a nickel but which was worth the more has oscillated. My first thought was VAT, again, but the percentage is wrong for that and is visibly at the exchange rate. (On the other hand, go for it if a position running an exchange bank opens, you have an instinct for electronic profit.)

Guru Member

Posts

Joined
Wed Mar 20, 2013 6:58 am

Post by robocop1953 » Wed Nov 06, 2013 9:39 pm

Well thanks for the financial insight but how do I resolve the issue?

Active Member

Posts

Joined
Wed Jul 17, 2013 2:18 am

Post by butte » Wed Nov 06, 2013 11:11 pm

"Inverted. Divide 1 by 1.0442996 to 0.9575796" -- where you had put put "1.0442996" change that to "0.9575796" so that Canadians see their own current pricing. While USD is down and CAD is up by their usual nickel difference, CAD buys more for less than does USD. The Canadian price as you've shown it is higher rather than lower by the percentage seen in the exchange rate (at 1.0442996). The Canadian price as you need to show it is LOWER rather than higher by the percentage seen in the exchange rate (at 0.9575796). (There are reasons for dividing 1 by numbers of that kind in order to get the result; one is accuracy.)

Guru Member

Posts

Joined
Wed Mar 20, 2013 6:58 am

Post by chulann » Thu Nov 07, 2013 12:42 am

Perhaps I am mis-reading the original post, but is it stating that there are two separate and distinct sites and that separate prices have been entered for each product in each site? If so, the canadian CAD should also be entered as base currency of 1.0000.
You would only want the exchange rates if someone was purchasing cross-border to the site they entered.
ie. on US site US is set to 1.00, CAD is set to 1.04 and on the CDN site CAD is set to 1.0 and US set to 0.98

New member

Posts

Joined
Sun Aug 28, 2011 11:30 pm

Post by butte » Thu Nov 07, 2013 3:46 am

I read it as "Canadian version seems to be adding in 'something' in addition to the correct price entered" and thereby over and above the correct nominal Canadian 1.00 to the tune of + 0.0442996 = x1.0442996, requiring correction (divide 1 by 1.0442996) to 0.9575796, which should cause the somehow amended Canadian price show as expected, 1.00 (display will lop the further digits). That does assume that the spurious addition or multiplication will instead become subtraction or division so as to leave the Canadian 1.00 that was expected in the first place.

There is no "0.98" in the works, and that could well have been just mistyped "0.96", but, nonetheless, the figure seen as the discrepancy was 1.0442996 rather than 4.4 cents that would display in pricing.

Whether that might owe to currency updating is unknown at the moment. robocop1953, what have you set for currency updating (yes/no and how often) for EACH store (USA and Canada)?

Guru Member

Posts

Joined
Wed Mar 20, 2013 6:58 am

Post by robocop1953 » Sat Nov 09, 2013 2:40 am

Simple fix .... just setup each site as 'U.S. dollars' default but entered Canadian dollar values the CDN site set at 1.00000. No conversion applied, no additional monies added in. :)

Active Member

Posts

Joined
Wed Jul 17, 2013 2:18 am

Post by butte » Sat Nov 09, 2013 10:48 am

Both sides pay $1.00 USD per each $1.00 USD (defaulting in both to $1.00 USD value)? Or you had compensated and entered 1.0442996 rather than 0.9575796?

Guru Member

Posts

Joined
Wed Mar 20, 2013 6:58 am
Who is online

Users browsing this forum: No registered users and 98 guests