Price Formula (EC)

Price Formula lets you assign price formulas and rounding rules to new products as they are imported through RFMS E-Commerce (EC). These formulas are applied only when a product is first imported. They do not replace or update formulas on existing products, which helps you avoid unintended pricing changes when supplier catalogs update. If you need to adjust pricing on existing products, do that in the Products module using Price Range Edit.

Why Setting this up Matters

Setting up price formulas in E-Commerce helps standardize pricing for imported products so users do not have to apply formulas manually after each import. Because E-Commerce applies formulas only to new products, you can keep long-standing product pricing intact while still ensuring newly imported items follow your current pricing rules.

How is this Different from Price Range Edit?

Price formulas in E-Commerce work similarly to formulas set in the Products module, with these limitations:

Limitation	What it means for you
Line commission is not editable	If you use line commissions, you may need to run formulas in Products > Price Range Edit after importing.
Formulas cannot reference previous formulas	You cannot use placeholders like P1/P2 to build formulas based on earlier formulas.
Cost-based formulas used in Price Range Edit are not available	Build formulas using the fields available in the E-Commerce formula legend.

Add Price Formulas for New Products

1. Go to E-Commerce > Utilities > Setup > Price Formula.
2. In the top left of the screen, select the Product Type, Product Code(s), and Supplier(s) the formulas should apply to.
3. Choose the rounding option you want applied from the rounding section.
4. Enter formulas, up to 12. Manually enter formulas though be sure to use the proper abbreviations as shown in the legend below the formula area.
5. Click Apply Formulas.
6. Review the results at the bottom of the screen.

 Tips:

• If you've performed a search in the bottom screen area it may be necessary to click the reset, , button to view your latest updates.
• If a formula is invalid, it will display with a red X after you click Apply Formulas. Correct or remove it. Invalid formulas are not used.

Change , Delete, or Copy Existing Formulas

Before you make changes, pull up the formulas you want to work with:

1. Use the filters at the bottom of the screen to select a Supplier and/or Product Code.

2. Click Display To Setup to load the current formulas into the setup area.

Change Formulas

1. Select the Product Type, Product Code(s), and Supplier(s) you want to update.
2. Edit the formula grid as needed.
3. Click Apply Formulas.
4. Reset, , or adjust the bottom filters to review the results.

Delete Formulas

1. Select the Product Type, Product Code(s), and Supplier(s) you want to remove formulas from.
2. Clear the formula fields you want to remove.
3. Select Remove formulas if input is blank.
4. Click Apply Formulas.
5. Reset or adjust the bottom filters to review the results.

Copy Formulas

1. Display the existing formulas by filtering section at the bottom of the screen.
2. Select the Product Type, Product Code(s), and Supplier(s) that should receive the formulas currently shown in the setup area.
3. Click Apply Formulas.
4. Reset or adjust the bottom filters to review the results.