| |
Field: Discount_Id |
Type | Integer (FK) |
General Description | Discount_Id is used to specify discount systems that preferred users in the system will receive when shopping in Catglobe’s web shop. |
Import Group | Discount can be imported using only number. Numbers are the unique ID on the database for discount and may differ between sites. You should contact your site administrator to know what discounts and related id’s that your site has available. The table below is therefore only an example of the discounts supported in one specific site. Other sites may use different numbers to recognize discounts.
<img width="316" vspace="0" hspace="0" height="95" border="0" align="bottom" alt="" src="672.gif"> - In case the above table was how our discount table looked for a site, we could put in ‘2’ in the excel cell and the discount of the user would be set to “Special discount”.
- To update this field for existing users, you must map the import using the User_Id column to show which users to update for. If you are updating existing users’ discounts you are forced to update all of the users in your excel. The system will recognize NULL as an acceptable value and update any mapped user to be null in this case. I.e. null does not mean that users existing discounts values will be kept but rather that they will be removed!
|
Business Rules | - The column name should be ‘Discount_Id’ in order to be mapped automatically when checking the ‘Auto Map’ function.
- Discount can be imported using only number. Numbers are the unique ID on the database for discount and may differ between sites. You should contact your site administrator to know what discounts and related id’s that your site has available. The table below is therefore only an example of the discounts supported in one specific site. Other sites may use different numbers to recognize discounts.
<img width="316" vspace="0" hspace="0" height="95" border="0" align="bottom" alt="" src="674.gif"> - In case the above table was how our discount table looked for a site, we could put in ‘2’ in the excel cell and the discount of the user would be set to “Special discount”.
- To update this field for existing users, you must map the import using the User_Id column to show which users to update for. If you are updating existing users’ discounts you are forced to update all of the users in your excel. The system will recognize NULL as an acceptable value and update any mapped user to be null in this case. I.e. null does not mean that users existing discounts values will be kept but rather that they will be removed!
|
Validation | - The number imported to discount must exist in the table ‘Discount’ of the systems database or be NULL or an error will occur. Error type: ERROR (the import job will not be allowed to be executed).
|
Notes | N/A |
