Automatic Currency adjustment by continent

[♥Gyakutsuki 161]

A new contribution with a web service who adjust automaticly the currencies in function the country.

If you default currency is CAD and your configuration has EUR, then the customer come from Europe see automaticly the EUR

 

By default :

All Europe : EUR

North America : USD (United States) and CAD (Canada)

Default : your default currency

 

you can use the webservice until 100 000 resquest by day

Let me know your experience.

 

http://addons.oscommerce.com/info/8571

Edited September 26, 2012 by Gyakutsuki

[dolphin18 0]

Nice contribution, but when i apply this contribution it's say :

 

Warning: Cannot modify header information - headers already sent by (output started at catalog/includes/functions/geolocalisation.php:98) in catalog/includes/functions/general.php on line 51

[♥Gyakutsuki 161]

in your configure.php : add this

 define('DIR_FS_CACHE', DIR_FS_CATALOG . 'cache/');

Don't forget to give 777 (recursive) in your geolocalisation directory

Edited September 27, 2012 by Gyakutsuki

[dolphin18 0]

I set cache and geolocalisation to 777, add this code :

define('DIR_FS_CACHE', DIR_FS_CATALOG . 'cache/');

 

But still no luck, maybe you can take look to my file

(application_top.php and general.php)

 

btw I've been waiting for someone to make this contribution, This can be added to detect the language as well.

application_top.php

general.php

[♥Gyakutsuki 161]

Example you can do with this contribution

 

You don't want to sell the product the same price on the differents continents, or country

This contribution can do that.

In currencies section on oscommerce, you can update your currencies or you can change also the amount of conversion.

 

If a customer come from America and clic on french flag, it will see only the price in US and not in EURO. it's impossible for him to compare the price and see the difference

 

Lot big site has this marketing approach.

 

Also lot of persons don't see that, but lot of site change the price if they come with desktop or mobile phone. It consider to create a mobile phone website cost money, and it change the price in function.

 

For example, with this contribution, you can modify the newsletter and send a specific newsletter by continent, country .... ==> that's another marketing approach.

the marketing communication approach is not the same in england and America

 

Another exemple, In oder, you can see the address on google map, ip informaton (there is another contribution on that) ....

 

Just a little update this contrib and you can have a lot of informations on your customer for verification or to developp your marketing.

[♥Gyakutsuki 161]

This can be added to detect the language as well ===> Oscommerce do that well.

 

Dolphin, I don't understand what's your problem with general.php ? There is no relation.

 

I test and it work fine on my site.

 

I see nothing on your file for me, maybe the problem can come on your hosting or you do a little error.

[dolphin18 0]

Base on my experience, i sell original game.

Example for game Battlefield 3

 

EA Sell $49.99 in the U.S. and sell 49.99€ in EU.

EU people don't care about USD, if they see you sell it for 45€ they will buy.

 

you will get a bigger profit if sold in £

 

This can be added to detect the language as well ===> Oscommerce do that well.

 

Dolphin, I don't understand what's your problem with general.php ? There is no relation.

 

I test and it work fine on my site.

 

I see nothing on your file for me, maybe the problem can come on your hosting or you do a little error.

 

how about application_top.php ?

Edited September 28, 2012 by dolphin18

[♥Gyakutsuki 161]

how about application_top.php

No I compare rapidly your files : general and application_top with original osc, I see nothing.

[angusbeef 0]

Hi, i find this error after insert the SQL, any hints?

 

 

SQL query:

 

SELECT label, id

FROM `phpmyadmin`.`PMA_bookmark`

WHERE dbase = 'mystore'

AND (

 

user = 'xxxxx'

OR user = ''

)

ORDER BY label

MySQL said:

 

#1146 - Table 'phpmyadmin.PMA_bookmark' doesn't exist

Edited January 17, 2013 by angusbeef

[angusbeef 0]

N one more problem occur: i am unable to set the configure to 444 now.

please help!

[♥Gyakutsuki 161]

A new version has been downloaded.

The webservice has been adapted

include a new function delete files if there is more 100 files on the server.

[greasemonkey 190]

@@Gyakutsuki I've been looking for an addon like this... I currently auto change currency on country prior to checkout to force my US customers to checkout in USD.

 

I haven't installed it yet, so I though I would ask - you call it currency adjustment by continent... We are located in Canada and our default currency is CAD. Will this auto adjust to USD for my US customers (obviously, we are on the same continent)?

[♥Gyakutsuki 161]

Currency adjustment by continent ====> the term is not perfect, it's better currency adjustment by country. but you can do also by continent if you want (just a little modification).

The module has a very interesting marketing evolution, inside the code, you have all information to increase this aspect.

 

Currently, This contribution identify where you are by your IP, if you are in USA, the currency will be $ US, if you are in Canada, the currency will be in $ CAD.

But if you modifiy the code, you can force all the customer to pay in US.

 

At this time, I put inside the contribution, EUR, US, US CAD.

Edited July 29, 2013 by Gyakutsuki

[greasemonkey 190]

@@Gyakutsuki I finally got around to installing this in my sandbox site to test... However, I'm having an issue.

 

I receive the following error when I set to true in my store config; Fatal error: Call to undefined function osc_count_files_directory_cache_geolocalisation() in /home/******/public_html/sandbox/includes/functions/geolocalisation.php on line 151

 

Any idea what I missed? I only installed the English sql as my store is only... I see IP files in the cache... so its working (I think... I will check with a proxy after I fix this issue)...

[♥Gyakutsuki 161]

line 151

$number_files = osc_count_files_directory_cache_geolocalisation ();

 

change by

$number_files = tep_count_files_directory_cache_geolocalisation ();

[greasemonkey 190]

Worked ... thank you kindly.

 

Just testing now via US based proxy and they currency doesn't seem to be changing automatically to USD?

 

I confirmed the IP is US via ip2location

 

My default currency is CAD (in admin and includes/language/English.php). And USD is my only other currency (I don't use EUR).

 

Any ideas?

[♥Gyakutsuki 161]

It seems the api is depreacated, it doent work : look http://www.easyjquery.com

I need to rewirte the contribution.

[greasemonkey 190]

Shoot... Let me know if u need any assistance. I'm not a coder but could help test.

[♥Gyakutsuki 161]

I created a new version : http://addons.oscommerce.com/info/8571

tested and must work fine.

 

you can test with https://zenmate.io/home : (need chrome browser)

[greasemonkey 190]

I'll give it a try later today. Thanks kindly!

[greasemonkey 190]

working in my sandbox... thanks again!

[♥Gyakutsuki 161]

de nada :)

 

+

[Pinball 0]

Does this still work? No updates since 2013...

 

Thanks!

[♥Gyakutsuki 161]

No it doesn' work because the site is down.