|
<< Click to Display Table of Contents >> IVPCC Import Product Code Changes |
  
|
IVPCC Import Product Code Changes
|
<< Click to Display Table of Contents >> IVPCC Import Product Code Changes |
|
Product item product code changes can be applied from a prepared text file.
File layout:
Col |
Name |
Attributes |
Notes |
1 |
ProductCode |
A30 |
Optional, BUT either a productcode or stocknbr is required
|
2 |
StockNb |
N8 |
Optional, BUT either a productcode or stocknbr is required
|
3 |
NewProductCode |
A30
|
|
4 |
Updated? |
Y/N |
Is updated to Y when the product code is updated |
The file to be a comma delimited (.csv) file.
The ProductCode or StockNbr is validated against the product masterfile. If there is no match the input will be included in an error report.
If the NewProductCode does not pass the 'change product code validation' rules the line item will be included in an error report.
Line items with no errors will update the product code following the same logic as if the product code was changed via the Product master screen.