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

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 ...

    • 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 ...

    • 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 ...

    • QuickBooks Set-up Guide

      QuickBooks – Orchid POS Information and Setup Orchid POS supports importing accounting information to QuickBooks (desktop version only). Below is some basic information about how the two programs work together and instructions. We highly recommend ...

    • Put Products on Sale, Set a Discount, Create a Buy One Get One (BOGO)

      The Manage Products page provides several bulk action options for putting your products on sale or setting temporary discount pricing or promotional pricing. You can use any combination of search filters to find the products you need to work with. ...