Set up your Set Price

Main Menu > Price Codes

Here is a way to save time and shorten your list of pricing formulas by covering several charge options per Supplier, without creating a new default pricing formula for each one.

  • Advantages:

    • Shorten the number of default formulas in your Pricing Options & Defaults list.

    • Spend less time making repetitious changes for suppliers with identical markup formulas but different shipping charges.

    • Save time by applying one formula, instead of applying the generic formula first and then the supplier specific formulas after.

  • Framers who have the same Markup for suppliers, but different shipping costs or labor charges, can take advantage of this combined formula.

  • This option would only be used if the Markup formula is the same for each supplier and only the Set Price is different.

  • See also: What is Set Price?

How to Set a Supplier-based Set Price

In FrameReady, the default formula for Set Price (for moulding) looks like this:

 Case( 
 Group = “Fillet”; 7.5; 
 5) 

This above formula reads as follows:

  • Any moulding record, with a Group of Fillet, has a Set Price of $7.50.

  • If the Group is Wood, Liner, etc. (anything other than Fillet), then the Set Price is $5.00.

Adding in a Supplier-based condition

Below is an example of how you can add a supplier/shipping charges to the Set Price formula:

This formula reads as follows:

  • It evaluates the Group first:

    • If the Group is Fillet, then it adds $7.50.

    • If it is anything other than a fillet, then it adds $5.

  • Then it evaluates the Supplier field:

    • If the supplier is Bella, then it adds another $5.

    • If the supplier is Decor, then it adds another $2.

    • If the supplier is Roma Moulding, then it adds another $15.

  • This means that a fillet from Bella has a Set Price of $7.50 + $5 = $12.50.

  • A wood from Roma has a Set Price of $5 + $15 = $20.00.

Note: These numbers are not representative of any company nor are they suggested. You need to determine what your own shipping costs are and then use those numbers.

Invest in your business

If you add one dollar to the sale of every frame, you will have enough money at the end of the year to: buy new equipment, upgrade your computer or software, take training, go to a trade show, buy a new store sign, etc.

 

© 2023 Adatasol, Inc.