How to Create and Manage Price List in Odoo?

Create and Manage Price List in Odoo

Odoo has an incredible price list highlight to help an estimating strategy for your business. Pricelist goes about as a spine for any variety of things to attend to productively.

It makes a bunch of costs for a particular gathering of purchasers, for a particular time frame period, or for explicit products. Businesses can make changes in the costs as per the opposition on the lookout or according to some particular seasons and events.

What do you mean by Price List in Odoo?

Let the word itself speak — “Pricelist is the price of the products which are put on sale”

It is essential for all product sale-related business. Be it a point of sale business, e-commerce, or drop-shipping, it is the price list that primarily attracts a buyer. A price list is a list of prices or price rules that Odoo searches to determine the suggested price.

You can set several criteria to use a specific price i.e. periods, min. sold quantity (meet a minimum order quantity and get a price break), etc.

Questions like;

  • How to use Price List in Odoo?
  • How to create a Price List in Odoo?
  • How to Manage Pricelist in Odoo?

have become common among the people.

If you also have such questions in your mind then don’t worry as this blog will help you to clarify all your doubts.

Categories of Price Lists:

Vendor Price List

Customer Price List

How to create a Vendor Price list in Odoo?

Odoo users can configure vendor pricelist by following way:

Go to the Purchase Module> click on the Configuration tab> click on Vendor Price Lists.

By default, vendor prices can be set manually in the product detail form. If the vendors provide you with the pricelist files then this option facilitates easy importing them.

Select any product> Click on Purchase Tab> Scroll down to the section vendors> Click on add a line> a pop up will be generated> Fill the fields to create the vendor price list in Odoo.

Important terms related to Vendor Price List in Odoo:

  • Minimal Quantity: Minimal quantity is the minimum quantity of products for the applicability of the price list.
  • Validity: Validity in the vendor price list can be defined as the time period for which a particular price list is valid.

How to create a Customer Price list in Odoo?

To create a price list in Odoo, you need to go to the Sales Module > Settings > Pricing > tick on the checkbox of Multiple Sales Prices per Product> Click on Price List> Here you can see the price lists that are already created;

Moreover, you can also create a new Sales price list in Odoo as follows:

  1. Add the name of the price list as per your wish; for instance: Big Billion Days, Christmas Sale, etc.
  2. Add the country name on which you want to validate the price list; you can create country groups also
  3. Customize the different groups of products on which price list is applicable
  4. Compute the Price Computation
  5. Save the changes

Applicability of products in the price list?

Applicability of the products in the Odoo pricelist:

  • Product Category: One can apply the price list according to the categories of the products, that are storable, consumable, and service.
  • Global: The category makes the price list available to all the products
  • Product: The price list can be implemented to a product specifically
  • Product Variant: One can also set the price list on a single product variant

How priority distribution is done in the Pricelist in Odoo?

The following list describes the priority in the decreasing order:

VariantProductProduct CategoryGlobal

If Odoo user selects a different price list than the created one for the particular product while creating a sales order. Then, the price list selected while creating the sales order will get priority.

How to manage Quantity & Time Period in Pricelist?

  • Managing Quantity
  • One can set the minimum quantity of the products to apply to the price list. It means if anyone selects less quantity while ordering than mentioned minimum quantity then price list cannot be implemented.
  • Setting Time Period
  • One can set the start date and end date for the validation of a price list at the time of creating a price list in Odoo.

How to calculate the Price in the Odoo Pricelist?

One can calculate the price in the Odoo price list in the following three ways:

  1. Fix Price: Here, you add the price to the price list manually. For instance, if you have added a price of $ 10 at its product level and at the time of creating the price list you have a fixed price of $5. Then, at the time you choose the same price list to create a sales order, $5 will automatically update.
  2. Percentage (discount): Here, you can define the discount you want to apply to the price list.
  3. Formula: Here, the price in the price list will be updated as per the following formula; New Price= Public Price — Price Discount (%) +

Surcharge(Markup)Odoo users can set a minimum as well as maximum margin to secure the profit.

There are the following use cases when Odoo user adds the minimum and maximum margin:

  • If a new price is less than the minimum margin then it will take the value of the minimum margin.
  • If the new price is more than the maximum margin then it will take the maximum margin value.

In case the price comes in between the minimum and maximum margin then it will take the New Price that comes with the help of formula.

Need Assistance?

Did you find the guide helpful? Please feel free to share your feedback.

For any doubt contact us at contact@serpentcs.com

SerpentCS offer ODOO development,odoo Customization,installation & integration,migration services to a broad spectrum of industrial niches. Visit serpentcs.com