Welcome to WebmasterWorld Guest from 188.8.131.52
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.
>> 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.
find somewhere for rates
Bloomberg has a currency conversion calculator online (free to use)... Enter $1.00 (USD) and pick another currency...
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.
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.
I manage it all in a database, rough structure would be
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
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:
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.