Currency change for specific customers

At the moment the products_Results page and products_Detail page displays the product prices in pounds sterling, the numeric value in sterling is stored in the database and displayed next to a static £ symbol on these pages.

All the prices from thereon to the checkout page are conducted in sterling including all shipping and taxes.

Is it possible to distinguish when a user logs in to identify their country of origin based on their registration details and subsequent login to either display prices and conduct the purchase in sterling if they have registered with a UK address or to display Euros and conduct the purchase in Euros (including shipping and taxes) if they have registered with an address which is anywhere in the world outside of the UK.

There would be no automatic conversion for sterling to Euros but the client would enter fixed euros prices into the database for all the products (including shipping and taxes) and these would be periodically reviewed and amended when appropriate. These euro details would then be used for conducting the purchase for all users registered from outside the UK.

How would this impact on the backend of the site for inserting and updating product details and any other areas of the front end of the site?

I need to evaluate how big a task this is to respond to the client's request.

it wouldn't be a small addition to do this, and would require considerable hand coding.

the product insert and updated pages would need to have a new form element added for the Euro price, and you would need to edit the insert and update record behaviors to use that new form element.


you would need to modify the login to store the users country in a session variable

on the product pages, you would need to create an if statement to show the proper column based on the session value

and you would need to edit the eCart add to cart code to use the correct price column based on the session value.

you would also need to edit the eCart code for sending the transaction to the gateway to use the correct currency code, and edit the shipping behavior code to use the correct currency code

Ok, thanks for this detailed reply.

Can you suggest a less comprehensive solution that would possibly display sterling and euro prices alongside each other for non-UK cutomers but then proceed to checkout using sterling as normal.

I believe there are online currency converters but is this feasible or even possible?

your products table would need to have a column for each price.

you could display both prices on the products page and only bind the cart price column to the one where you store pounds sterling.

The client doesnt want to display both currencies prefering to display either sterling or euro depending on the login details, sterling for UK customers and euro for all non-UK customers.

The transaction through to gateway would then be completed in sterling so only the display on results and detail pages would need to be either sterling or euro.

I'm OK with the extra database column and the insert/update pages but need help with the following from your earlier post.

"you would need to modify the login to store the users country in a session variable"

"on the product pages, you would need to create an if statement to show the proper column based on the session value"

I enclose the login and product pages.

on the login page, open the server behaviors panel, and double click the Security Assist Authenticate user server behavior. Go to the Session values tab, click the plus button and select the users country column to store it in a session when the user logs in.


on the page where you display the price, you can use that session variable to determine which to show, for example, if the session is set with the name "country" and has a value of "UK" for United Kingdom:

<?php if(isset($_SESSION['country'])) && $_SESSION['country'] == "UK") { ?>

Show sterling price

<?php } else { ?>

Show Euro price

<?php } ?>

Ok, thanks.

Is there a preferred position for inserting this code block on the product pages?

I'm curious how this block of code selects either the sterling or euro price column from the database?

place it where you would like the price to be displayed.

In the if statement, add the binding for the Sterling price column from your database where it says "Show sterling price" and add the binding for the Euro price column where it says "Show Euro price".

Ok thanks, should be able to do it now.

Thanks Jason, got to work OK, but for anybody following this topic, only after correcting a syntax error as shown below.

<?php if(isset($_SESSION['country'])) && $_SESSION['country'] == "UK") { ?>

should be

<?php if(isset($_SESSION['country']) && $_SESSION['country'] == "UK") { ?>