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

• AIX|Linux|Solaris:

  WC_installdir/schema/xml/wcs.bootstrap_multi_en_US_base.xml

• I5/OS: WC_userdir/schema/xml/wcs.bootstrap_multi_en_US_base.xml

• Windows:

  WC_installdir\schema\xml\wcs.bootstrap_multi_en_US_base.xml

• WCDE_installdir\schema\xml\wcs.bootstrap_multi_en_US_base.xml

• WC_installdir/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:

1. Add your 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 your national currency at the site level for your language_id. You can add a description to your national currency in as many languages as your 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)
   

For more information refer to the CURCONVERT table.

Related concepts

Supporting 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)