How to use pricelist in Odoo

This article will guide you on how to configure and use Pricelist in Odoo.

Definition

Creating a pricelist for the products and services a company offers is essential in your business. The pricelist will determine the current prices of products and services offered to customers. Odoo allows you to easily manage and create pricelists, which can be applied to individual customers or specific sales orders.

Configuration

Enable pricelist function

To use pricelists in Odoo, you must enable the pricelist option in the settings of the Sales module.

• Go to Sales –> Configuration –> Settings –> Enable Pricelists and Save

  

• In Odoo, there are two pricelist options:

1. Multiple prices per product:

This allows you to set different prices for each product. You can configure prices based on specific criteria such as time, minimum quantity sold, and you can aplly the expiration date for each pricelist line.

2. Advanced price rules (discounts, formulas):

This option lets you create detailed price rules and apply discounts, profit margins, and rounding. You can calculate dynamic prices based on percentage discounts or complex formulas. It’s a suitable choice for creating more flexible pricing rules.

• This article focuses on guiding you through option number 2.

Create Pricelist

• Go to Sales –> Products –> Pricelists
• Click ‘New’ to create new pricelist

  

Country Group

• If you select a country group (e.g., European Union, South America), the pricelist will be applied to customers whose country belongs to the selected country group.

Discount Policy

• There are 2 discount policy option. These options determine how pricing information is presented to customers in the sales process

1. Discount included in the price:

The discount is directly applied to the product price, and the final price shown to the customer is the discounted price. The customer will not see the original price or the discount percentage, they will only see the final, reduced price.

2. Show public price & discount to the customer:

Both the original public price and the discount are shown to the customer. This means the customer will see the original price, the discount percentage or amount, and the final discounted price. This option is more transparent and lets the customer know how much they are saving

Define Price Rules

• After creating a pricelist, the next step is to define price rules for products, product variants, or product categories.
• From the Price Rules tab, click on ‘Add a line’

  

When defining a price rule, there are three options for price computation: Fixed Price, Discount, and Formula.

1. Fixed Price:

• This option sets a specific price for the product or product variant. Regardless of the original price or any other factors, the product will be sold at the fixed price defined in this rule.

  

2. Discount:

• This option applies a discount to the product’s original price. The discount can be defined as a percentage or a fixed amount, reducing the original price by the specified discount value.

  

3. Formula:

• This option allows you to define a price based on a custom formula. You can create complex pricing rules using mathematical expressions and variables, which can take into account factors like quantity, product attributes, or other conditions. This option provides flexibility for more advanced pricing strategies.

  

3.1 Based on:

• There are 3 options for ‘Based on’:
• Sales Price: The formula will be based on the product sales price.
• Cost: The formula will be based on the product cost.
• Other Pricelist: The formula will be based on the other pricelist. You have to specify another pricelist if this option is selected.

3.2 Discount:

• Apply a percentage Discount or mark-up (input the negative value)

3.3 Extra Fee:

• This value allows you to add an additional fixed amount to the calculated price. It can be used to cover extra costs or add a standard fee to the product price. For example, If you have a price rule as below.

  

• This price rule will calculate the final price for the customer as follows. For example, The product sales price is $10.
• Price after discount = $10 * * (1 - 0.1) = $9
• Final price = Price after discount + extra fee = $9 + $2 = $11

3.4 Rounding Method:

• Define a Rounding Method by forcing the price after Discount to be a multiple of the value set. The Extra Fee is applied afterward.
• You can use the Rounding Method in combination with the Extra Fee to achieve a final price ending in .99. For example, you may want the final price to be $8.99 or $9.99 instead of $9.00 or $10.00
• For example, if you have a price rule as below.

  

• This price rule will calculate the final price for the customer as follows. For example, The product sales price is $12.
• Price after discount = $12 * (1 - 0.1) = $10.8
• Rounding up $10.8 to $11.0
• Final price = $11 - extra fee = $11 - $0.01 = $10.99

3.5 Margins:

• If you set minimum and maximum margins, Odoo will ensure that your profit margin is within the specified range based on the product cost.

• For example, if you have a price rule as below.

  

• For example, The product cost is $40.

• Price after make-up = $40 + ($40 * 70%) = $68

• Margin = $68 - $40 = $26

• Since the margin is within the range of $10 to $30, the final price will be $68.

• If another product with cost is $50

• Price after make-up = $50 + ($50 * 70%) = $85

• Margin = $85 - $50 = $35

• Since the margin exceeds the maximum margin, Odoo will subtract $5 to ensure the margin falls within the $10 to $30 range. The final price will be $80.

4. Conditions:

• Next, you can apply this price rule to ‘All Products,’ a Product Category, a Product (Product Template), or a Product Variant.
• You can set a minimum quantity for which this price rule will be applied.
• You can set the Validity period to determine when this price rule will start to be applied.

Apply pricelist to customer

• Next, you can apply the pricelist to the customer.

  

• When you create a sales order and select a customer, Odoo will automatically apply the sales order pricelist from the customer’s pricelist. However, you can still change the sales order pricelist if needed.