Restricting an order - Intro

BUZ has a lot of different ways to customise the way you price a product but what if you dont want to allow a particular option to be sold if the product is too small or too big. An example that come to mind would be tubes. if the product was several meters long you would want the sales person or client to select the large tube alternatively if the product was quite small then they would want the smaller option.

So how can we prevent the client from getting the wrong option.

So what do we need

Inventory Items
Price Grids

The Group Option layout

Component - Restriction 11/08/2021 \| Unique Option Name	ITEMWIDTH	ITEMHEIGHT	HEADING2
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	Type of Restriction
Option Type	R	R	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
Picture URL
Answers from here down	500	500	Will not work\|OP34
Answers from here down	3500	3500	Will work but no price\|OP35
Answers from here down	Must be between 500- 3500mm	Must be between 500- 3500mm	Will work and will have a price\|OP36

Grids

Here are my 3 price grids

This grid will not allow the order to work

This grid will allow the item to be selected but wont increase the price

This Grid has a $1 value, which will be added to the order

34. All Zeros ,		Price Grid
	500	3500	[DEPTH]
500	0	0	0
3500	0	0	0

35. Will work but no price		Price Grid
	500	3500	[DEPTH]
500	0.001	0.001	0.001
3500	0.001	0.001	0.001

36. Will work and will have a price		Price Grid
	500	3500	[DEPTH]
500	1	1	1
3500	1	1	1

These grids are only examples of values that could be used, but you wouldn’t have the grid with just one value in it,

These are some exmaples

38. Tracks or tubes less than 2500 , Date From 23/12/2021, Active: True														Price Grid
	500	750	1000	1250	1500	1750	2000	2250	2500	2501	2750	3000	3250	3500	[DEPTH]
9999	0.001	0.001	0.001	0.001	0.001	0.001	0.001	0.001	0.001	0	0	0	0	0	0

39. Tracks or tubes greater than 2500 , Date From 23/12/2021, Active: True													Price Grid
	500	750	1000	1250	1500	1750	2000	2250	2500	2501	2750	3000	3250	3500	[DEPTH]
9999	0	0	0	0	0	0	0	0	0.001	0.001	0.001	0.001	0.001	0

Or something like these

	500	1500	1750	3500	[DEPTH]
500	0.001	0.001	0	0	0
1500	0.001	0.001	0	0	0
1750	0	0	0	0	0
3500	0	0	0	0	0

	500	1500	1750	2000	2250	3500	[DEPTH]
500	0	0	0.001	0.001	0	0	0
1500	0	0	0.001	0.001	0	0	0
1750	0.001	0.001	0.001	0.001	0	0	0
2000	0.001	0.001	0.001	0.001	0	0	0
2250	0	0	0	0	0	0	0
3500	0	0	0	0	0	0	0

	500	2000	2250	2500	2750	3500	[DEPTH]
500	0	0	0.001	0.001	0	0	0
2000	0	0	0.001	0.001	0	0	0
2250	0.001	0.001	0.001	0.001	0	0	0
2500	0.001	0.001	0.001	0.001	0	0	0

	500	2500	2750	3500	[DEPTH]
500	0	0	0.001	0.001	0
2500	0	0	0.001	0.001	0
2750	0.001	0.001	0.001	0.001	0
3500	0.001	0.001	0.001	0.001	0

Or this style

	500	3500	[DEPTH]
500	0.001	0.001	0
3500	0.001	0.001	0

	500	1500	1750	3500	[DEPTH]
500	0	0	0.001	0.001	0
1500	0	0	0.001	0.001	0
1750	0.001	0.001	0.001	0.001	0
3500	0.001	0.001	0.001	0.001	0

	500	2000	2250	3500	[DEPTH]
500	0	0	0.001	0.001	0
2000	0	0	0.001	0.001	0
2250	0.001	0.001	0.001	0.001	0
3500	0.001	0.001	0.001	0.001	0

	500	2500	2750	3500	[DEPTH]
500	0	0	0.001	0.001	0
2500	0	0	0.001	0.001	0
2750	0.001	0.001	0.001	0.001	0
3500	0.001	0.001	0.001	0.001	0

BUZ Documentation

Restricting an order - Intro

Grids

These are some exmaples

Or something like these

Or this style

Related content