Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

Automatic Currency adjustment by continent


Gyakutsuki

Recommended Posts

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 by Gyakutsuki


Regards
-----------------------------------------
Loïc

Contact me by skype for business
Contact me @gyakutsuki for an answer on the forum

 

Link to comment
Share on other sites

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 by Gyakutsuki


Regards
-----------------------------------------
Loïc

Contact me by skype for business
Contact me @gyakutsuki for an answer on the forum

 

Link to comment
Share on other sites

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

Link to comment
Share on other sites

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.


Regards
-----------------------------------------
Loïc

Contact me by skype for business
Contact me @gyakutsuki for an answer on the forum

 

Link to comment
Share on other sites

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.


Regards
-----------------------------------------
Loïc

Contact me by skype for business
Contact me @gyakutsuki for an answer on the forum

 

Link to comment
Share on other sites

Base on my experience, i sell original game.

Example for game Battlefield 3

 

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

EU people don't care about USD, if they see you sell it for 45they 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 by dolphin18
Link to comment
Share on other sites

how about application_top.php

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


Regards
-----------------------------------------
Loïc

Contact me by skype for business
Contact me @gyakutsuki for an answer on the forum

 

Link to comment
Share on other sites

  • 3 months later...

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 by angusbeef
Link to comment
Share on other sites

  • 6 months later...

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.


Regards
-----------------------------------------
Loïc

Contact me by skype for business
Contact me @gyakutsuki for an answer on the forum

 

Link to comment
Share on other sites

@@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)?

Link to comment
Share on other sites

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 by Gyakutsuki


Regards
-----------------------------------------
Loïc

Contact me by skype for business
Contact me @gyakutsuki for an answer on the forum

 

Link to comment
Share on other sites

  • 1 month later...

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

Link to comment
Share on other sites

line 151

$number_files = osc_count_files_directory_cache_geolocalisation ();

 

change by

$number_files = tep_count_files_directory_cache_geolocalisation ();


Regards
-----------------------------------------
Loïc

Contact me by skype for business
Contact me @gyakutsuki for an answer on the forum

 

Link to comment
Share on other sites

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?

Link to comment
Share on other sites

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)


Regards
-----------------------------------------
Loïc

Contact me by skype for business
Contact me @gyakutsuki for an answer on the forum

 

Link to comment
Share on other sites

  • 3 years later...

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Unfortunately, your content contains terms that we do not allow. Please edit your content to remove the highlighted words below.
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...