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 Image [1] 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. Image [2] Image [

How to apply total extra price to variant products from external API?

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

客户关系管理
e-Commerce
会计
库存
PoS
Project
MRP

All apps

所有帖文人徽章

标签（查看所有）

odoo accounting v14 pos v15

关于此论坛区

帮助

How to apply total extra price to variant products from external API?

product variant odoo17EE

1 回复

798 查看

Long Duong Nhat

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

vivian315bj

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)

Long Duong Nhat

编写者

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.

喜欢讨论吗？不要只阅读，加入进来！

立即创建账户，享受专属功能，与我们的精彩社区互动！

相关帖文	回复	查看
Is it possible to easily assign one image to multiple product variants? product variant	3 5月 25	1145
Pros and Cons of creating product variants Instantly or Dynamically or Never 已解决 product variant	3 11月 24	7846
Allow selection of multiple values from a single attribute of a product's variant product variant	3 9月 24	5721
How to change taxes in product variants? product variant	0 12月 17	3695
Can someone explain how multi-variants work in v7? 已解决 product variant	1 4月 25	4862

此问题已终结

喜欢讨论吗？不要只阅读，加入进来！