Overview
Price Grids are the common way of pricing in the window furnishing industry where the widths are across the top, height/ drop down the left and the size co-ordinates give the price. BUZ supports a third dimension Depth and this is in the right most column. Each Price Grid has a Code and Description (Price Grid Description) that are used to attach it to the appropriate Inventory Item/Items, then multiple Price Grids each with different Start Dates and different Price Groups per Customer if this option is used.
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. They 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 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
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
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 / Cost increase before it happens and BUZ will automatically change to your new prices / costs 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
Export our template for example- 20160222_InventoryPriceGrids_BUZ_Testing.xlsm