...
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.
...
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
...
Price Grid → Step 3
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.
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.
...