Price Grids
- Daryl Saunders (Unlicensed)
- Alex Morrisson
- Alana Arnold (Unlicensed)
Overview
Click here to watch a video on how to configure Price Grids.
Price Grids are one of the options for BUZ Software.
A price grid is a table on which the price of a product is determined by a specified height, width, and drop.
Generally, items that do not have a price per meter or are calculated in a lineal state will use a price grid.
Before setting up a Price grid, you will need to create a Price Grid Name (reference) in BUZ,
The reference will contain the Code and Description of the grid.
This Code will connect inventory items (Fabric, Component and or Service) to the price grid.
Keep the code simple but not too simple, something that you remember what it refers to
Breakdown of a grid
There are 7 different Areas in a price grid that you need to know about.
I will explain the yellow area for each point.
Quick reference of where a Price grid sits in a Product setup
1. Price grid Description - This group of cells will automatically populate when you download a price grid; it is a merged cell; generally I wouldn't edit this cell as it is not update-able, at least not here if you need to update the Description Click here
2. Price Grid Heading - Generally I would recommend leaving this at the end (above the Depth Column). If you add extra values in the width row, move the Price grid title to align up above the depth column.
3. Height/Drop
4. Width
5. Depth
6. Values (Dollar amounts)
Note: BUZ Software will not recognise formula's
7. Tab, contains the Price Grid code
BUZ Software will link the tab to the system when importing; if you do not have the correct code in the tab, BUZ Software will not be able to find/recognise the Price grid
For more information about pricing in BUZ, click here.
How Price Grids (Sell) are used by BUZ
The Price Grid Description's code is added to each inventory item that it applies to.
Each price grid description can have several price grids attached to it, and each has a different start date.
BUZ allows 3-dimensional pricing: Width/Length x Height/Drop x Depth/Thickness. These are referenced as ItemWidth x ItemHeight x ItemDepth and are up to and including the size shown.
A zero (0.00) price indicates that the size is unavailable, so it may be necessary to add width and drop 1 less than the minimum with 0.00 price to stop orders of that size and less. In the example below, a size of 1649 x 1500 would not be allowed, but a size of 1650 x 1500 would be $3856
ItemDepth is often used to signify a package or combination price in the Product Options; see Group Options for how this is used.
Note: Importing pricing "Inc" or "Exc" GST depends on the tax rate set for your inventory group/inventory items; check the tax rate before updating pricing.
A few things to consider/remember when setting pricing up.
Price Grids are Imported with a START date, and your prices/costs will start from the date you enter. This means that you can prepare for a Price increase before it happens, and BUZ will automatically change to your new prices on your selected date.
Importing pricing "Inc" or "Exc" GST depends on the tax rate set for your inventory group/inventory items. Check the tax rate before updating pricing.
Price can be imported with or without decimal places; this can be set in step 4 when importing the Price grids.
Having a zero (0.00) Price indicates that the size is unavailable, so it may be necessary to add width and drop 1 less than the minimum with 0.00 Price to stop orders for that size and less.
Ensure that all numbers in the Drop, Width, and Depth are whole numbers; Decimals will not work in the blue areas.
How Price grids calculate
Example 1 - Height/Drop
For the first example, we are ignoring width by entering 9999; anything from 0 to 9999 will calculate the same.
The height value in Column A and the corresponding Price in Column B are effective for anything under the value.
Anything between 101mm and 1000mm will be calculated at the 1000mm price.
The example below shows the values of each row
Anything ordered between 101mm - 1000mm will = $100
Anything ordered between 1001mm - 2000mm will = $200
Anything ordered between 2001mm - 4000mm will = $400
Anything ordered between 4001mm - 6000mm will = $600
Any orders that exceed 6000mm will not work as the value is set to Zero and will cause an error. Generally, the Group options would have a restriction set for the sizes, and the user would be prompted with an error message.
Second example - Width only
Anything ordered between 101mm - 1000mm will = $100
Anything ordered between 1001mm - 2000mm will = $200
Anything ordered between 2001mm - 4000mm will = $400
Anything ordered between 4001mm - 6000mm will = $600
Any orders that exceed 6000mm will not work as the value is set to Zero and will cause an error. Generally, the Group options would have a restriction set for the sizes, and the user would be prompted with an error message.
Example 3 - Width and Height
This one is a little more complex. Row 2 and Column A have the values for sizes; everything in pink is a possible selection.
I.e. Cell E2 (101) is the minimum value and F2 (1000) is the maximum value for anything priced in Column G
Example 4
If you have a window that is 900mm wide x 2400mm deep, it would fall in the range = $800
Zero Value
I have an option that doesn't cost anything (at a certain size), but I don't want an error.
Set the Price/Cost to 0.001 and upload with 3 decimal places.