Overview
Price Grids are the common way of pricing in the window furnishing industry where the widths are across the top and 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 Items and then multiple Price Grids each with different Start Dates and Price Groups - 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.
Add/ Edit Price Grid Description
Click +Add to add a new Price Grid Description
Select correct Code and Description, then attach Price Grids with a Start From date. The date can be a future date so that planned price changes can be loaded prior to the change and will be activated by an order date in that period.
Prices can be imported with or with decimal places, this can be set in step 4. when importing the price grids
Import / Export 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