View source for Field: Discount Id

{{Help_Files_Import_module}} 

== Field: Discount_Id  ==

{| width="1189" cellspacing="0" cellpadding="2" border="0" style="border-collapse:collapse" class="tableintopic"
|-
| width="168" height="0" | 
| width="1020" height="0" | 
|- valign="top" align="left"
| width="1189" colspan="2" style="border:1px solid #010101;" | 
== Field: Discount_Id  ==

|- valign="top" align="left"
| width="168" style="border:1px solid #010101;" | 
Type 

| width="1021" style="border:1px solid #010101;" | 
Integer (FK) 

|- valign="top" align="left"
| width="168" style="border:1px solid #010101;" | 
General Description 

| width="1021" style="border:1px solid #010101;" | 
Discount_Id is used to specify discount systems that preferred users in the system will receive when shopping in Catglobe’s web shop. 

|- valign="top" align="left"
| width="168" style="border:1px solid #010101;" | 
Import Group 

| width="1021" style="border:1px solid #010101;" | 
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.<br>[[Image: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!

&nbsp; 

|- valign="top" align="left"
| width="168" style="border:1px solid #010101;" | 
Business Rules 

| width="1021" style="border:1px solid #010101;" | 
*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.<br>[[Image:674.gif]]<br>
*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!

&nbsp; 

|- valign="top" align="left"
| width="168" style="border:1px solid #010101;" | 
Validation 

| width="1021" style="border:1px solid #010101;" | 
*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).

|- valign="top" align="left"
| width="168" style="border:1px solid #010101;" | 
Notes 

| width="1021" style="border:1px solid #010101;" | 
N/A 

|}

[[Category:Import_module]]