Group Options - Materials and Independent Components part 2

Purpose

On this page we will creating a Component (Inventory item) that has 2 requirements which have no relation to the Material/Fabric values

You may want a rail, track, pelmet, chain, post or something that isn't necessarily the same size as the Fabric

Design

The Values in Yellow will not affect the values in Blue, Below are 2 examples that you can see on this page, there are plenty of other setups that you can do that involve Width, Height, Depth and or QTY

These Values will not affect				These values
Fabric	width	Height	Drop	Component	Width	Height
Fabric	width	Height	Drop	Component	Height	QTY

Setup

The table below has a component (Inventory item) listed in Column E, that requires its own value for the Width and Height.

We want the component (or Inventory item) in Column E to not be affected by the values entered into Columns B, C or D and requires its own value in column F and G

To make this happen we need to inform BUZ that we are not using the standard headings (ITEMWIDTH, ITEMHEIGHT, ITEMDEPTH) to determine the Width, Height or Drop for the component.

The next step is to link the Component’s width (Column F) and the Components Height (Column G) to the Component (Column E). To do this enter the Heading of the Component into the Width & Height Column in row 3 (Highlighted in Blue)

The next thing we need to do is to tell BUZ what type of value we want, so for this first table I require a Width and Height to be entered. Column F/Row 4 I have specified this by entering in the BUZ Keyword for width “ITEMWIDTH” and for Column G/Row 4 “ITEMHEIGHT”

You can also add or substitute ITEMDEPTH, or QTY if required.

	A	B	C	D	E	F	G
1	Test 2 16/11/2020 \| Unique Option Name	ITEMWIDTH	ITEMHEIGHT	ITEMDEPTH	COMPONENT	COMPWIDTH	COMPHEIGHT
2	Inventory Code for Pricing
3	Value applies to Price from Related Option Name					COMPONENT	COMPONENT
4	Related Column Data Field					ITEMWIDTH	ITEMHEIGHT
5	Related Column is Add (Y) to else Set to (N)
6	Look Back @ BUZ Column Name
7	Question Heading	Width	Drop	Depth	Component - Width	Width	Height
8	Option Type	R	R	&	L	&	&
9	Is Required	Y	Y
10	Can Mass Update
11	Clear value when Copied to new item
12	Is Not for Online Wholesale Ordering
13	Is Not for Shopping Cart Ordering
14	Use First valid Answer as default
15	Help Message				PG 100-5000
16	Picture URL
17	Answers from here down	1000	1000		Price Grid\|INVPG25
18	Answers from here down	5000	5000		Pricing Coefficient\|INVCOSLMW1
19	Answers from here down	This size is not recommended & Warranty will not apply! (1000 to 5800 )	This Height not recommended! (1000 to 3500)		Pricing Coefficient 10\|INVCOSLMW10
20		1	1
21		11000	11000
22		Range must be within 1-11000	Range must be within 1-11000

Setup is for Height

	A	B	C	D	E	F	G	H (Optional)
1	Test 2 16/11/2020 \| Unique Option Name	ITEMWIDTH	ITEMHEIGHT	ITEMDEPTH	COMPONENT	COMPHEIGHT	COMPQTY	INSTALLATION
2	Inventory Code for Pricing
3	Value applies to Price from Related Option Name					COMPONENT	COMPONENT	COMPONENT
4	Related Column Data Field					ITEMHEIGHT	QTY	ITEMWIDTH
5	Related Column is Add (Y) to else Set to (N)
6	Look Back @ BUZ Column Name
7	Question Heading	Width	Drop	Depth	Component - Height	Height	QTY	Installation
8	Option Type	R	R	&	L	&	&	L
9	Is Required	Y	Y
10	Can Mass Update
11	Clear value when Copied to new item
12	Is Not for Online Wholesale Ordering
13	Is Not for Shopping Cart Ordering
14	Use First valid Answer as default
15	Help Message				PG 100-5000
16	Picture URL
17	Answers from here down	1000	1000		Price Grid\|INVPG28			Yes
18	Answers from here down	5000	5000		Pricing Coefficient\|INVCOSLMH1			No
19	Answers from here down	This size is not recommended & Warranty will not apply! (1000 to 5800 )	This Height not recommended! (1000 to 3500)		Pricing Coefficient 10\|INVCOSLMH10
20		1	1
21		11000	11000
22		Range must be within 1-11000	Range must be within 1-11000