Group Options - Materials and Independent Components

Purpose

On this page I will show you how to set up a product that has a Component (Inventory item) that is independent from the Material/Fabric dimensions.

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 - Once the Material and its values have been completed, then the Component it the required value will be calculated

These Values will not affect				This value
Fabric	width	Height	Drop	Component	width
Fabric	width	Height	Drop	Component	Height
Fabric	width	Height	Drop	Component	Drop

Setup

The table below has a component (Inventory item) listed in Column E, that requires its own value for the width which is listed in Column F, we also want the component (Inventory item) in Column E to not be affected by the values entered into Columns B, C or D.

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) to the Component (Column E) to do this enter the Heading of the Component into the width Column in row 3 (Highlighted in Blue)

This is because column E is where the Inventory Item is selectable,

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 to be entered, Column F row 4 I have specified this by entering in the BUZ Keyword for width “ITEMWIDTH”

	A	B	C	D	E	F
1	Test 2 16/11/2020 \| Unique Option Name	ITEMWIDTH	ITEMHEIGHT	ITEMDEPTH	COMPHEADING	COMPWIDTH
2	Inventory Code for Pricing
3	Value applies to Price from Related Option Name					COMPHEADING
4	Related Column Data Field					ITEMWIDTH
5	Related Column is Add (Y) to else Set to (N)
6	Look Back @ BUZ Column Name
7	Question Heading	Width	Drop	Depth	Product that will be seletected	Width of component
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		Product 1\|INVPG25
18	Answers from here down	5000	5000		Product 2\|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)		Product3\|INVCOSLMW10
20		1	1
21		11000	11000
22		Range must be within 1-11000	Range must be within 1-11000

Setup is for Height


1	Test 2 16/11/2020 \| Unique Option Name	ITEMWIDTH	ITEMHEIGHT	ITEMDEPTH	COMPHEADING	COMPHEIGHT
2	Inventory Code for Pricing
3	Value applies to Price from Related Option Name					COMPHEADING
4	Related Column Data Field					ITEMHEIGHT
5	Related Column is Add (Y) to else Set to (N)
6	Look Back @ BUZ Column Name
7	Question Heading	Width	Drop	Depth	Product that will be seletected	Height of component
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		Product 1\|INVPG25
18	Answers from here down	5000	5000		Product 2\|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)		Product3\|INVCOSLMW10
20		1	1
21		11000	11000
22		Range must be within 1-11000	Range must be within 1-11000

Setup is for Depth

	A	B	C	D	E	F
1	Test 2 16/11/2020 \| Unique Option Name	ITEMWIDTH	ITEMHEIGHT	ITEMDEPTH	COMPHEADING	COMPDEPTH
2	Inventory Code for Pricing
3	Value applies to Price from Related Option Name					COMPHEADING
4	Related Column Data Field					ITEMDEPTH
5	Related Column is Add (Y) to else Set to (N)
6	Look Back @ BUZ Column Name
7	Question Heading	Width	Drop	Depth	Product that will be seletected	Depth of component
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
16	Picture URL
17	Answers from here down	1000	1000		Product 1\|INVPG25
18	Answers from here down	5000	5000		Product 2\|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)		Product3\|INVCOSLMW10
20		1	1
21		11000	11000

Setup is for Quantity

Note, if you have a QTY Column for the product and a QTY for component Column these will multiply

	A	B	C	D	E	F
1	Test 2 16/11/2020 \| Unique Option Name	ITEMWIDTH	ITEMHEIGHT	ITEMDEPTH	COMPHEADING	COMPQTYV
2	Inventory Code for Pricing
3	Value applies to Price from Related Option Name					COMPHEADING
4	Related Column Data Field					QTY
5	Related Column is Add (Y) to else Set to (N)
6	Look Back @ BUZ Column Name
7	Question Heading	Width	Drop	Depth	Product that will be seletected	QTY of components
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
16	Picture URL
17	Answers from here down	1000	1000
18	Answers from here down	5000	5000		Product 1\|INVPG25
19	Answers from here down	This size is not recommended & Warranty will not apply! (1000 to 5800 )	This Height not recommended! (1000 to 3500)		Product 2\|INVCOSLMW1
20		1	1		Product3\|INVCOSLMW10
21		11000	11000
22		Range must be within 1-11000	Range must be within 1-11000

Unknown value shows up for the component

You may notice that the size includes the height of the fabric, this shouldn’t affect the price if you have setup the price grid/pricing co-efficient correctly

unfortunately the system is designed to include this, there are other scenarios where you may need this information,

If you only want the entered value to show there is a trick that you can do which will remove the other value, in this scenario I want to remove the Height..

So I have added another question which will set the height to zero, the question does not need to have a numerical value, the example below is a List with a Yes/No question.

We just need these 2 values in a question somewhere after the Width, it doesnt need to be the next question it could be 3 or 4 column later, it just needs to have the HEADING and Data Field (ITEMHEIGHT for this example)

Test 2 3/12/2020 \| Unique Option Name	ITEMWIDTH	ITEMHEIGHT	ITEMDEPTH	COMPWIDTH	COMPWIDTHV	COMPHEIGHT
Inventory Code for Pricing
Value applies to Price from Related Option Name					COMPWIDTH	COMPWIDTH
Related Column Data Field					ITEMWIDTH	ITEMHEIGHT
Related Column is Add (Y) to else Set to (N)
Look Back @ BUZ Column Name
Question Heading	Width	Drop	Depth	Product that will be seletected	Width of component	Unrelated Question
Option Type	R	R	&	L	&	L
Is Required	Y	Y
Can Mass Update
Clear value when Copied to new item
Is Not for Online Wholesale Ordering
Is Not for Shopping Cart Ordering
Use First valid Answer as default
Help Message				PG 100-5000
Picture URL
Answers from here down	1000	1000		Price Grid\|INVPG25		Yes
Answers from here down	5000	5000		Pricing Coefficient\|INVCOSLMW1		No
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
	1	1
	11000	11000
	Range must be within 1-11000	Range must be within 1-11000

BUZ Documentation