Adding or changing a currency conversion

Complete the following steps to add or change a currency conversion:

  1. For each currency conversion that you want to add or change, or to add a new EMU currency, use the following line in a mass loadable file:
  2. <curconvert curconvert_id="-21"
    storeent_id="-1" fromcurr="USD"
    tocurr="CAD" factor="1.26"
    multiplyordivide="M" bidirectional="Y"
    updatable="N"/>
    

    where:

    curconvert_id
    is a generated unique number specified in the CURCONVERT_ID column in the CURCONVERT table. 
    storeent_id
    is the store or store group ID.
    fromcurr
    is the three-character ISO 4217 currency code representing the original currency. This code must appear in the SETCCURR column of the SETCURR table.
    tocurr
    is the three-character ISO 4217 currency code representing the converted currency. This code must appear in the SETCCURR column of the SETCURR table.
    factor
    is the conversion rate.
    multiplyordivide
    indicates whether to multiply (M) or divide (D).
    bidirectional
    indicates whether the conversion is bi-directional (Y) or unidirectional (N).
    updatable
    indicates whether the conversion rate can be changed (Y) or not (N).
  3. Load the data to the WebSphere Commerce database. For instructions on how to load the data to the database, see Loading the data to the WebSphere Commerce database.