Lot Based Pricelist
by Odoo DevHouse https://apps.odoo.com/apps/modules/browse?author=Odoo%20DevHouse$ 120.00
| Availability |
Odoo Online
Odoo.sh
On Premise
|
| Odoo Apps Dependencies |
•
Discuss (mail)
• Inventory (stock) • Invoicing (account) • Sales (sale_management) |
| Lines of code | 529 |
| Technical Name |
pricelist_lot_based |
| License | OPL-1 |
| Website | https://apps.odoo.com/apps/modules/browse?author=Odoo%20DevHouse |
| Versions | 18.0 19.0 |
| Availability |
Odoo Online
Odoo.sh
On Premise
|
| Odoo Apps Dependencies |
•
Discuss (mail)
• Inventory (stock) • Invoicing (account) • Sales (sale_management) |
| Lines of code | 529 |
| Technical Name |
pricelist_lot_based |
| License | OPL-1 |
| Website | https://apps.odoo.com/apps/modules/browse?author=Odoo%20DevHouse |
| Versions | 18.0 19.0 |
Lot Based Pricelist
Assign individual sales prices to inventory lots and serial numbers - select a lot on a quotation and Odoo sets the price automatically.
Standard Odoo pricing is set at the product, variant, or pricelist level. Businesses that receive inventory in multiple purchase batches - at different costs, expiry dates, or quality grades - cannot sell each batch at a different price without manual workarounds.
- LOT-001 purchased at $8 and LOT-002 at $12 both sell at the same product price
- Salesperson must manually override the unit price - no traceability of why
- No way to enforce expiry-based discounting per lot
- Margin control is impossible when batch costs vary significantly
- Serial-numbered high-value items (laptops, medical devices) cannot carry item-specific prices
This module adds a Lot Sale Price field to every inventory lot and serial number. When a salesperson selects a lot on a quotation line, Odoo automatically reads the lot price and updates the unit price, records the pricing source, and falls back to the standard pricelist when no lot price is set. Every price change is logged in a full audit history, and an inventory manager can push bulk updates across hundreds of lots in one wizard.
- Lot Sale Price field: Each lot/serial number carries its own sales price, stored in company currency
- Auto price update on lot selection: Selecting a lot in a quotation line instantly sets the unit price
- Pricing Information panel on lot form: Shows Lot Sale Price, Cost Price, Margin and Markup %
- Per-product opt-in: Enable lot pricing on individual products - other products are unaffected
- Pricing Source indicator: Order line shows whether price came from Lot, Pricelist, or Manual
- 4 priority rules: Lot Overrides Pricelist / Highest Wins / Lowest Wins / Manual Selection
- Price History audit trail: Every lot price change records old price, new price, user, and timestamp
- Bulk Update Wizard: Apply fixed ±, percentage ±, or exact price to dozens of lots in one step
- Expiry-based discounts (optional): Automatically reduce price as lot expiry approaches
- Invoice & Delivery preservation: Lot price and pricing source are carried through to invoices and stock moves
- Multi-currency & Multi-company: Prices stored in company currency; multi-company isolation enforced
- Security roles: Lot Pricing User (view) and Lot Pricing Manager (configure + bulk update)
- No core modifications: Pure inheritance - compatible with Odoo 18 Community and Enterprise
Pharmaceuticals
Each drug batch has a different purchase cost and expiry. Sell older stock at a discount, newer batches at full price - automatically.
Food & Beverage
Seasonal and perishable goods fluctuate in purchase price. Set a different selling price per production lot and maintain healthy margins.
Electronics
Serial-numbered devices (laptops, phones, servers) may carry individual warranties or configurations. Sell each at its own price.
Distribution & Wholesale
Multiple supplier invoices for the same SKU at different costs. Align the selling price to each batch's actual landed cost.
Chemical & Medical
Strict lot traceability requirements plus expiry-driven pricing strategies. Both are handled out of the box.
Retail & e-Commerce
Clear out aging inventory at dynamically reduced prices per lot - without touching the base product price for new stock.
Enable Lot Pricing in Sales Settings
Go to Sales -> Configuration -> Settings -> Lot Based Pricing. Enable Enable Lot Based Pricing, choose your Pricing Priority Rule (Lot Overrides / Highest / Lowest / Manual), and optionally enable Price History tracking and Expiry Discounts.
Enable Lot Pricing on a Product
Open the product form in Inventory -> Products. Tick the Enable Lot Based Pricing checkbox. Only products with this flag active will use lot-based pricing logic - all others behave normally.
Set Prices on Lots / Serial Numbers
Go to Inventory -> Products -> Lots / Serial Numbers. Open any lot - a Pricing Information panel now appears showing Lot Sale Price, Cost Price, Margin, and Markup %. Enter the price and save. You can also use the Bulk Update Wizard to set or adjust prices across many lots at once.
Create a Quotation and Select a Lot
In Sales -> Quotations -> New, add a product with lot pricing enabled. Two new columns appear: Lot / Serial Number and Pricing Source. Select a lot - the Unit Price updates immediately to the lot's configured price. The Pricing Source column shows Lot Price to confirm the source.
Confirm, Deliver, and Invoice
Confirm the sales order. The lot-based price is locked in - no recalculation occurs during invoicing. The delivery order preserves the lot reference for full traceability. The invoice inherits the lot price and pricing source from the sale order line.
Review Price History and Audit Trail
A Price History smart button on each lot form shows a complete log of every price change - who changed it, when, and from what value to what value. The full history is also accessible under Inventory -> Operations -> Lot Price History.
Lot Price Overrides Pricelist
Default. If a lot price is set, it always wins. Falls back to pricelist then product price when no lot price exists.
Highest Price Wins
Useful when lot pricing is a floor - if a customer pricelist offers more, use the pricelist.
Lowest Price Wins
Best for clearance scenarios - always apply the more competitive price from either source.
Manual Selection
The Pricing Source field is left editable so the salesperson can pick between Lot, Pricelist, or Manual.
Step 1 - Sales Settings: Lot Based Pricing Section
Navigate to Sales -> Configuration -> Settings and scroll to the new Lot Based Pricing block. Enable the feature, choose the pricing priority rule, and optionally turn on Price History and Expiry Discounts.
Step 2 - Product Form: Enable Lot Based Pricing
Open any product tracked by lots. A new Enable Lot Based Pricing checkbox appears on the General Information tab. Ticking it activates per-lot pricing logic for all lots belonging to this product.
Step 3 - Lots List: Pricing Columns
Go to Inventory -> Products -> Lots / Serial Numbers. Three new optional columns are available: Cost Price, Lot Sale Price, and Margin - giving you an instant overview of pricing and profitability across your entire lot portfolio.
Step 4 - Lot Form: Pricing Information Panel
Open any lot form. The new Pricing Information section shows the Lot Sale Price, Cost Price (from the product's standard cost), Margin, and Markup %. Here LOT-001 of Paracetamol 500mg is priced at $12.00 with a cost of $8.00 - giving a margin of $4.00 (50% markup).
Step 5 - Lot Form: Price History Smart Button
Once a lot price has been saved, a Price History smart button appears in the top button bar showing the count of recorded changes. Click it to open the full audit log filtered to that lot.
Step 6 - Sales Order with Lot Price Applied
A confirmed quotation for Paracetamol 500mg with LOT-001 and LOT-002 selected. The Unit Price is automatically set from the lot ($12.00 and $15.00 respectively) and the Pricing Source column shows "Lot Price", confirming the lot-based price is in effect.
Step 7 - Bulk Update Wizard: Update Lot Prices
Accessible from Inventory -> Configuration -> Update Lot Prices. Select lots (here: LOT-001, LOT-002, LOT-003), choose the update type - Percentage Increase 10% - and the Preview tab instantly shows old vs. new prices ($12->$13.20, $15->$16.50, $20->$22.00). Click Apply to write all changes at once.
Step 8 - Lot Price History: Full Audit Trail
Every price change is captured automatically when Enable Price History is on in settings. Each record shows the Lot, Old Price, New Price, Changed By user, and Changed Date. Access the full list at Inventory -> Operations -> Lot Price History.
When Enable Expiry-Based Discounts is turned on in settings and a lot has an expiration date, the system automatically reduces the effective sale price based on days remaining:
| Days Remaining | Discount Applied | Example (Lot Price = $100) |
|---|---|---|
| > 30 days | None | $100.00 |
| ⤠30 days | 10% off | $90.00 |
| ⤠15 days | 20% off | $80.00 |
| ⤠7 days | 40% off | $60.00 |
Sales User
- View lot prices on quotations
- See Pricing Source indicator
- Cannot modify lot prices
Lot Pricing User
- View all lot prices
- View price history
- Cannot create/edit history records directly
Lot Pricing Manager
- Configure lot prices on lot forms
- Run Bulk Update Wizard
- Full price history access
- Access Update Lot Prices menu
Installation & Configuration
- Prerequisites: Odoo 18 with the Sales, Inventory, Accounting, and Discuss apps installed
- Install: Go to Apps -> Update App List -> Search "Lot Based Pricelist" -> Install
- Configure: Go to Sales -> Configuration -> Settings -> Lot Based Pricing - enable the feature and set priority rules
- Enable on products: Open each product that should use lot pricing and tick Enable Lot Based Pricing
- Set prices: Open each lot under Inventory -> Products -> Lots / Serial Numbers and enter the Lot Sale Price
- Test: Create a quotation, add the product, select a lot - confirm the unit price updates automatically
Tip: Assign users to the Inventory / Lot Pricing / Manager group to allow them to configure prices and run the Bulk Update Wizard. Standard inventory users get read-only access by default.
Does this change pricing for products that don't have the flag enabled?
No. Only products with Enable Lot Based Pricing checked use this logic. All other products follow standard Odoo pricelist behavior without any change.
What happens if I select a lot that has no price set?
A warning message appears: "Selected lot does not have a configured sales price." The unit price falls back to the standard pricelist price - no blank price will appear on the order.
Is the lot price locked in after the order is confirmed?
Yes. Once the unit price is set by the lot selection, it behaves like any manually entered price - it is stored on the order line and is not recalculated during invoicing or delivery, even if the lot price changes later.
Can I update hundreds of lot prices at once?
Yes. Use the Bulk Update Wizard at Inventory -> Configuration -> Update Lot Prices. Select the target lots (multi-select supported), choose an update method (fixed ±, % ±, or set exact price), preview the result, then apply.
Does it modify any Odoo core models?
No. The module extends Odoo's standard models and views using only the built-in inheritance mechanism - no core files are modified. It is safe to install alongside other customizations.
Are multi-currency and multi-company supported?
Yes. Lot prices are stored in the company currency. Odoo's standard pricelist currency conversion applies when the customer's pricelist uses a different currency. Lot price history is isolated per company - users only see records belonging to their own company.
Accurate Batch-Level Margin Control
Set the selling price for each batch to reflect its actual purchase cost - eliminating cross-subsidization between high-cost and low-cost lots.
Zero Manual Price Overrides
Salespersons no longer need to know or look up each lot's price - the system applies it automatically the moment a lot is selected.
Full Price Audit Trail
Know exactly who changed a lot price, when, and from what value - critical for regulated industries and finance teams.
Reduce Waste with Expiry Discounting
Near-expiry lots are automatically priced lower to encourage sales - reducing write-offs for food, pharma, and chemical businesses.
Need Help or Have a Feature Request?
Odoo Proprietary License v1.0 This software and associated files (the "Software") may only be used (executed, modified, executed after modifications) if you have purchased a valid license from the authors, typically via Odoo Apps, or if you have received a written agreement from the authors of the Software (see the COPYRIGHT file). You may develop Odoo modules that use the Software as a library (typically by depending on it, importing it and using its resources), but without copying any source code or material from the Software. You may distribute those modules under the license of your choice, provided that this license is compatible with the terms of the Odoo Proprietary License (For example: LGPL, MIT, or proprietary licenses similar to this one). It is forbidden to publish, distribute, sublicense, or sell copies of the Software or modified copies of the Software. The above copyright notice and this permission notice must be included in all copies or substantial portions of the Software. THE SOFTWARE IS PROVIDED "AS IS", WITHOUT WARRANTY OF ANY KIND, EXPRESS OR IMPLIED, INCLUDING BUT NOT LIMITED TO THE WARRANTIES OF MERCHANTABILITY, FITNESS FOR A PARTICULAR PURPOSE AND NONINFRINGEMENT. IN NO EVENT SHALL THE AUTHORS OR COPYRIGHT HOLDERS BE LIABLE FOR ANY CLAIM, DAMAGES OR OTHER LIABILITY, WHETHER IN AN ACTION OF CONTRACT, TORT OR OTHERWISE, ARISING FROM, OUT OF OR IN CONNECTION WITH THE SOFTWARE OR THE USE OR OTHER DEALINGS IN THE SOFTWARE.
Please log in to comment on this module