You could try this formula

Price = cost/(1-margin% as a decimal)

So if you want to make 20% margin on a product that costs $100

Price = $100/(1-.2)

Price = $1000/.8

Price = $125

In Odoo, the Advanced Pricelists feature allows for complex pricing rules based on various conditions such as customer groups, quantities, discounts, currencies, etc. However, computing a price based on the profit margin is not a standard built-in feature of Odoo’s pricelist functionality, at least not directly.

That said, there are ways you can implement this kind of pricing logic, and they depend on how you want to define and calculate profit. Typically, the goal is to set a price that ensures a certain profit margin over the cost price of the product. Here are a few options for achieving this in Odoo:

1. Custom Pricelist Computation with Profit Margin

You could create a custom Pricelist Computationformula that calculates the price based on the cost price and desired profit margin. 

To implement this:

   - Cost Price: This is the price at which you acquire or produce the product (or it  be the "standard cost" of the product in Odoo).

   - Profit Margin: This is a percentage you would like to apply over the cost price to determine the sale price.

   You would need to create a custom Python function in Odoo that calculates the sale price by applying the profit margin over the cost price. For example, if your cost price is `$50` and you want a 20% profit margin, the formula would be:

This formula can be integrated into a custom pricelist computation logic.

   To do this in Odoo:

   - Go to the Sales > Products > Pricelists menu.

   - Create a new pricelist or modify an existing one.

   - In the Pricelist Computation field, select Python and add the necessary Python code that computes the price based on the cost and desired profit margin.

2. Custom Product Cost and Markup Fields

If you prefer a more user-friendly approach without custom Python code, you could:

   - Add a custom field for the Desired Profit Margin in the product form (e.g., a field where the user specifies the markup percentage).

   - Use the Product Cost field (or Standard Price) as the base cost.

   - Then, you could create an automated action, a scheduled task, or a custom module that updates the Sale Price based on these inputs. For instance, a simple calculation could be done automatically whenever the cost or markup is updated.

3. Odoo Studio Customization (No Coding)

If you're using Odoo Studio, you can create custom fields for the markup and profit margin, then use Automated Actions or Server Actions to recalculate the sale price whenever relevant fields are updated.

For example:

   - Create a custom field for Desired Profit Margin on the product.

   - Create an automated action to trigger whenever the Cost or Desired Profit Margin changes.

   - The action would calculate the new sale price based on the formula and update the Sale Price.

4. Third-Party Modules

If you don't want to implement this yourself, there might be third-party Odoo apps in the Odoo App Store that offer more advanced pricelist management, including pricing based on profit margins. You can search for Profit Margin Pricing or Advanced Pricelist modules.

Example Custom Code (Python) for Pricelist Computation:

If you're comfortable with coding, here’s an example of what custom Python code might look like for computing the sale price based on profit margin:

# This Python code could be used for pricelist computation

# Assuming 'product' is the product record, 'profit_margin' is the desired margin (as a percentage)

cost_price = product.standard_price  # Get the cost price of the product

profit_margin = 20  # Example: 20% profit margin

sale_price = cost_price * (1 + profit_margin / 100)  # Apply the margin to the cost price

return sale_price  # Return the computed sale price

This custom function could be linked to the Pricelist Rule to adjust the sale price dynamically.

Conclusion:

While Odoo’s standard pricelist features don’t directly support profit-based pricing out of the box, you can achieve this through customization—either via custom Python code, fields for profit margin, or using Odoo Studio to automate the calculation. If you're familiar with Python and the Odoo development environment, custom code gives you the most flexibility. Alternatively, third-party modules might simplify this process if you prefer a plug-and-play solution.

Hola Marco, 

Tu ejemplo me ayudó a solucionar una lista de precios. 

Sin embargo, quería consultar contigo si ¿es posible utilizar operadores ternarios para calcular un precio?

Como ejemplo, evaluar el "precio base" y si cumple alguna de las condiciones, calcular un nuevo precio ya sea con una tarifa adicional o con un descuento. 

Un ejemplo sería el siguiente: 

result = PRECIO

if PRECIO > 3540 / 1.16:

    result = PRECIO - 300 / 1.16

elif PRECIO > 2299 / 1.16:

    result = PRECIO - 200 / 1.16

elif PRECIO > 1649 / 1.16:

    result = PRECIO - 100 / 1.16

¿lo puedo lograr en Odoo V17?