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: Item is sold by square metres but the minimum is 1 square metre so Sell Minimum = Price of 1 square metre. 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.

BUZ Documentation