CSV File Format for Uploading Products

Before uploading a product file through the File Upload Interface utility, you need to ensure that the CSV file contains the following data:

Data Description Mandatory (Yes or No)
Product Used to specify the product. Yes
Description Used to specify the description for the product. Yes
Product Type Used to indicate the type of the product. The valid values are:

  • INFO - Enables you to create an informational product.

  • BUSS - Enables you to create a packaged product.

  • TECH - Enables you to create a standard product.

 Yes
Product Category Used to indicate the category of the product. The valid values are:

  • CHKG

  • LOAN

  • OTHS

  • SAVG

Yes
Start Date Used to specify the date from when the product is effective. Yes
End Date Used to specify the date till when the product is effective. No
Compliance Number Used to specify the compliance number received from the legal department for a particular product. No
Product Manager's To Do Role No
Characteristic Type Used to specify the characteristic type. Yes (Conditional)
Note: This data is required when you want to define a characteristic for the product.
Effective Date Used to specify the date from when the characteristic is effective for the product. Yes (Conditional)
Note: This data is required when you want to define a characteristic for the product.
Characteristic Value Used to specify the value for the characteristic type. Yes (Conditional)
Note: This data is required when you want to define a characteristic for the product.
Division Used to indicate the division to which you want to associate the product. Yes
Product Used to indicate the product that you want to associate with the parent product. Yes (Conditional)
Note: This data is required when you want to create a product to product relationship.
Relationship Type Used to indicate the product to product relationship type. The valid values are:

  • CHLD

  • PRNT

Yes (Conditional)
Note: This data is required when you want to create a product to product relationship.
Start Date Used to specify the date from when the product to product relationship is effective. Yes (Conditional)
Note: This data is required when you want to create a product to product relationship.
End Date Used to specify the date till when the product to product relationship is effective. No