Currency Mapping Template

Template for the bulk upload of Currency to the Vroozi Catalog Module.

    1. Row Number
        • Column Name: ROW_NUMBER
        • Required/Optional: Required
        • Description: Add sequential numbers in each row to uniquely identify each row. These numbers are used to reference these rows in the error report. 
        • Example: 1, 2, 3, etc.
    2. Unique System ID
        • Column Name: UNIQUE_SYSTEM_ID
        • Required/Optional: Optional
        • Description: smartOCI can detect the ERP system that a Shopper is accessing smartOCI from. Each system must have a unique identifier. The system will then perform the necessary data mapping functions, based on the Shopper's identified ERP system. 
        • Example: SAP100, SRM200
    3. Currency Codes in the Catalog
        • Column Name: SUPPLIER_CURRENCY
        • Required/Optional: Required
        • Description: The currency codes used in the catalog load file. 
        • Example: US Dollars, Pound Sterling
    4. Currency Codes to be Mapped to
        • Column Name: COMPANY_CURRENCY
        • Required/Optional: Required
        • Description: The currency codes to be sent to the external ERP system upon checking out the smartOCI shopping cart. The SUPPLIER_CURRENCY value is changed to the COMPANY_CURRENCY value
        • Example: USD, GBP
        • Column Name: COMMENTS
        • Required/Optional: Optional
        • Description: Comments can be optionally added to any row. These comments are then visible to other Master Administrators on the data mapping screen. 
    6. Description
        • Column Name: DESCRIPTION
        • Required/Optional: Optional
        • Description: Description can be optionally added to any row. This description is displayed next to the COMPANY_CURRENCY values, in the free text order form. 
    7. Display
        • Column Name: DISPLAY
        • Required/Optional: Optional
        • Description: Rows can be flagged to be displayed, by adding a simple "x" in the DISPLAY field. Rows which are flagged for display, are shown in the free text order form. 
    8. Associated Content Views
        • Column Name: CONTENT_VIEWS
        • Required/Optional: Optional
        • Description: Content Views can optionally be associated with a COMPANY_CURRENCY value, to restrict its availability to Shoppers that have access to the same Content View. If left empty, the corresponding COMPANY_CURRENCY will be visible to all Shoppers in the free text order form. 
Was this article helpful?
0 out of 0 found this helpful
Have more questions? Submit a request