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:

CRM
e-Commerce
Księgowość
Zapasy
PoS
Project
MRP

All apps

Wszystkie posty Osoby Odznaki

Tagi (Zobacz wszystko)

odoo accounting v14 pos v15

O tym forum

Pomoc

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

product variant odoo17EE

1 Odpowiedz

890 Widoki

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

Autor

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.

Podoba Ci się ta dyskusja? Dołącz do niej!

Stwórz konto dzisiaj, aby cieszyć się ekskluzywnymi funkcjami i wchodzić w interakcje z naszą wspaniałą społecznością!

Zarejestruj się

Powiązane posty	Odpowiedzi	Widoki
Is it possible to easily assign one image to multiple product variants? product variant	3 maj 25	1510
Pros and Cons of creating product variants Instantly or Dynamically or Never Rozwiązane product variant	3 lis 24	8276
Allow selection of multiple values from a single attribute of a product's variant product variant	3 wrz 24	6102
How to change taxes in product variants? product variant	0 gru 17	3907
Can someone explain how multi-variants work in v7? Rozwiązane product variant	1 kwi 25	5134

To pytanie dostało ostrzeżenie

Podoba Ci się ta dyskusja? Dołącz do niej!