Group Option - Example for Material Only

Purpose

This page is designed to explain the basic setup for a product and how it will calculate, we will cover the defined “Headings” and the order that they need to be in, as well as how a particular Price grid setup will calculate with the values entered.

Layout Guide

This example will involve the Material and the main Headings (Width, Drop, Depth and Quantity) only.

Material	Width	Drop
Material	Width	Drop	Depth
Material	Width	Drop	QTY
Material	Width	Drop	Depth	QTY

Standard Layout

Below is an Example of a Basic layout for a product.

To set the values for the product we are offering, we need to add a few column with the correct headings.

The headings ITEMWIDTH, ITEMHEIGHT, ITEMDEPTH and QTY are all heading Keywords.

For Width, we would enter ITEMWIDTH in the heading
Drop (or Height) = ITEMHEIGHT
Depth = ITEMDEPTH
Quantity = QTY

These Columns must contain the headings listed if you wish to use the values for a calculation, other spelling variations such as WIDTH, BLINDWIDTH, RAILWITH ITEMWIDTH2 or the like will not be recognized.

These questions can be set in any order if there are no other factors (Components, Inventory Items or installation services) but must only be entered once, if there is 2 columns with ITEMWIDTH the system will not know which one you want to use and may return an error or the wrong value.

Generic Product 02/02/2020 \| Unique Option Name	ITEMWIDTH	ITEMHEIGHT	QTY	ITEMDEPTH
Inventory Code for Pricing
Value applies to Price from Related Option Name
Related Column Data Field
Related Column is Add (Y) to else Set to (N)
Look Back @ BUZ Column Name
Question Heading	Width	Drop	Quantity	Depth
Option Type	R	R	&	&
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
Picture URL
Answers from here down	1000	1000
Answers from here down	5000	5000
Answers from here down	This size is not recommended & Warranty will not apply! (1000 to 5800 )	This Height not recommended! (1000 to 3500)
	1	1
	11000	11000
	Range must be within 1-11000	Range must be within 1-11000

Once you have added these columns to the Group Options you can use the values to calculate a price.

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

NOTE: A Price grid or Pricing Co-efficent must be connected to the Fabric/Material inventory item for a price to be calculated.

BUZ Documentation