In this Article: Show
Here is a method to qualify how a moulding is priced based on the Category field.
Tip: This is a great way to consistently price a discount line of moulding from various vendors, or add additional charges to selected moulding, or designate higher pricing for difficult to cut moulding.
Moulding may be priced by the Category - the name of which can be provided by the supplier or one you have entered, e.g. Concerto (from Larson Juhl) or Discount Line (created by you).
When using this method, all items with the same value in the Category field are given the same pricing. Formulas identifying Categories can also be added into your regular pricing formula.
Important: Make sure that the value in the Category field is an exact match to the Category used in your formula.
There are a variety of different formulas you can use. A few examples using "If" or "Case" are shown. The important thing is to specify the Category and how it is priced: by Markup or Price Per Foot.
The following formula illustrates a way to identify the Category and to price it by a Markup, e.g. Cost*6
Formula example:
If(Category = “Special Order”; Cost*6; Cost*4)
This means that all items with a Category value of Special Order are marked up 6 times, but, all other items are marked up 4 times (as indicated with Cost * 4 at the end of the formula).
You can also have different entries in the Category field to identify different Markups or a fixed price per foot, e.g. All items with Discount Line04 are $4 per foot, All items with Discount Line05 are $5 per foot.
Formula example:
Case(
Cost>0 and Category = "Discount Line04"; 4;
Cost>0 and Category = "Discount Line05"; 5
)
The same rules of Category can also be applied to the Set Price field. This can be useful to add a fixed dollar amount to the price of the frame -- but only if the Category is filled with the matching word(s). Otherwise, the Set Price is zero.
Formula example:
If(Category = “Special Order”; 15)