How To Configure Pricelists in Odoo
How To Configure Pricelists In Odoo
Pricelist is a powerful feature of Odoo to create a pricing strategy for your business.
Users can set date-controlled product prices based on the currencies. It also allows the user to set discounts based on specific customers or companies. That means user can set different prices for the same product for different customers & companies.
In this blog, we are going to see the Use of Pricelists in Odoo & How we can Configure Pricelists in Odoo.
Pricelists contain price rules on the products. The pricelist can be specified to a limited number of products or customers also.
Each customer can have its own individual pricelist. The product prices from the pricelists replace the product list price when they are associated in a transaction with customers or companies in which the price rules are setup.
To Configure Pricelists in Odoo, we are going to follow these steps:
1) Activate the Pricelists to be used in the Sales.
2) Create Pricelists in Sales.
3) Add the suitable Pricelists to the customers.
So, let us start:
By default, a default price list with 0% discount is applied to every customer created or present in Odoo. We can then change the pricelists for every customer.
First, navigate to the Sales > Configuration > Pricing > Pricelists.
Here, we can enable/disable the pricelists.
1) When you select ‘Multiple Prices Per Products’, it adds an option to set multiple unit/list prices to the product.
That means, we can set a different price to a product at a pricelist & can then use this pricelist for a customer or company.
It doesn’t include any discount or any other formula and simply updated the price for that pricelist & its applicable users.
We can create the pricelists in the configuration. We can set a company for this pricelist so that these pricelists gets applied to the customers of this company.
--- Important Note ---
We can also specify a minimum quantity for the product on which this pricelist would be applied. For example, let us say, the list price for a product is 100 & we want to set a rule that if the customer buys 10 quantities of a product, the list price should be 50 for that customer. So, we can create a pricelist for that product (or multiple products) , and set minimum quantity in this pricelist.
We can also set date period at the pricelist which will act as a filter so that the pricelist will be applied on orders only between that date period.
This extra price is shown in the product like this.
We can then set this pricelist for the customer here.
After setting the customer, we’ll now create the order.
As you can see, the product price is changed to 100 for this customer.
2) Now, let us move to the next step which is ‘Advanced Price Rules (Discounts, Formulas)’. It provides us an option to create a pricelist with applied discounts.
When we click on add an item, we get a pop-up which specifies if the pricelist should be applied on :
➢ All Products
➢ Product Category ( or category wise)
➢ Product ( on a single product)
➢ Product Variant
We can specify the company, minimum quantity and also the date period for the pricelist as mentioned above.
Now the Price computation in this pricelist works something like this:
We have an option to compute price based on :
➢ A Fixed Price ( where we can set a fixed price for the product)
➢ Percentage ( percentage-wise discount on the product)
➢ Formula ( based on which the price is computed)
First, we’ll take a case where we’ll set a fixed price, let us say, 200 in this pricelist for all the products and set this pricelist for the customer.
Now, we’ll create an order with this customer.
We can see clearly that the price of every product for this customer is changed to 200.
Now, let us see the case where we set a discount percentage for the products.
We can set a percentage, say, 10% for all the products in this pricelist. This means that every time a product is created with this customer, a discount of 10% will be applied to the products.
--- Important Note ---
Navigate to the Configuration tab in this form. We can see a field 'Discount Policy' here.
This means that we can either show the list price with discount included in it.
Or we can also show a discount percentage separately in lines.
Now we’ll create an order with the customer in which the pricelist is set.
We can see that the discount percentage applied in the pricelist is shown here in the order lines for the product in case this pricelist is applied.
We can set price rules based on a formula using the third option. So, following these simple steps, we can create different pricelists for different customers based on our needs. Or we can set pricelist for an entire company also.