WebSphere Commerce EnterpriseWebSphere Commerce Professional

Configuring the minimum number of transactions a user needs before becoming a mentor

The following setting specifies the minimum number of transactions a user must have before becoming a mentor. The sifter uses this setting if the Clickstream Engine is using that mentor set.

Procedure

  1. To configure the minimum number of transactions required as a percentage of the total number of items in the database:
    1. Stop the LikeMinds server inside the WebSphere Application Server.
    2. Use any database modification tool to enter the following SQL statement:
      
update lps_cfg set value='3%' where
name='xactionMentor.min_mentor_xactions'
    3. Start the LikeMinds server inside the WebSphere Application Server.
  2. To configure the minimum number of transactions required as an absolute value (that is, without a percentage):
    1. Stop the LikeMinds server inside the WebSphere Application Server.
    2. Use any database modification tool to enter the following SQL statement: 
      update lps_cfg set value='3' where
name='xactionMentor.min_mentor_xactions'
    3. Start the LikeMinds server inside the WebSphere Application Server.
    Use the following guidelines for setting mentor_set_name.min_mentor_ratings:
    Guidelines for Setting the Minimum Transactions
    Total Number of Items in Database Suggested Setting
    < 1000 <= 40
    1000-5000 <=100
    5000-10,000 <= 500
    10,000+ <= 1000