This is only required where you are using BOM (Bill of Materials) where products are made up from other products within the stock.

Field Types

You can copy the section below and paste this into an excel spreadsheet to populate the columns, any additional columns shown when pasting which are not in the definition below are surplus to requirement and not needed, you can leave those or simply remove them from the spreadsheet.

SiteCode

CustomerCode

ProductCode

ProductDescription_en

ProductDescription_oth

Brand

Year

SinglesPerUnit

SingleSize

TotalSingles

Field Name	Example	Requirement	Field Type	Notes
SiteCode	XY	Mandatory	varchar(2)	The site code for where the customer record exists, when you provided the site information we would have either used your existing or provided a code for Vision.
CustomerCode	JONES01	Mandatory	varchar(12)	The unique code that you provided for the customer when it was imported, usually the code their stock records are held under.
BOMProduct	EASTERCASE	Mandatory	varchar(20)	This is the BOM Product Code
ProductCode	08071A	Mandatory	varchar(20)	This is the product that will be used in the BOM Case
ProductDescription_en	SANTA TERESA GRAND	Mandatory	varchar(50)	Product Description in English
ProductDescription_oth		Optional	varchar(50)	Product Description in language other than English
Brand		Mandatory	varchar (50)
Year		Mandatory	varchar(4)	Either NA or NV or 4 digit year
SinglesperUnit		Mandatory	int	Singles in the BOM case
SingleSize		Mandatory	decimal	Size of this individual product in litres for the single item
TotalSingles		Mandatory	int	The quantity of the underlying product within the BOM product

Import - Product Mix Components

Field Types