|
|
Field: User_Points
|
Type
|
Number
|
General Description
|
User can use points to buy products in the web shop. It is possible to insert and withdraw points to users’ accounts using the import feature.
|
Import Group
|
Import points information
|
Business Rules
|
- The points of users can only be deducted or inserted. It is not possible to change the total points amount of a user by importing a new total. To get a new total you must know the current total and insert or withdraw the amount necessary to achieve the new desired total.
- To withdraw points using import you must state a negative number in this column. To insert points using import you must state a positive number in this column.
- Generally you just want to insert points for existing users, since they earned these points through processes external to the system (this could be users who answered a questionnaire in another system). In this case you will put a positive amount in this column (means insertion of points) and make sure each user has a user_id specified.
- To update this field for existing users, you must select a User_Id column in step 1 of the import wizard and the value of this column will be used to determine which user’s record to update.
|
Validation
|
- Points must be integer, either positive or negative, otherwise, an error message will be shown to inform user that an error has occurred. Error type: ERROR (the import job will not be allowed to be executed).
|
Notes
|
- Please refer to points timestamp and points description to know how to import more information on the points you insert or withdraw from users.
|