homepage Welcome to WebmasterWorld Guest from 54.145.183.190
register, free tools, login, search, pro membership, help, library, announcements, recent posts, open posts,
Become a Pro Member
Home / Forums Index / Code, Content, and Presentation / Perl Server Side CGI Scripting
Forum Library, Charter, Moderators: coopster & jatar k & phranque

Perl Server Side CGI Scripting Forum

    
showing different languages and currencies
Adding this feature to my web site
usavetele

10+ Year Member



 
Msg#: 4083 posted 5:24 am on Jun 2, 2005 (gmt 0)

HELP!

All I'm interested in doing at this point is showing the prices on my site in multiple currencies and to allow the visitor to read my site in their language, based on the country they are viewing my site from.

Hope this makes sense. I'm not really interested in starting from stratch and setting up my site again under the osCommerce (ecommerce stuff) just to have access to the above mentioned functions.

Thanks in advance for any suggestions.

 

jatar_k

WebmasterWorld Administrator jatar_k us a WebmasterWorld Top Contributor of All Time 10+ Year Member



 
Msg#: 4083 posted 4:13 pm on Jun 2, 2005 (gmt 0)

do you have any of this functionality in place yet? I am not really sure if you are asking how to do this or if there is a product.

>> read my site in their language, based on the country

a little geo targetting plus some browser detection to find what language they are set to

>> showing the prices on my site in multiple currencies

find somewhere for rates, decide how often you are going to update them, how you are going to be sure you don't lose on conversion

just grab your rates and drop em in a db, convert prices on the fly, unless you have the prices for multiple currencies already, then no big deal.

lexipixel

WebmasterWorld Senior Member 10+ Year Member



 
Msg#: 4083 posted 1:18 am on Jun 3, 2005 (gmt 0)

find somewhere for rates

Bloomberg has a currency conversion calculator online (free to use)... Enter $1.00 (USD) and pick another currency...

Example results:

1.00 US DOLLAR (USD) = 9204.42 ZIMBABWE DOLLAR (ZWD)

Bloomberg is an authority on currencies, (mortgage companies, banks, etc.. base their conversion rates on what Bloomberg says a dollar is worth).

Be aware that rates can change (and DO) change for most currencies against the USD on a daily basis -- they can even change several times in a day.

Its best to put up a notice that "prices are approximate" and will be calculated at checkout or when payment is processed.

Some payment services (like PayPal) will convert on the fly for you.

usavetele

10+ Year Member



 
Msg#: 4083 posted 4:40 am on Jun 3, 2005 (gmt 0)

Thanks for the tips guys!

The language conversion for my site isn't as much of a problem since I have a link to babelfish translator that works great for translating to several different languages.

My main concern is figuring out the coding for converting prices into EURO, Canadian, Yen, etc. I have stumbled across a suggestion to set a session variable equal to the exchange rate and reset it every week. It will then change the prices across the entire website.

Does anybody know how to do this? There's got ot be somebody that knows the EXACT coding to do this.

Thanks!

jatar_k

WebmasterWorld Administrator jatar_k us a WebmasterWorld Top Contributor of All Time 10+ Year Member



 
Msg#: 4083 posted 4:34 pm on Jun 3, 2005 (gmt 0)

well, I spend all my time coding currencies, conversions, etc though I do it in php but the logic is the same.

I manage it all in a database, rough structure would be

currencies
current rates
historic rates
countries
countries to currencies connection

>> set a session variable equal to the exchange rate and reset it every week

all well and good but you need to store it on your site somewhere and database is usually easiest. Remember you may need rates both ways as well.

what might make more sense is to tag what country people are from and then have currencies attributed to each country. Store the country in the session and then when you display prices you can display them in every currency attributed to that country.

I don't know if you want to drag conversion rates around all the time in the session, maybe, but that would be a decision you could make somewhere late in the design phase (and I dont mean the coding phase ;) )

another thing to keep in mind. If you are updating rates you will need to store the old rates, otherwise you may have some issues with how much things cost last month if you try to use today's rate against a purchase from last month.

ah, accounting, isn't it fun, talk about redundant data

that's more or less the rough outline off the top of my head

usavetele

10+ Year Member



 
Msg#: 4083 posted 3:23 pm on Jun 4, 2005 (gmt 0)

Thanks jatar_k!

The only reason I want to convert my product prices on my new site is because the affiliate who's products I'm selling are all in EURO. On their site they show the prices like this:

US$ 40.35
22.35
CAD 50.97
Euro 32.99
4,399

Their site automatically converts all the other prices based on the value of the EURO and I've emailed them for assistance in having this feature on my site too, for selling their products. They just told me:

"Why don't you just set a session variable equal to the exchange rate and reset it every week, it will change the prices across the entire website?"

Sounds great, but how the hell do I do it? What's the exact coding? Guess this is something I'll have to figure out on my own. :( I have zero clue how to do variables, but I guess I'll spend the hundreds of hours searching the internet and piecing it together.

Thanks again!

Global Options:
 top home search open messages active posts  
 

Home / Forums Index / Code, Content, and Presentation / Perl Server Side CGI Scripting
rss feed

All trademarks and copyrights held by respective owners. Member comments are owned by the poster.
Home ¦ Free Tools ¦ Terms of Service ¦ Privacy Policy ¦ Report Problem ¦ About ¦ Library ¦ Newsletter
WebmasterWorld is a Developer Shed Community owned by Jim Boykin.
© Webmaster World 1996-2014 all rights reserved