Odoo Help


Product price deppends ot the quantity

on 8/31/13, 1:48 PM 1,149 views


When i create some budget or sent order of any product, the price deppends of the quantity, i need defined some rules or rate. For example for de product XXXX de price is 6.49 if the customer buy 4 items the price is 6.17 (more expensive)

Thanks in advance

Ray Carnes
On 8/31/13, 2:45 PM

This is managed via Pricelists

To help you work most effectively, OpenERP's pricelist principles are extremely powerful yet are based on simple and generic rules. You can develop both sales pricelists and purchase pricelists for products capable of accommodating conditions such as the date period, the quantity requested and the type of product.


Speaking about quantity : in product_pricelist_item table, i see min_quantity. is there a way to set a range for quantity ? From 1 to 100 = X, from 101 to 500 = Y etc. ?

on 8/31/13, 7:43 PM

Yes. If you set a minimum quantity in Min. Quantity, the rule will only apply to a quantity equal to or larger than the quantity set. This way, you can define reduced rates in steps according to the quantities ordered. First rule, min quantity of 500, second min quantity of 100, third no minimum quantity. Several rules can be applied to an order. OpenERP evaluates these rules by sequence number, to determine which rule(s) to apply to the specified price calculation. If several rules are valid, only the first in sequence is used for the calculation. The Sequence field determines the order.

Bista Solutions US, Ray Carnes
on 8/31/13, 10:27 PM

About This Community

This platform is for beginners and experts willing to share their Odoo knowledge. It's not a forum to discuss ideas, but a knowledge base of questions and their answers.


Odoo Training Center

Access to our E-learning platform and experience all Odoo Apps through learning videos, exercises and Quizz.

Test it now

Question tools

0 follower(s)


Asked: 8/31/13, 1:48 PM
Seen: 1149 times
Last updated: 3/16/15, 8:10 AM