Overview
These are per Inventory Item and date.
These are usually used when a Price Grid is not used but can be used in combination with a Price Grid.
Editing the Prices
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 |
The first step in adding or editing these prices is to export the current prices. If no prices have been imported previously the list will still setup the sheet with zero prices providing a template list of current items to work with.
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. Example: 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. |
| 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. |
| 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. |