...
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
| 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
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.
| 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
...
, 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.
Adding a New Price Grid
Step 1 → Price Grid Description/code
You need to create the code and description for the price grid.
Go to Settings → Inventory settings → Price Grids → +New Grid (button)
Enter your price grid description and code → Save
OR you can create multiple price grids at once using excel (import/export feature)
Go to Settings → Inventory Settings → Import Export Inventory Settings
→ Download Current Layouts
→ Select Price Grid Descriptions and Export
→ Enter your Code for the Price Grid in the Column headed Code IE: ROLL-7
→ Enter the Description of the Price Grid in the column headed Description IE: Rollers Category 7
→ Enter an A in the column headed Operation (to add)
→ Once done Save a copy of the file then Import
Go to Settings→ Inventory settings→ Import Export Inventory settings → Select file
→ Upload
→ Select the spreadsheets to upload → Import
When successful a message will appear at the bottom of the screen
Step 2 → Price Grid Template
Once the Price Grid code/description has been created download your Price Grid template.
Settings → Inventory Settings → Price Grids → Import/Export Prices
Download current layouts
.
Select the required Price Grid → Export
Step 3 → Price Grid
Add your pricing to your Price Grid
Note: Importing pricing "Inc" or "Exc" GST depends on
...
the tax rate
...
- Width/Length → Across x
- Height/Drop → Down left side
- Depth/Thickness → Down very right column
Save and import your file
Settings → Inventory Settings → Price Grids → Import/Export Prices → Select File
Upload
Select the required Price Grids to be imported
Select the date you required the Price Grid to start from (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)
Select how many decimals places to round the cost to → Import
When the Import button is used you will receive a Save Successful message.
Step 4 → Price Grid Link to Inventory Item
Download your Inventory Items and add the required Price Grid Code to Inventory Items excel file and import as per the Inventory Items help
Example of Price Grids
It is important that the right most column be the Depth. If depth is not being used then 0 (zero) should be entered on each row. See example below.
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.
...
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
...
Export our template for example- 20160222_InventoryPriceGrids_BUZ_Testing.xlsm
...
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.
