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.
Adding a New Price Grid
Price Grid Description/code → Step 1
You need to create the code and description for the price grid.
Go to Settings → Inventory settings → Price Grids → +New Grid (button)
Enter you 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
Price Grid Template → Step 2
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
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