Group Options - Materials and Independent Components part 2

On this page we will creating a component that has 2 requirements which have not relation to the Material/Fabric

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

Example

The Values in Yellow will not affect the values in Blue, Below are 2 examples that I will do, 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

Purpose

The table below has a component 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 let inform BUZ that we are not using the standard headings (ITEMWIDTH, ITEMHEIGHT, ITEMDEPTH) to determine the Width, Height or Drop

Setup

I have created a heading in Column E - COMPWH, (you can rename this for your products it is not a defined name)

Next I need to refer to this Heading in row 3 of columns F & G, I have entered COMPWH

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 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	COMPWH	COMPWIDTH	COMPHEIGHT
2	Inventory Code for Pricing
3	Value applies to Price from Related Option Name					COMPWH	COMPWH
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	COMPHEIGHT	COMPHEIGHT	COMPHEIGHTVV	COMPHEIGHT2VV
2	Inventory Code for Pricing
3	Value applies to Price from Related Option Name					COMPHEIGHT	COMPHEIGHT	COMPHEIGHT
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