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 where a specified height, width and drop determine a price for a product.
Generally items that do not have a price per meter or calculate in a lineal state, will use a price grid.
Before setting up a Price grid you will need to create a Reference Price Grid Name (reference) in BUZ,
The reference will contain the Code and Description of the grid grid.
This Code will be added to an inventory item connect inventory items (Fabric, Component and or Service) to the price grid.
Keep the code simple but also enough not too simple something that you remember what it refers to
Breakdown of a grid
There are 7 different Area's 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
| Gliffy | ||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
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 (coming soon)
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 a more information about on pricing in BUZ click here.
| Table of Contents | ||
|---|---|---|
|
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 that each have a different Start date.
BUZ allows 3 dimensional pricing Width/Length x Height/Drop x Depth/Thickness, they 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 not available so it may be necessary to add width and drop 1 less than the minimum with 0.00 price to stop orders 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 what is setup as the tax rate for you 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 get ready 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 what is setup as the tax rate for you inventory group/inventory items. Check the tax rate before updating pricing.
- Price can be imported with or with 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 not available 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, Decimal's will not work in the blue area's.