Odoo Help


Update product stardard_price

Stavros Christodoulou
on 3/22/14, 2:38 PM 2,600 views

I would like to change the standard_price of product to include the discount from my supplier. At the moment the standard_price is updated without the discount.

Where I can find the the code which updates the standard_price when the product is received after the purchase order?

Thank you


Ray Carnes

--Ray Carnes--
| 9 7 9
Keyport, United States
--Ray Carnes--

Senior ERP Analyst

OpenERP 6.1, 7.0; Odoo 8.0, 9.0, 10.0 and 11.0.

Completed Odoo Functional and Technical Training.

Functional Areas:

  • CRM/Sales

  • Inventory

  • Manufacturing

  • Accounting

  • Purchasing

Major Skills:

  • Business Process Reengineering

  • Efficiency Consulting

  • User Needs and GAP Analysis;

  • Functional and Technical Design;

  • Prototyping and Proof of Concepts;

  • Requirements Specifications;

  • Agile Implementation;

  • Data Migration;

  • Configuration & Customization (UI and code);

  • Integration - Odoo and non Odoo Applications and Services;

  • Training and Knowledge Transfer;

  • Go Live Support;

  • Helpdesk;

  • Version Upgrades and Migration.

  • Accounting Expert.

I have over 20 years of experience empowering and enabling users with enterprise information systems that make a real and measurable difference in their ability to proactively manage their businesses and organizations. 

I am a skilled Communicator and I only take the serious things seriously!

Ray Carnes
On 3/22/14, 3:19 PM

Is average pricing what you want?

OpenERP will automatically set the product price in response to each goods receipt movement into the warehouse (a Purchase from a Supplier).

At each goods receipt, the product price is recalculated using the following accounting formula:

NP = (OP * QS + PP * QR) / (QS + QR)

The following notation is used:

  • NP: New Price,

  • OP: Old Price,

  • QS: Quantity actually in Stock,

  • PP: Price Paid for the quantity received,

  • QR: Quantity Received.

If the products are managed in this way, OpenERP will open a window that lets you specify the price of the product received at each goods receipt. The purchase price is, by default, set from the purchase order, but you can change the price to add the cost of delivery to the various received products.

Once the receipt has been confirmed, the price is automatically recalculated and entered on the product form.

To congfigure OpenERP to do this:

1) Navigate to Settings --> Configuration --> Purchasing

2) Check the box next to Compute Product cost price based on average cost:

image description

3) On each product you want managed this way, on the Procurements tab, set the Costing Method to Average Price:

image description

Dear Ray, Thank you for the quick response! The average price is computed correctly. This is done when an Invoice for a purchase is validated. What I want to achieve is to save the last purchase price of an item in a new field. When a purchase order is validated and received, OpenERP updates the standard_price of the item but it does not include any discounts given by the supplier (Purchase order lines with discounts module). I want to know which part of the source code saves the new standard_price to the product. Thanks again for your help!

Stavros Christodoulou
on 3/24/14, 7:00 AM
Athan Lefas
On 10/20/14, 4:31 AM

I have the same problem as Stavros. Is there any possible way to fix that?

Thank you

Dear Athan, Our company can help you with that. Contact me at info(at)arinet.com.cy

Stavros Christodoulou
on 10/20/14, 4:37 AM

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

2 follower(s)


Asked: 3/22/14, 2:38 PM
Seen: 2600 times
Last updated: 3/16/15, 8:10 AM