Implications for a multi lingual, multi curreny e commerce site ??

[James Noon]

Hi

I'm about to start wotk on a large e commerce site which is to be multi
lingual and support multi currencies.

The site needs full content management so obviously it needs some severe
planning.

I was wondering if anyone knows of any resourses / advice for such a site.

I will be using asp and sql server

Many Thanks, James

[Paul Whitham TMM]

Here are my thoughts on doing this.

1) Use cookies on the site to determine the currency and language being
used.
2) Number & date formating on the pages can be handled using different
LCID settings which you can set based on the cookies
3) Determine what you base currency will be and only store your prices in
the products table. Have a second table to hold the conversion rates (unless
you are using live rates) and do your conversion to the other currencies at
run time.
4) The sales table should be the only one where you store the Foreign
currency amount so that you can show this on any order status page.
5) The number of languages involved will determine whether you store the
content in a different table, or as additional columns in the existing
table.

--
Regards

Paul Whitham
Macromedia Certified Professional for Dreamweaver MX2004
Valleybiz Internet Design
[url]www.valleybiz.net[/url]

Team Macromedia Volunteer for Ultradev/Dreamweaver MX
[url]www.macromedia.com/support/forums/team_macromedia[/url]

"James Noon" <james@chameleon-web.co.uk> wrote in message
news:d3ltbs$fi3$1@forums.macromedia.com...

> Hi
>
> I'm about to start wotk on a large e commerce site which is to be multi
> lingual and support multi currencies.
>
> The site needs full content management so obviously it needs some severe
> planning.
>
> I was wondering if anyone knows of any resourses / advice for such a site.
>
> I will be using asp and sql server
>
> Many Thanks, James
>
>