Example of Price Grids

When setting up a Price Grid there are many different options available to you,

This page will show you a few examples but you are not necessarily limited to the examples shown.

Let support know if you have another idea and we will add it to the page

Height, Width - Small values

20. Standard Table - Small values , Date From 01/12/2020, Active: True						Price Grid
	1	5	10	15	20	50	[DEPTH]
1	0.1	0.5	1	1.5	2	5	0
10	0.2	2	4	6	8	10	0
20	2	20	40	60	80	100	0
30	4	40	80	120	160	200	0
40	6	60	120	180	240	300	0
50	8	80	160	240	320	400	0

Height, Width - Large values

21. Standard Table - Normal values , Date From 01/12/2020, Active: True						Price Grid
	100	1000	2000	3000	4000	5000	[DEPTH]
100	2	20	40	60	80	100	0
1000	20	200	400	600	800	1000	0
2000	40	400	800	1200	1600	2000	0
3000	60	600	1200	1800	2400	3000	0
4000	80	800	1600	2400	3200	4000	0
5000	100	1000	2000	3000	4000	5000	0

Height, Width - Restricted cells

22. Standard Values - Restrictions , Date From 01/12/2020, Active: True						Price Grid
	100	1000	2000	3000	4000	5000	[DEPTH]
100	0	20	40	60	80	100	0
1000	20	200	400	600	800	1000	0
2000	40	400	800	1200	1600	2000	0
3000	60	600	1200	1800	2400	0	0
4000	80	800	1600	2400	0	0	0
5000	100	1000	2000	0	0	0	0

Height, Width, Depth - small values

23. Standard Values + Depth (S 1-10) , Date From 01/12/2020, Active: True						Price Grid
	100	1000	2000	3000	4000	5000	[DEPTH]
100	2	20	40	60	80	100	0
1000	20	200	400	600	800	1000	0
2000	40	400	800	1200	1600	2000	0
3000	60	600	1200	1800	2400	3000	0
4000	80	800	1600	2400	3200	4000	0
5000	100	1000	2000	3000	4000	5000	0
100	3	21	41	61	81	101	1
1000	21	201	401	601	801	1001	1
2000	41	401	801	1201	1601	2001	1
3000	61	601	1201	1801	2401	3001	1
4000	81	801	1601	2401	3201	4001	1
5000	101	1001	2001	3001	4001	5001	1
100	4	22	42	62	82	102	2
1000	22	202	402	602	802	1002	2
2000	42	402	802	1202	1602	2002	2
3000	62	602	1202	1802	2402	3002	2
4000	82	802	1602	2402	3202	4002	2
5000	102	1002	2002	3002	4002	5002	2

Height, Width, Depth - Large values

24. Standard Values + Depth (N 1-5000) , Date From 01/12/2020, Active: True						Price Grid
	100	1000	2000	3000	4000	5000	[DEPTH]
100	2	20	40	60	80	100	0
1000	20	200	400	600	800	1000	0
2000	40	400	800	1200	1600	2000	0
3000	60	600	1200	1800	2400	3000	0
4000	80	800	1600	2400	3200	4000	0
5000	100	1000	2000	3000	4000	5000	0
100	3	21	41	61	81	101	1000
1000	21	201	401	601	801	1001	1000
2000	41	401	801	1201	1601	2001	1000
3000	61	601	1201	1801	2401	3001	1000
4000	81	801	1601	2401	3201	4001	1000
5000	101	1001	2001	3001	4001	5001	1000
100	4	22	42	62	82	102	2000
1000	22	202	402	602	802	1002	2000
2000	42	402	802	1202	1602	2002	2000
3000	62	602	1202	1802	2402	3002	2000
4000	82	802	1602	2402	3202	4002	2000
5000	102	1002	2002	3002	4002	5002	2000

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

Width Depth (Small values) - possibly for various tracks

26. Width. No Height. Depth (1-10) , Date From 01/12/2020, Active: True						Price Grid
	100	1000	2000	3000	4000	5000	[DEPTH]
9999	100	1000	2000	3000	4000	5000	0
9999	101	1001	2001	3001	4001	5001	1
9999	102	1002	2002	3002	4002	5002	2
9999	103	1003	2003	3003	4003	5003	3
9999	104	1004	2004	3004	4004	5004	4
9999	105	1005	2005	3005	4005	5005	5

Width Depth (Large values)

27. Width. No Height. Depth (0-1000) , Date From 01/12/2020, Active: True						Price Grid
	100	1000	2000	3000	4000	5000	[DEPTH]
9999	100	1000	2000	3000	4000	5000	0
9999	101	1001	2001	3001	4001	5001	1000
9999	102	1002	2002	3002	4002	5002	2000
9999	103	1003	2003	3003	4003	5003	3000
9999	104	1004	2004	3004	4004	5004	4000
9999	105	1005	2005	3005	4005	5005	5000

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 Depth (Small values)

29. Height. No Width. Depth (1-10) , 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
100	101	1
1000	1001	1
2000	2001	1
3000	3001	1
4000	4001	1
5000	5001	1
100	102	2
1000	1002	2
2000	2002	2
3000	3002	2
4000	4002	2
5000	5002	2

Height and Depth (Large values)

30. Height. No Width. Depth (0-1000) , 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
100	101	1000
1000	1001	1000
2000	2001	1000
3000	3001	1000
4000	4001	1000
5000	5001	1000
100	102	2000
1000	1002	2000
2000	2002	2000
3000	3002	2000
4000	4002	2000
5000	5002	2000

Height and Width are not factors, only depth

31. No Width or Height. Depth (1-10) , Date From 01/12/2020, Active: True	Price Grid
	9999	[DEPTH]
9999	1	0
9999	10	1
9999	20	2
9999	30	3
9999	40	4

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

Set restrictions - price will not increase

33. No Width or Height. Depth (0-1) , Date From 01/12/2020, Active: True						Price Grid
	999	1000	2000	3000	4000	5000	[DEPTH]
999	0	0	0	0	0	0	0
1000	0	0.01	0.01	0.01	0.01	0	0
2000	0	0.01	0.01	0.01	0.01	0	0
3000	0	0.01	0.01	0.01	0.01	0	0
4000	0	0.01	0.01	0.01	0.01	0	0
5000	0	0	0	0	0	0	0

NB: if you have multiple Customer Price Groups they will each have their own Price Grids in the Export and Import. Each Grid must start and finish on the same Column. They can be longer than each other but they must be the same width.

Note: Importing pricing "Inc" or "Exc" GST depends on what is setup as the tax rate for you inventory group/inventory items check the tax rate before updating pricing

where the widths are across the top, height/ drop down the left and the size co-ordinates give the price. BUZ supports a third dimension Depth and this is in the right most column. Each Price Grid has a Code and Description (Price Grid Description) that are used to attach it to the appropriate Inventory Item/Items, then there can also be multiple Price Grids each with different Start Dates and different Price Groups per Customer if this option is used.

You can also utilise the "Zero" value to restrict a size of a product - Click here for a quick example (coming soon)

BUZ Documentation

Example of Price Grids

Height, Width - Small values

Height, Width - Large values

Height, Width - Restricted cells

Height, Width, Depth - small values

Height, Width, Depth - Large values

Width only - possibly for tracks and/or base rails

Width Depth (Small values) - possibly for various tracks

Width Depth (Large values)

Height Only - possibly for side rails, posts or chains

Height and Depth (Small values)

Height and Depth (Large values)

Height and Width are not factors, only depth

Height and Width are not factors, only depth

Related content