Calculated Price Lists
The Calculated Price Lists section allows you to generate new sales price lists from an existing one by applying mathematical formulas or multipliers to the original prices. It is a useful tool for quickly creating updated versions of price lists (e.g., “resellers,” “discounted,” “export,” etc.), maintaining consistency with the main price list.
⚙️ Interface and main fields
Field | Description |
Original price list | Select the starting price list from which the prices will be taken. |
Formula | Field for entering the calculation formula (e.g., PRICE * 1.1 to increase by 10%). The ❓ button opens help with syntax examples. |
Rounding | Allows you to define the rounding rule (e.g., no rounding, €0.05, €0.10, etc.). |
New Price List Code | Enter the identification code of the new price list to be generated (e.g., LISTINO2025_NET). |
Description | Descriptive text that will appear in the price list table. |
Currency | Currency selection for the new price list (by default the same as the source price list). |
Exclusion list | Allows you to exclude specific items, combinations, or categories during the calculation. You can add one or more exclusions by clicking on Add exclusion. |
Test mode | If selected, the generation occurs in simulated mode: the system displays the result without saving the new price list in the database. |
Calculate | Start generating the new price list based on the set parameters. |
🧩 Calculation Formula
The Formula field accepts mathematical expressions that operate on the source list price. Available variables may include:
Variable | Meaning |
PRICE | Starting price (from the selected price list). |
S | Discount percentage (e.g., PRICE * (1 – S/100)). |
+, -, *, / | Standard mathematical operators. |
round(x, n) | Round the result to n decimal places. |
Examples:
• [PRICE] * 1.15 → 15% increase
• [PRICE] * 0.9 → 10% discount
🧾 Exclusion List
The Exclusion List section displays the items or codes that will be excluded from the calculation. You can:
• Add an exclusion with + Add exclusion
• Remove an exclusion from the Actions menu (⋮)
Exclusions can include:
• individual items
• product groups
• entire code families
🧠 Test Mode
By activating Test Mode, the system performs the full calculation but does not save the new price list. It is useful for verifying:
• correctness of the formula
• number of items involved
• any errors or missing exclusions
At the end of the simulation, a summary is displayed with:
• number of items processed
• total rows updated
• any exclusions applied
▶️ Step-by-step procedure
1. Select the source price list.
2. Enter the calculation formula.
3. Set any rounding.
4. Enter the code and description of the new price list.
5. Add one or more exclusions, if necessary.
6. (Optional) Activate test mode.
7. Click Calculate to generate the new price list.
⚠️ Operational Notes
• The new price list is created only if a price list with the same code does not already exist.
• Changes are irreversible: for safety, perform a backup of the source price list.
• If the calculation fails, check the syntax of the formula or the existence of the source price list.