Lock Prices on SO and PO Product Lines in Odoo

By default, every time a user changes the “Quantity” field on a product line on an Odoo sale order or purchase order, the price is automatically updated to whatever price is set on the product Price list for that quantity.

This is not very convenient for companies that have varying pricing for specific customers, which is not consistent enough to create a price list. Instances include those where a quote has prices set manually, and a user must update the quantity to confirm an order, but wants to keep the price.

To prevent users from having to manually reset the price every time they update the “Quantity” field, Steersman has developed a “Lock Product Line Price” feature for Odoo.

Setting to stop prices from changing per order line

• Steersman added a “lock/unlock” check box to each product line.
• When the “lock” is set, it stops the “Unit Price” from updating, allowing Odoo users to make changes to the quantity without having to reset the price. If a user changes the product on this type of “locked” line, the price will still be recalculated for the new product.
• This lock is automatically engaged when a user manually modifies the “Unit Price” on a product line on an order.

Automatically lock the price on all product lines of an SO or PO in Odoo

• Steersman has also added an “Auto Price Lock” button to sales and purchase orders.
• When this toggle is turned on, the price on every new product line added to this Odoo order will be locked by default.

Lock/Unlock all existing product price lines on an SO or PO

• There are two buttons near the “totals” section on an order view. Those buttons will lock or unlock ALL existing price lines on the order.