Price Grids

Owned by Daryl Saunders (Unlicensed)
Last updated: Mar 27, 2020 by Alex Morrisson
6 min read

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 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 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

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 a more information about on 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 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.



How Price grids calculate

Example 1 - Height/Drop

For the first example we are ignoring width by entering 9999, anything from 0-9999 will calculate the same


the Height value in the Column A and the corresponding Price in Column B is effective for anything under the value 

Anything between 101mm to 1000mm will calculate 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 has the values for sizes, everything in pink is a possible selection 

Ie Cell E2 (101) is the minumum value and F2 (1000) is the maximum value for anything priced in Column G


Example 4

If you have a window that was 900mm wide x 2400mm deep it would fall in this 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.