Pricing Scripts

Owned by Alex Morrisson
Last updated: Aug 09, 2019 by Allison Derome (Unlicensed)
3 min read

Pricing Scripts

1. Curtain Pricing by Calculating Fabric Length for Roll Fabrics

 RRP formula

  • [Number of drops] = ROUNDUP([Window width] / [Fabric Width] X (1 + [Fullness% from HEADING STYLE] / 100))
  • [Lineal Metres of Fabric] = [Number of Drops] X ROUNDUP(([Window Height] + [Finishing Addition] ) / [Pattern Repeat]) X [Pattern Repeat]
  • [RRP] = Lineal Metres of Fabric] X Sell Lineal Metre Height]

 The fabric needs to have: 

  • Pattern Repeats in millimetres. Stored on Fabric Inventory Item in Custom Var 1 (PackSize)
  • Fabric Width in millimetres. Stored on Fabric Inventory Item in Custom Var 2(PackOpt)
  • Can be railroaded? Y / N in Custom Var 3 (PackType)
  • Fabric Lineal Metre price is stored in Lineal Metre Height for the Fabric Inventory Item.

 The Heading Style (Group Option = "HEADING STYLE") Inventory Item for option selected needs to have: 

  • Fullness as percentage addition e.g. 100% = add same window width again. Stored on the Inventory Item of the particular Heading Style in the field Custom Var 1(PackSize).
  • Additional fabric for hemming / finishing in millimetres. Stored on the Inventory Item of the particular Heading Style in the field Custom Var 2(PackOpt).

 The Return Size (Group Option = "RETURN SIZE") is required as a question for the calculation.

 The Tiebacks (Group Option = "TIEBACKS") Inventory Item for option selected needs to have: 

  • Additional Fabric in millimetres e.g. 1000 = adds an extra 1 metre of fabric. Stored on the Inventory Item of the particular tiebacks in the field Custom Var 1(PackSize).

This calculation is based on the above Number of Drops which is the quantity for the calculation of price.

See our Curtain Template with Calculator for more details and easy setup. Curtain Script Calc & Quick Setup Template.xlsx

Note: Price/Cost Grids can't be used.

Scripts needed (Add these to the groups for pricing calculations, can be added to both Cost and RRP):

2. Curtain Design - Soft Roman Pricing 

RRP Formula

  • [Number of drops] = ROUNDUP([Window width] / [Fabric Width] )
  • [Lineal Metres of Fabric] = [Number of Drops] X ROUNDUP(([Window Height] + 400mm ) / [Pattern Repeat]) X [Pattern Repeat]
  • [RRP] = Lineal Metres of Fabric] X Sell Lineal Metre Height]

The fabric needs to have:

  • Fabric Width - If left blank 1000mm is used.
  • Pattern Repeats in millimeters. Stored on Fabric Inventory Item in PackSize
  • Fabric Lineal Metre price is stored in Lineal Metre Height

Note: Price/Cost Grids can't be used.

3. Blinds - Panel Glide Pricing 

RRP Formula

  • Track Width (ITEMWIDTH) / QTY = Panel Width and then use that width X ITEMHEIGHT to search Price Grid.
  • If you have a second price grid configured for the panel tracking which needs to use the total Item width configure the group options ITEMWIDTH field with the Inventory Item code for this. To have multiple prices based on different size panels add one price grid using the item depth to calculate the different pricing.

  • To configure other items on orders which are not the main item and need to use a single price. Set the QTY 

 

3. Doors - Panel Pricing 

RRP Script: 20171026.1629_Common Options - Extrusions & Profiles- Option_Script_RRP.cs

  • If you wish to do pricing by having an option where you want to put in the pieces and have BUZ add it up and calculate the price based on the total length then this script is for you.
    • e.g. user enters = 1x284 2x448 284 - Outcome = 1464 ← BUZ will price based on lineal meter.



Zebra Programming and Label Format

Zebra Printer Installation