Configuring Pricelists with Rules and Formulas in Odoo

Pricing is rarely one fixed number per product. How to configure pricelists with rules and formulas in Odoo.

Real pricing is rarely one fixed number per product. It varies by customer, by quantity, by situation. Pricelists are how Odoo handles that. This piece is about configuring pricelists with rules and formulas.

Why pricing needs more than a fixed price

A product has a base price, but the price a particular customer pays often differs from it. Some customers get a discount; some get special pricing; price may vary with the quantity ordered; price may depend on other factors. If pricing were only a single fixed number per product, all of that variation would have to be handled by overriding the price by hand on every quotation, which is slow and error-prone. Pricelists exist to handle pricing variation as configured rules rather than manual overrides.

What a pricelist is

A pricelist in Odoo is a defined set of pricing that applies in a particular situation. A business can have more than one pricelist, and apply different pricelists to different customers or situations, so that the price a customer sees is the price from the pricelist that applies to them. The pricelist is how the right pricing is applied automatically, rather than a salesperson having to remember and key in the right price each time.

Rules and formulas within a pricelist

A pricelist is made up of rules, and the rules can express pricing in different ways. A rule can set a fixed price for a product. A rule can apply a discount or another adjustment to the base price. A rule can use a formula, computing the price from the base price by some defined calculation. And rules can apply conditionally, for example depending on the quantity, so that a different price applies above a certain quantity. This is what gives pricelists their flexibility: a pricelist is not just a list of fixed prices but a set of rules and formulas that can express genuine pricing logic.

Configuring pricelists to match your pricing

Configuring pricelists well means setting them up to match the business's genuine pricing logic. The practical work is understanding how the business's pricing actually varies, by customer or customer group, by quantity, by situation, and then configuring pricelists, with their rules and formulas, to express that. A business with customer groups that get different pricing configures pricelists for those groups. A business with quantity-based pricing configures rules conditional on quantity. The aim is that the business's real pricing logic is captured in the pricelists, so the right price is applied automatically.

The benefit: pricing applied correctly and consistently

The benefit of configured pricelists is that pricing is applied correctly and consistently, without manual effort. The right customer gets the right price, automatically, because the pricelist that applies to them carries it. There is no reliance on a salesperson remembering the right price, and no risk of inconsistent pricing because different people priced differently. For a business with any real pricing complexity, configured pricelists turn pricing from a manual, error-prone task into an automatic, consistent one.

Keep pricelists maintained

An honest note. Pricelists capture pricing, and pricing changes. As the business's prices and pricing logic change, the pricelists must be kept updated, or they will apply outdated pricing. Configuring pricelists is not a one-time task; it includes the ongoing discipline of keeping them current. And, as with templates, pricelists should be kept as focused as the business's genuine pricing requires; an unnecessarily elaborate tangle of pricelists is hard to maintain.

The takeaway

Pricelists in Odoo handle pricing that varies by customer, quantity, or situation, as configured rules rather than manual overrides. A pricelist is a defined set of pricing for a situation, made of rules that can set fixed prices, apply discounts, use formulas, or apply conditionally. Configure pricelists to match the business's genuine pricing logic, so the right price is applied automatically and consistently, and keep them maintained as pricing changes. For how we approach Odoo, see our ERP practice.

All posts

Got a Topic Worth Posting?

Suggest a Topic

If a question keeps coming up in your operations, it might be worth its own post.