ODOO'S FUNCTION
When creating a new sales order with products that have multiple price in a pricelist, Odoo by default picks the first price listed in the product’s pricelist. It does not automatically compare or select the best price.
CLUEDOO'S FUNCTION
CLuedoo improves this by automatically selecting the best price, based on predefined rules.
1. Go to Products > Access a product > Click on the Internal Link arrow in Category |  |
2. In the Sorting Price section, check on the checkbox "Sort pricelist by Cheapest in SO" |  |
3. Go to Sales > Products > Pricelists > Create a new pricelist for the product |  |
4. Create a new Sales Order > Select the correct Pricelist for the product > Choose the product in Sales Order line You can see the lowest price is chosen based on the price and minimum quantity configured |  |