Page History

'field' is a database term. All the bits of information that your website uses are contained and managed in a database dedicated to your business. In this database, information is organised in a collection of tables. A table contains data grouped for a function or feature your website uses. Some examples are Users, Products, and Orders. A table has columns or fields that each contain a data type. Each row contains a record of values a single entity has for each data type.

When you add, edit or view a page in the CMS or on your website, you are accessing database fields and values entered for them. Some like Email Address and Default Customer Account for the User table are standard on your website. 

Custom fields are fields that are not on pages in the out-of-the-box version of the Customer Self Service eCommerce PlatformCV ECommerce platform. 

• 1. In the CMS, go to E-Commerce → Advanced Content → Custom Fields. 
     
     
  2. Select the Users table.
     
     
  3. The page will load, displaying any existing custom fields for the User table.
     
     
  4. Click the Add New Custom Field button. 
     
     
  5. In Add Custom Field Details, enter the field requirements (for display and entry of values by administrators): 
     • Field Name - a code to identify this field in the database. Alphanumeric only, with no spaces or special characters. Underscore ( '_ ') permitted.
     • Prompt - the field label displayed next to the field.
     • Help - additional information about the field displayed.
     • Data Type:
       • • Text - alphanumeric characters, including spaces, special characters, and html.
         • Integer - whole numbers
         • Decimal - numeric data including fractional components
         • DateTime - calendar dates and times
         • Boolean - toggle for a 2 value option, e.g. True/False, Yes/No
           
           

  • • Display Type - the interface displayed to Administrators on the page the field appears in. NOTE - Display Type options depend on the Data Type selected.

      Expand
      title Click here for an explanation of display types...
      Tip title What is... integer -  a whole number boolean - functionality that only has two possibilities: ON or OFF, YES or NO etc Display Type Available for Data Type Example Text Box Text, Integer, Decimal One line text box Multi-line Text Box Text HTML Text Box Text WYSIWYG content editor that allows the text to be formatted XML Text Box Text Dropdown List Text, Integer, Decimal Image Selector Text Numeric Text Box Integer, Decimal Date Picker DateTime Time Picker DateTime Date/Time Picker DateTime Check box (toggle) Boolean NOTE - displays as a toggle

      
      

    • Allow Unlimited Text - (for Text Display Type only) tick to allow unlimited amount of text 
    • Mandatory - tick to make the custom field required on the page it displays in.
    • Active - leave ticked for the field to be in use. Untick to make inactive. NOTE - The field must be active for use with Import Users.
      
      
      
  • Save the custom field. You can view the field on the Website Users Maintenance page for a user. Add the field to your CSV file by entering the 'CUS_' before the Field Name as a new column header. Example: for custom field 'testfield', enter it in the CSV file as 'CUS_testfield'.