Data interface requirements > Product master

Product master

File name master.csv
Importance Required
Description Basic product information
Criteria One record for each unique product appearing in the Stock by Location data
 

Columns

Pos Name Type Importance Description
1 Item Code Char Required Product / SKU code
2 Description Char Required Product description
3 NETSTOCK Unit of Measure Char Preferred Description of the main unit of measure to be used in NETSTOCK (must be sufficiently granular to eliminate the need for decimals)
TO ENSURE CONSISTENCY, ALL STOCK RELATED QUANTITIES IN ALL FILES MUST BE IN THIS UNIT OF MEASURE
4 Unit Volume Decimal If Applicable Base volume per unit
5 Unit Weight Decimal If Applicable Base weight per unit
6 Superseded Item Code Char If Applicable The item code of a product that this item has superseded and replaced.
The sales history of the superseded item will be used to generate a better forecast for the replacement item.
7 Superseded Item Factor Decimal If Applicable The number of units of the superseded item that are equivalent to a unit of the replacement item (most of the time the factor would be 1)
8 Not used Char Spare Currently not used.
9 Unique Identifier Char Required A unique system identifier for a product (which does not change).