Pricing Coefficients
Overview
Click here to watch a video on how to configure Pricing Coefficients
Pricing Coefficients are per Inventory Item and are set by date.
These are usually used when a Price Grid is not used but can be used in combination with a Price Grid.
Pricing coefficients are driven by your inventory items. If you have options that don’t exist in your pricing coefficients sheet yet this needs to be added in your Inventory items first prior to you being able to add a price against it.
Select the Inventory group you wish to add an item to, or create a new group.
We recommend having groups as per below;
Installation options
Roller Options
Shutter Options
General Options
This way it is easily identifiable what options are for which product group and you can then have the same option for multiple products with different pricing.
You will also be able to allocate a different GL code if necessary if your groups are split into product categories.
More help can be found here for setting up inventory items.
For a more information about on price grids vs pricing coefficients click here.
Adding Pricing coefficients
In adding or editing these prices is to export the current prices. If no prices have been imported previously the list will still export the data setting up the sheet with zero prices providing a template list of current items to work with.
Download Pricing Coefficients
Go to → Settings → Inventory Settings → Pricing Coefficients → Import/Export Prices.
If no prices have been imported previously for the Inventory Item it will appear in the sheet green with zero's as your PKID pricing, providing you a template list to work with.
Like this screen shot.
If you already have pricing coefficients in BUZ ensure save a copy of the file before any changes so you have a backup of the original data.
Pricing Coefficients import/export file headings
Below are the headings when exported and used for importing.
| PkId | Inventory Code | Description | Customer_Price Group_Code | Date From | Sell Each | SellLMWide | SellLMHeight | SellLMDepth | SellSQM | SellPercentageOnMain | SellMinimum | CostEach | CostLMWide | CostLMHeight | CostLMDepth | CostSQM | CostPercentageOnMain | CostMinimum | InstallSellEach | InstallCostEach | InstallCostLMWidth | InstallCost Height | InstallCostDepth | InstallCostSQM | InstallCostPercentageOfMain | InstallCostMinimum | InstallSellMinimum | InstallPercentage | InstallSellLMWide | InstallSellSQM | InstallSellHeight | InstallSellDepth | InstallSellPercentageOfMain | PriceBreak | RollCostPerMetre | CutLengthCostPerMetre | BuyCutLengt | SupplierDiscount | IsNotCurrent | Operation |
Important Note - Operations:
- A = Add (Use this to put pricing changes in that don't effect previous sales)
- E = Edit (DO NOT USE E UNLESS YOU MEAN TO CHANGE EXISTING PRICING AND EXISTING SALES THAT USE THESE PRICES!!!)
- D = De-Activate
The columns:
| Column | Description |
|---|---|
| PkId | Unique Identifier created by system |
| Inventory Code | Identifies Inventory Item prices apply to |
| Description | Inventory Item description |
| Customer Price Group Code | Only used if Customer Price Groups used |
| Date From | The Quote Date these prices apply to quotes dated this date and up to the next Date From Price Coefficients for the Item. *** Dates through out BUZ are critical DON'T just use today's date it is usually not the best choice! Call BUZ support if not sure BEFORE importing the sheet. |
| Sell Each | Sell Price per item (each) |
| Sell LM Wide | Sell Price per metre for the ItemWidth value (see Group Options) entered for the item. |
| Sell LM Height | Sell Price per metre for the ItemHeight value (see Group Options) entered for the item. |
| Sell LM Depth | Sell Price per metre for the ItemDepth value (see Group Options) entered for the item. |
| Sell SQM | Sell Price per square metre (ItemWidth x ItemHeight) |
| Sell Percentage On Main | Percentage surcharge calculated using the price of the main item. Can be part of the calculation of the price of the main product in which case it is applied as the last step of the price calculation. Examples: 1. A blind price is retrieved from a price grid but the fabric selected sells for 20% more than the base fabric which is the price returned by the price grid. 2. Applying a 10% discount to the price. (Ensure your Sell minimum is set) |
| Sell Minimum | This is the minimum sell price to use if the calculated price is less then this. Example:
2. To ensure a negative number (10% discount) can be taken away from the total, you need to set the sell minimum to ensure it calculates ($-10000.00). To add components with Minimum Sell price click here: Adding Minimum Order Value to Components |
| Cost....... | Theses prices are the same as the equivalent Sell columns but are used to calculate the item cost. |
| Install Sell | Theses prices are the same as the equivalent Sell columns but are used to calculate the item's Installation Sell price. This is added to the item Sell Price if a delivery product is NOT included in the quote/ order. That is, installation is included by default. |
| Install Cost | Theses prices are the same as the equivalent Sell columns but are used to calculate the item Installation cost. If the installer/Delivery is a contractor this is what is paid to the contractor. |
| Other columns | The remaining fields are for additional functionality planned for BUZ. |
| IsNotCurrent | Set to true to De-activate the prices. |
| Operation | Row is ignored if left blank. Refer to Important Note - Operations above for available values. |
Editing an existing pricing coefficient
This process will override all existing pricing in the system from the date which is in the "Date From" column. If you want to change the price for any current orders/sales within the system use this editing (E) function.
In the below example we are updating any orders/sales from 20/2/2019 for the Inventory item OPRL60 to cost $120 instead of $100. When you import this updated cost all quotes in BUZ from the 20/2/19 will be updated to use the new charge of $120.
Deactivating pricing coefficients
No pricing is deleted from BUZ, you only deactivate the items so if you need to re activate them you can by clicking "include inactive items" when exporting your pricing coefficients.
Import updated Pricing coefficients file
Save a new copy of the updated file and import.
Settings → Inventory Settings → Pricing Coefficients → Export/Import Prices
Select the sheets to be uploaded → Import
Pricing Coefficients for multiple customer groups
To add pricing coefficients for multiple customer groups you can use the “Customer Price Group Code” Column. The price group code can be found under Settings → Sales settings → Price groups
In the “Customer Price Group Code” column you insert the customer price group code (as per below)
Multiple group codes can be added here allocating the different pricing for that inventory code per group
Adding Pricing coefficients to group options
For the pricing coefficients to add to your sell price ensure you have added the Inventory item code to your group options layout. Help for group options can be found here.
Eg: OPRL60
Now check any pricing change made on your quotes/sales.
Applying a Sell Percentage On Main Discount.
Example : How to apply a 10% discount for an Inventory Item already include in a price, to ensure the negative value is taken from the pricing total, the sell minimum needs to be set to a negative value otherwise it will calculate the negative value but will default to taking away zero value.
- Import/export function
2. In BUZ
Important Notes
A = Add (Use this to put pricing changes in that don't effect previous sales)
E = Edit. If you EDIT an existing pricing coefficient and back date this all EXISTING QUOTES will be updated with the new pricing.
