Copied to clipboard

Flag this post as spam?

This post will be reported to the moderators as potential spam to be looked at


  • Matt Taylor 873 posts 2086 karma points
    Jan 04, 2012 @ 20:50
    Matt Taylor
    0

    Currency cultures and formats

    This business with the languages/currencies/countries always confuses me.

    I have a site that's split into two languages (English & German) but there's only one currency (Euro).

    When I'm viewing it in German I want all the prices to be displayed in the German culture with the comma as the decimal seperator (62,99 €).

    When I switch to the English site I want the prices to be displayed in the English culture with the point decimal seperator (€ 62.99 or 62.99 ).

    I had half expected it to use the culture of the site from the hostname's set language.

    In Tea Commerce the culture is set on the currency itself so it's not going to work like this and after playing with the starter kit I've seen that currencies are always formatted one way.

    Do you have any suggestions on changing this behaviour?

    Thanks, Matt

  • Rune Grønkjær 1372 posts 3103 karma points
    Jan 05, 2012 @ 08:27
    Rune Grønkjær
    0

    Matt Taylor,

    Your problem is that the english .net cultures does not use the format the currency in euro. In Tea Commerce every currency have a culture attached, and that culture decides how to format the currency. I'm not entirely sure, but you might have two options.

    The first one is to create your own custom Culture, and use it to create a custom format rule for the currency. It's very technical. We have not done it before, but we would very much like to know how (And so would a lot of other Tea Commerce users probably as well). You should be able to create it, register it in .net and then select it in the Tea Commerce currency. With this solution you would have two euro currencies. One for german and one for english. This might be a place to start: http://stackoverflow.com/questions/1304507/create-custom-culture-in-asp-net

    The second one is not as technical but it's a hack. You will again create two currencies, one being the standard euro for german. The other will be for english and you will choose an english culture for it. Now it will format the prices in pounds, which is not what we want. But you then hack it on the english language and just use the price decimal and the pre or append the €.

    If you need a hand on this or if you have an idea as to how Tea Commerce could better support this, feel free to email on [email protected] us and we can give you a quote.

    /Rune

  • Matt Bliss 176 posts 234 karma points c-trib
    Jan 05, 2012 @ 09:59
    Matt Bliss
    0

    Hi Rune,

    I found this post looking for something else but thought it was an interesting problem. As a suggestion for future versions; could the functions in Tea Commerce that format prices use the ISO currency code as the basis for the symbol used rather than the culture (http://www.xe.com/symbols.php), but still use the culture for formatting the numeric part and the position of the symbol? 

    Matt Bliss

  • Rune Grønkjær 1372 posts 3103 karma points
    Jan 06, 2012 @ 08:29
    Rune Grønkjær
    0

    Yeah, we talked about this as well. Would be a cool feature. I will write it on our wishlist.

    /Rune

  • Anders Burla 2560 posts 8256 karma points
    Jul 19, 2012 @ 16:29
    Anders Burla
    0

    Hi all

    Did you know that this has been implemented in one of the later versions of Tea Commerce?

    Kind regards
    Anders

  • Matt Taylor 873 posts 2086 karma points
    Jul 19, 2012 @ 16:40
    Matt Taylor
    0

    Good work!

Please Sign in or register to post replies

Write your reply to:

Draft