Attaching variant data

If you want to load variants, an item must exist in your database containing all the variant options. For the next example, the item revision (v_item/A) has the following options.

Remark	Option	Value1	Value2	Value3	Value4
Motor Engine	Engine	V8	V10	V12
Transmission	TRN	THX4	TCX7	TJS8	TDT9
Air Conditioning System	AC	Y	N
Entertainment System	E_TAPE	Y	N
	E_CD	Y	N
	E_NAVI	Y	N

The variant item revision is specified in the Variants column in the Header2 row as shown in the following example.

Header1	Item	Item	Variants
Header2	Process	OP	v_item/A
Header3	Process	OP
Title	Root	Sub	Variant Definitions
	Proc_Root
		Comp1
		Comp2	AC==N
		Comp3	AC==Y AND E_NAVI==Y
		Comp4
		Comp5	Engine==V8 OR Engine==V10
		Comp6	Engine==V10 AND (TRN==TCX7 OR TRN==TJS8)
		Comp7	(Engine==V12 OR TRN==THX4) AND (AC==Y AND (E_TAPE==Y OR E_CD==Y))
		Comp8	Engine==V8 OR TRN==TJS8 OR AC==Y OR E_NAVI==Y

Importing this sheet results in the following structure.