Use Copy Formula to set Price Levels, Discounts, and More

Price Levels can be used to pre-set discount levels and establish pricing based on profit, cost, or other parameters. You can set relationships between the price levels called formulas. For example, Preferred Customer price level can be set to 10% below Retail, with this discount being copied across all inventory or a subset of your inventory.

They are a great way to offer default discounts to customers while retaining control and flexibility over your pricing.

Any time you use the pricing grid columns on a part’s details page to set price levels it will turn the field you used blue.

Once the field is blue, it is now a formula and can be used as a template to copy the setting to other inventory items.

Retail and MSRP formulas are percentage discount fields, and Cost (Mark Up) and Gross Margin columns are increase percentage fields.

To Copy Pricing Formulas:

1. Bring up any qualifying item under Office > Inventory > Products > Manage Products and set one or more price formulas. Save the changes to the part.

2. Then, click Copy Formula button to reach this page:

3. Set your substitute formulas. These are important to address Retail and MSRP based formulas, if any item happens to have $0 in that field.

4. MAKE SURE to click the “overwrite manually entered pricing” option at the bottom, then click Apply Formula.

5. Orchid POS will begin working; status results will post to Tools > Exports page. You will see a status bar appear; you can close the tab without affecting results.

• Related Articles

• What are Price Levels?

  Price Level Settings All parts have default price levels: Minimum Price, Retail, Sale Price, Package Price, and Preferred Customer. These price levels cannot be renamed. All parts have an additional three price levels available; their names are set ...

• How to assign specific Price Levels to a Customer Profile

  This guide will walk you through the process of creating custom price levels and how to assign them to Memberships or Customer Profiles. What are Price Levels? Price levels are included on every single product in the POS. They are different tiers of ...

• Naming Custom Price Levels

  All parts have default price levels: Minimum Price, Retail, Sale Price, Package Price, and Preferred Customer. These price levels cannot be renamed. All parts have an additional three price levels available; their names are set by each store. Go to ...

• Price Inflation for Cash Discounting

  Price Inflation for Cash Discounting Program This program, printed documentation and documents should not be used as a substitute for professional advice in specific situations. The procedures, images and examples in this document are for ...

• Setting Default Price Formulas

  Default price formulas allow you to set your preferred discount and mark up levels for any new inventory item and helps you establish your Retail price (as well as other available pricing levels). These defaults will be used if creating a single new ...