...
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 in BUZ,
The reference will contain the Code and Description of the grid
This Code will be added to an inventory item (Fabric, Component and or Service)
Keep the code simple but also enough 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
...
Adding a New Price Grid
Step 1 → Price Grid Description/code
...
.
...
Go to Settings → Inventory settings → Price Grids → +New Grid (button)
Enter your price grid description and code → Save
...
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
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
- 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.
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.
...
Export our template for example- 20160222_InventoryPriceGrids_BUZ_Testing.xlsm
...