Skip to Content
Odoo Menu
  • Sign in
  • Try it free
  • Apps
    Finance
    • Accounting
    • Invoicing
    • Expenses
    • Spreadsheet (BI)
    • Documents
    • Sign
    Sales
    • CRM
    • Sales
    • POS Shop
    • POS Restaurant
    • Subscriptions
    • Rental
    Websites
    • Website Builder
    • eCommerce
    • Blog
    • Forum
    • Live Chat
    • eLearning
    Supply Chain
    • Inventory
    • Manufacturing
    • PLM
    • Purchase
    • Maintenance
    • Quality
    Human Resources
    • Employees
    • Recruitment
    • Time Off
    • Appraisals
    • Referrals
    • Fleet
    Marketing
    • Social Marketing
    • Email Marketing
    • SMS Marketing
    • Events
    • Marketing Automation
    • Surveys
    Services
    • Project
    • Timesheets
    • Field Service
    • Helpdesk
    • Planning
    • Appointments
    Productivity
    • Discuss
    • Approvals
    • IoT
    • VoIP
    • Knowledge
    • WhatsApp
    Third party apps Odoo Studio Odoo Cloud Platform
  • Industries
    Retail
    • Book Store
    • Clothing Store
    • Furniture Store
    • Grocery Store
    • Hardware Store
    • Toy Store
    Food & Hospitality
    • Bar and Pub
    • Restaurant
    • Fast Food
    • Guest House
    • Beverage Distributor
    • Hotel
    Real Estate
    • Real Estate Agency
    • Architecture Firm
    • Construction
    • Estate Management
    • Gardening
    • Property Owner Association
    Consulting
    • Accounting Firm
    • Odoo Partner
    • Marketing Agency
    • Law firm
    • Talent Acquisition
    • Audit & Certification
    Manufacturing
    • Textile
    • Metal
    • Furnitures
    • Food
    • Brewery
    • Corporate Gifts
    Health & Fitness
    • Sports Club
    • Eyewear Store
    • Fitness Center
    • Wellness Practitioners
    • Pharmacy
    • Hair Salon
    Trades
    • Handyman
    • IT Hardware & Support
    • Solar Energy Systems
    • Shoe Maker
    • Cleaning Services
    • HVAC Services
    Others
    • Nonprofit Organization
    • Environmental Agency
    • Billboard Rental
    • Photography
    • Bike Leasing
    • Software Reseller
    Browse all Industries
  • Community
    Learn
    • Tutorials
    • Documentation
    • Certifications
    • Training
    • Blog
    • Podcast
    Empower Education
    • Education Program
    • Scale Up! Business Game
    • Visit Odoo
    Get the Software
    • Download
    • Compare Editions
    • Releases
    Collaborate
    • Github
    • Forum
    • Events
    • Translations
    • Become a Partner
    • Services for Partners
    • Register your Accounting Firm
    Get Services
    • Find a Partner
    • Find an Accountant
    • Meet an advisor
    • Implementation Services
    • Customer References
    • Support
    • Upgrades
    Github Youtube Twitter Linkedin Instagram Facebook Spotify
    +1 (650) 691-3277
    Get a demo
  • Pricing
  • Help

Odoo is the world's easiest all-in-one management software.
It includes hundreds of business apps:

  • CRM
  • e-Commerce
  • Accounting
  • Inventory
  • PoS
  • Project
  • MRP
All apps
You need to be registered to interact with the community.
All Posts People Badges
Tags (View all)
odoo accounting v14 pos v15
About this forum
You need to be registered to interact with the community.
All Posts People Badges
Tags (View all)
odoo accounting v14 pos v15
About this forum
Help

What is the different between lst_price and list_price in product_template?

Subscribe

Get notified when there's activity on this post

This question has been flagged
productpriceodoo9
1 Reply
12090 Views
Avatar
Har Tech

Hello All,

Why do we have two fields in product template, lst_price, list_price.

Both are behaves as sales price of product, what is the need of taking lst_price as related field of list_price?

Regards,

Har



1
Avatar
Discard
Avatar
Sushma
Best Answer

Hi,

In product_template model, there are five price-related columns: 
price, list_price, lst_price, standard_price, pricelist_id.

In product_product model, there are three price-related columns: 
price, price_extra, lst_price,

standard_price: This is the cost or purchase price of a product. It is used to calculate the cost of goods -- mostly for accounting purpose.  Whenever its value changes, Odoo calls _set_standard_price to store value history in the product.price.history table.

price_extra: The price_extra is a computed field. A product template may have multiple product variants that have a combination of some attribute values. An attribute value can have an extra price. For example, 32GB memory may add an extra $50. The sum of hose extra prices for applicable product variant attributes will the the price_extra.

list_price: This field is the sales or product price displayed in a web site. When one wants to change the list_price of a product, it should change it in the product template. For individual product variant, change the attribute extra price.

lst_price in product_template model: it seems that the lst_price field can be used for both product_template and product_product as the product sale price. In product_template model, it points to the list_price field.

lst_price in product_product model: In product_product model, it is computed field that calls _product_lst_price. 
This function calculates the lst_price of a product variant by adding its list_price and its price_extra. 
The field also has an inverse function _set_product_lst_price that sets list_price when lst_price changes. 
The list_price value is the subtraction of price_extra from lst_price.

For a product variant, the lst_price is the sales or product price displayed in a web site.

price In both product_template model and product_product model, it is a computed field to calculate its value.
The method uses product.pricelist model to calculate a price based on rules defined in product.pricelist.item. 
any context variables, such as partner, UOM, currency and rule name, are used in finding the price. 
The price_get method is called in the calculation.

10
Avatar
Discard
Har Tech
Author

Thanks, Shushma. for good explanation..

salah

best and clear answer

Enjoying the discussion? Don't just read, join in!

Create an account today to enjoy exclusive features and engage with our awesome community!

Sign up
Related Posts Replies Views Activity
Problem to see Products - Odoo 9
product odoo9
Avatar
0
Jul 16
3114
Product Equipments Checklist Solved
product odoo9
Avatar
Avatar
1
Dec 15
4318
Customise the display of prices on the main page in online store
shop product price
Avatar
0
Nov 24
1601
Product price based on dimensions
product price dimensions
Avatar
Avatar
1
May 24
5902
Best practice for single item, multiple manufacturers, distinct cost, price, quality Solved
product price brand
Avatar
Avatar
Avatar
4
Jun 23
7232
Community
  • Tutorials
  • Documentation
  • Forum
Open Source
  • Download
  • Github
  • Runbot
  • Translations
Services
  • Odoo.sh Hosting
  • Support
  • Upgrade
  • Custom Developments
  • Education
  • Find an Accountant
  • Find a Partner
  • Become a Partner
About us
  • Our company
  • Brand Assets
  • Contact us
  • Jobs
  • Events
  • Podcast
  • Blog
  • Customers
  • Legal • Privacy
  • Security
الْعَرَبيّة Català 简体中文 繁體中文 (台灣) Čeština Dansk Nederlands English Suomi Français Deutsch हिंदी Bahasa Indonesia Italiano 日本語 한국어 (KR) Lietuvių kalba Język polski Português (BR) română русский язык Slovenský jazyk slovenščina Español (América Latina) Español ภาษาไทย Türkçe українська Tiếng Việt

Odoo is a suite of open source business apps that cover all your company needs: CRM, eCommerce, accounting, inventory, point of sale, project management, etc.

Odoo's unique value proposition is to be at the same time very easy to use and fully integrated.

Website made with

Odoo Experience on YouTube

1. Use the live chat to ask your questions.
2. The operator answers within a few minutes.

Live support on Youtube
Watch now