OdooWiki OCA HUB

Product Pricelist Simulation Margin

product_pricelist_simulation_margin folder_open OCA/product-attribute open_in_new
Product License: AGPL-3

This module is designed to extend Product Module in Odoo to preview product margin depending on the different pricelists.

auto_awesome What this module does

AI-generated from the code · Odoo 16.0

Adds cost, margin and margin percentage columns to the pricelist simulation wizard, so users can preview the profitability of each pricelist before applying it.

This module extends the existing pricelist simulation wizard (from the product_pricelist_simulation module) with profitability information. When you open the simulation screen, a read-only Cost field is shown, taken from the product's or product template's cost.

In the simulation results table, the original unit price column is hidden and replaced by four new columns: - Unit Sales Price (Excl.): the price without taxes. - Unit Sales Price (Incl.): the price with taxes. - Margin: the difference between the tax-excluded price and the cost. - Margin (%): the margin expressed as a percentage of the tax-excluded price.

The same four columns also appear in the detailed line form of the simulation.

Behind the scenes, the module recalculates these values for every pricelist line: it applies the product's taxes to the simulated price, converts the product cost into the pricelist currency using the company currency and the simulation date, and then computes the margin and margin percentage. The cost is refreshed from the selected product or template each time the simulation lines are prepared.

No new menus are added; everything appears inside the existing pricelist simulation wizard. The module touches the wizard.preview.pricelist and wizard.preview.pricelist.line models.

Depends on

product_pricelist_simulation
Models and fields (2)
  • wizard.preview.pricelist · extends an existing modelstandard_price (Cost)
  • wizard.preview.pricelist.line · extends an existing modelmargin, margin_percent (Margin (%)), price_vat_excl (Unit Sales Price (Excl.)), price_vat_incl (Unit Sales Price (Incl.))

Text generated by AI (DeepSeek) from reading the Odoo 16.0 code on GitHub; it may contain mistakes, so check the code before deciding. View the code on GitHub

Availability by version

Reviewed: 2026-11-03
Confirmed (verified in repository and branch) Estimated (unverified) No information

Confirmation status: 1 confirmed, 8 with no information of 9 versions.

Sources · Odoo 16.0

Confirmed on 2026-11-03 in branch 16.0 of OCA/product-attribute.

terminal Installation and usage

OCA documentation · Odoo 16.0

Usage

Source · Odoo 16.0
  • Go to "Sale > Products > Products"
  • Open a product form
  • on the button incorporated in the module 'product_pricelist_simulation'
  • Click on the button, and check if the margins are correct
  • you can optionnaly change date, or quantity, if you have complex pricelist depending on such parameters.

No verified information in OCA: Installation, Configuration.

info

Data imported from GitHub: this sheet reflects the latest catalog review, not a live lookup. Always check the module documentation and staging before installing in production.