Develop > Controller layer > Application developer > Support globalization > Globalized catalog content > Localized store assets

Add a new currency to WebSphere Commerce

WebSphere Commerce comes populated with many currencies and this section shows how to add a new currency.

The list of currencies supported by default can be found in

• WC_INSTALL/schema/xml/wcs.bootstrap_multi_en_US_base.xml

• WC_USER/schema/xml/wcs.bootstrap_multi_en_US_base.xml

• WC_INSTALL\schema\xml\wcs.bootstrap_multi_en_US_base.xml

• WCDE_INSTALL\schema\xml\wcs.bootstrap_multi_en_US_base.xml

• WC_INSTALL/schema/xml/wcs.bootstrap_multi_en_US_base.xml

To add a new currency (not supported by default) to WebSphere Commerce as a site supported currency:

Procedure

1. Add the national currency as a site-supported currency:

   insert into setcurr (setccurr, setccode, setcexp) 
   values (<Alphabetic currency code as per ISO 4217>,
   <Numeric currency code as per ISO 4217>,
   <The exponential value by which a subunit of the currency (such
   as cents)
   is multiplied to get the main currency unit>)
   

   For example:

   insert into setcurr (setccurr, setccode, setcexp) values ('THB', 818, -2)
   

2. Add a description to the national currency at the site level for your language_id. You can add a description to the national currency in as many languages as the system supports.

   insert into setcurrdsc (setccurr, language_id, description) values
   (<Alphabetic currency code>,
   <language_id>,
   <description>)
   

3. Add a currency formatting rule

   insert into curformat (storeent_id, setccurr, roundingmultiple, numbrusg_id, roundingmethod, decimalplaces) values (<storeentity> ,
   <Alphabetic currency
   code>,
   <Rounding multiple according to national law or
   practice. For
   example, specify 5 to round dollars to the nearest five cent piece.
   The
   default value is 1>,
   <How to round to a multiple of
   ROUNDINGMULTIPLE: R =
   round normally - up or down - to the nearest multiple T = truncate
   -
   round down for positive amounts, round up for negative amounts>,
   <The
   number of decimal places in a rounded or truncated monetary
   amount>);
   

   For example:

   insert into curformat (storeent_id, setccurr, roundingmultiple, numbrusg_id, 
   roundingmethod, decimalplaces, minapproveamount) values
   (-1,'THB',1,-1,'R',0,NULL)
   

   insert into curformat (storeent_id, setccurr, roundingmultiple, numbrusg_id, 
   roundingmethod, decimalplaces, minapproveamount) values
   (-1,'THB',1,-4,'R',0,NULL)
   

   insert into curformat (storeent_id, setccurr, roundingmultiple, numbrusg_id, roundingmethod, decimalplaces, minapproveamount) values
   (-1,'THB',1,-5,'R',0,NULL)
   

4. Add a currency formatting description.

   insert into curfmtdesc (storeent_id, setccurr, language_id, currencysymbol, customizedcurrstr, currencyprefixpos, currencysuffixpos, displaylocale, currencyprefixneg, currencysuffixneg, radixpoint, groupingchar, numberpattern, description) values (-1, 'THB', -11, 'B', null, 'B', null, null, 'B-', null, null, null, '#,##0.00', null)
   

   For more information refer to the CURFMTDESC table.

5. Add a conversion rule between the default currency of the store and the created currency:

   insert into curconvert (storeent_id, fromccurr, tocurr, factor, multiplyordivide, bidirectional, updatable, curconvert_id)
   values(-1,'USD','THB','44.62','M','Y','Y',-12)
   

Results

For more information refer to the CURCONVERT table.

Related concepts

Support globalization

Localized store assets

Cultural considerations

Related tasks

Create a globalized store

Add a language or currency to a store archive

Currency and number formatting

Related reference

Globalization tips

massload utility (Server environment)

+

Search Tips   |   Advanced Search