Skip to Content
Menu
This question has been flagged
1 Reply
486 Views
  • I have a product with variant values ​​configured like Length, Width, Height, and color (Value extra price = 0). Because these parameters are very complex, it is not possible to use Odoo backend to calculate but it must go through Google Sheets. API

  • On the website, when the customer enters the parameters to be customized and then clicks the [Quotation] button. Odoo will send a request to Google Sheet, and then will get the final price, then will return it to Odoo.

  • Everything is working fine. But I'm having a big problem, I cannot override the external price in the next steps like [Add to Cart], [Check out], [Confirm Order], ... because the price is always recalculated based on the value extra price of the variant values ​​declared in Odoo. Please suggest me a solution to solve this problem. Thanks so much
Avatar
Discard
Best Answer

You mean to store the result of a calculated column? please try like the below:

thePrice= fields.Float(string='Price',compute='_compute_price',store=True)

Avatar
Discard
Author

The values ​​of the parameters Length, Width, Height are optional sizes that customers want, they can enter the desired size. And the system will return the selling price after being calculated.
These values ​​are dynamic, so I can't save them to the database at the moment.

Related Posts Replies Views Activity
2
Apr 25
255
3
Nov 24
6826
3
Sep 24
4941
0
Dec 17
3260
1
Apr 25
4218