Group Options - Materials and Components using the same values

Purpose

On this page will explain how to set up a product that has a Component (Inventory item) that will use a value from the Material/Fabric dimensions.

This setup has little to do with the Group options, it will show you the order that you need to input the questions but the main consideration is setting up the correct pricing.

Design

The Component will use a HEADING to use to calculate a price, but will not be affected by any of the other values in Yellow,

Fabric	Width	Height	Drop	Component
Fabric	Width	Height	Drop	Component
Fabric	Width	Height	Drop	Component

Setup

The component (Inventory item) in Column E to use one of the main values from the Fabric entered into Columns B, C or D.

To make this happen we need to add the pricing matrix so that the system can use the values to calculate a price as you intend

This table setup is pretty simple and does not require too much extra information. The material will be selected first (not show on this page), after that we determine the Width, Height and Depth, this can be done in any order. Once these values have been set the component (Column E) can be selected and will calculate from the values set before it.

NOTE: If you put the component before the Material values you will not get a price.

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

Price grid / pricing Co-efficients

You will need to select a pricing method, if the price is linear setting up a pricing Co-efficient might be the easiest option.

Alternatively the inventory item may require a limit or be priced in a way that is not linear, if that is the case then a price grid will be required.

Price Grid Examples

Width only - possibly for tracks and/or base rails

25. Width. No Height , Date From 01/12/2020, Active: True						Price Grid
	100	1000	2000	3000	4000	5000	[DEPTH]
9999	100	1000	2000	3000	4000	5000	0

Height Only - possibly for side rails, posts or chains

28. Height. No Width , Date From 01/12/2020, Active: True	Price Grid
	9999	[DEPTH]
100	100	0
1000	1000	0
2000	2000	0
3000	3000	0
4000	4000	0
5000	5000	0

Height and Width are not factors, only depth

32. No Width or Height. Depth (0-1000) , Date From 01/12/2020, Active: True	Price Grid
	9999	[DEPTH]
9999	1	0
9999	10	1000
9999	20	2000
9999	30	3000
9999	40	4000

Click here for more examples on Price grid setups