Skip to Content
Odoo Menu
  • Prisijungti
  • Išbandykite nemokamai
  • Programėlės
    Finansai
    • Apskaita
    • Pateikimas apmokėjimui
    • Sąnaudos
    • Skaičiuoklė (BI)
    • Dokumentai
    • Pasirašymas
    Pardavimai
    • CRM
    • Pardavimai
    • Kasų sistema - Parduotuvė
    • Kasų sistema - Restoranas
    • Prenumeratos
    • Nuoma
    Svetainės
    • Svetainių kūrėjimo įrankis
    • El. Prekyba
    • Internetinis Tinklaraštis
    • Forumas
    • Tiesioginis pokalbis
    • eMokymasis
    Tiekimo grandinė
    • Atsarga
    • Gamyba
    • PLM
    • Įsigijimai
    • Priežiūra
    • Kokybė
    Žmogaus ištekliai
    • Darbuotojai
    • Įdarbinimas
    • Atostogos
    • Įvertinimai
    • Rekomendacijos
    • Transporto priemonės
    Rinkodara
    • Socialinė rinkodara
    • Rinkodara el. paštu
    • SMS rinkodara
    • Renginiai
    • Rinkodaros automatizavimas
    • Apklausos
    Paslaugos
    • Projektas
    • Darbo laiko žiniaraščiai
    • Priežiūros tarnyba
    • Pagalbos tarnyba
    • Planavimas
    • Rezervacijos
    Produktyvumas
    • Diskucija
    • Artificial Intelligence
    • IoT
    • VoIP
    • Žinių biblioteka
    • WhatsApp
    Trečiųjų šalių programos Odoo Studija Odoo debesijos platforma
  • Pramonės šakos
    Mažmeninė prekyba
    • Knygynas
    • Drabužių parduotuvė
    • Baldų parduotuvė
    • Maisto prekių parduotuvė
    • Techninės įrangos parduotuvė
    • Žaislų parduotuvė
    Food & Hospitality
    • Barai ir pub'ai
    • Restoranas
    • Greitasis maistas
    • Guest House
    • Gėrimų platintojas
    • Hotel
    Nekilnojamasis turtas
    • Real Estate Agency
    • Architektūros įmonė
    • Konstrukcija
    • Property Management
    • Sodininkauti
    • Turto savininkų asociacija
    Konsultavimas
    • Accounting Firm
    • Odoo Partneris
    • Marketing Agency
    • Teisinė firma
    • Talentų paieška
    • Auditai & sertifikavimas
    Gamyba
    • Textile
    • Metal
    • Furnitures
    • Maistas
    • Brewery
    • Įmonių dovanos
    Sveikata & Fitnesas
    • Sporto klubas
    • Akinių parduotuvė
    • Fitneso Centras
    • Sveikatos praktikai
    • Vaistinė
    • Kirpėjas
    Trades
    • Handyman
    • IT įranga ir palaikymas
    • Saulės energijos sistemos
    • Shoe Maker
    • Cleaning Services
    • HVAC Services
    Kiti
    • Nonprofit Organization
    • Aplinkos agentūra
    • Reklaminių stendų nuoma
    • Fotografavimas
    • Dviračių nuoma
    • Programinės įrangos perpardavėjas
    Browse all Industries
  • Bendrija
    Mokykitės
    • Mokomosios medžiagos
    • Dokumentacija
    • Sertifikatai
    • Mokymai
    • Internetinis Tinklaraštis
    • Tinklalaidės
    Skatinkite švietinimą
    • Švietimo programa
    • Scale Up! Verslo žaidimas
    • Aplankykite Odoo
    Gaukite programinę įrangą
    • Atsisiųsti
    • Palyginkite versijas
    • Leidimai
    Bendradarbiauti
    • Github
    • Forumas
    • Renginiai
    • Vertimai
    • Tapkite partneriu
    • Services for Partners
    • Registruokite jūsų apskaitos įmonę
    Gaukite paslaugas
    • Susiraskite partnerį
    • Susirask buhalterį
    • Susitikti su konsultantu
    • Diegimo paslaugos
    • Klientų rekomendavimas
    • Palaikymas
    • Atnaujinimai
    Github Youtube Twitter Linkedin Instagram Facebook Spotify
    +1 (650) 691-3277
    Gaukite demo
  • Kainodara
  • Pagalba
You need to be registered to interact with the community.
All Posts People Badges
Žymos (View all)
odoo accounting v14 pos v15
About this forum
You need to be registered to interact with the community.
All Posts People Badges
Žymos (View all)
odoo accounting v14 pos v15
About this forum
Pagalba

Error While adding Attributes to the Product

Prenumeruoti

Get notified when there's activity on this post

This question has been flagged
variantsattributes
1 Atsakyti
1101 Rodiniai
Portretas
INDIA MON AMOUR SAS, ANA SARMIENTO

i used to have attributes and variants in my odoo earler, then i deactivated them, now after long time i am trying use again, I activated the variants option and now trying to add colorsone product, but its giving me this error, please help. i am on odoo 19 enterprise. Thanks ​


RPC_ERROR Odoo Server Error Occured on atmashop.odoo.com on model product.template on 2026-04-11 23:33:42 GMT Traceback (most recent call last): File "/home/odoo/src/odoo/19.0/odoo/http.py", line 2298, in _serve_db return service_model.retrying(serve_func, env=self.env) ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ File "/home/odoo/src/odoo/19.0/odoo/service/model.py", line 188, in retrying result = func() ^^^^^^ File "/home/odoo/src/odoo/19.0/odoo/http.py", line 2353, in _serve_ir_http response = self.dispatcher.dispatch(rule.endpoint, args) ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ File "/home/odoo/src/odoo/19.0/odoo/http.py", line 2568, in dispatch result = self.request.registry['ir.http']._dispatch(endpoint) ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ File "/home/odoo/src/odoo/19.0/odoo/addons/base/models/ir_http.py", line 355, in _dispatch result = endpoint(**request.params) ^^^^^^^^^^^^^^^^^^^^^^^^^^ File "/home/odoo/src/odoo/19.0/odoo/http.py", line 808, in route_wrapper result = endpoint(self, *args, **params_ok) ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ File "/home/odoo/src/odoo/19.0/addons/web/controllers/dataset.py", line 32, in call_kw return call_kw(request.env[model], method, args, kwargs) ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ File "/home/odoo/src/odoo/19.0/odoo/service/model.py", line 97, in call_kw result = method(recs, *args, **kwargs) ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ File "/home/odoo/src/odoo/19.0/addons/web/models/models.py", line 88, in web_save self.write(vals) File "/home/odoo/src/odoo/19.0/addons/website_sale/models/product_template.py", line 269, in write return super().write(vals) ^^^^^^^^^^^^^^^^^^^ File "/home/odoo/src/odoo/19.0/addons/rating/models/rating_mixin.py", line 102, in write result = super().write(vals) ^^^^^^^^^^^^^^^^^^^ File "/home/odoo/src/odoo/19.0/addons/point_of_sale/models/product_template.py", line 53, in write return super().write(vals) ^^^^^^^^^^^^^^^^^^^ File "/home/odoo/src/odoo/19.0/addons/stock_account/models/product.py", line 114, in write res = super().write(vals) ^^^^^^^^^^^^^^^^^^^ File "/home/odoo/src/odoo/19.0/addons/stock/models/product.py", line 1138, in write res = super().write(vals) ^^^^^^^^^^^^^^^^^^^ File "/home/odoo/src/odoo/19.0/addons/product/models/product_template.py", line 589, in write res = super(ProductTemplate, self).write(vals) ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ File "/home/odoo/src/odoo/19.0/addons/mail/models/mail_thread.py", line 391, in write result = super().write(vals) ^^^^^^^^^^^^^^^^^^^ File "/home/odoo/src/odoo/19.0/addons/website/models/mixins.py", line 250, in write return super().write(vals) ^^^^^^^^^^^^^^^^^^^ File "/home/odoo/src/odoo/19.0/odoo/orm/models.py", line 4469, in write field.write(self, value) File "/home/odoo/src/odoo/19.0/odoo/orm/fields_relational.py", line 733, in write self.write_batch([(records, value)]) File "/home/odoo/src/odoo/19.0/odoo/orm/fields_relational.py", line 754, in write_batch self.write_real(records_commands_list, create) File "/home/odoo/src/odoo/19.0/odoo/orm/fields_relational.py", line 1038, in write_real flush() File "/home/odoo/src/odoo/19.0/odoo/orm/fields_relational.py", line 994, in flush comodel.create(to_create) File "/home/odoo/src/odoo/19.0/odoo/orm/decorators.py", line 365, in create return method(self, vals_list) ^^^^^^^^^^^^^^^^^^^^^^^ File "/home/odoo/src/odoo/19.0/addons/product/models/product_template_attribute_line.py", line 114, in create res._update_product_template_attribute_values() File "/home/odoo/src/odoo/19.0/addons/product/models/product_template_attribute_line.py", line 255, in _update_product_template_attribute_values self.product_tmpl_id._create_variant_ids() File "/home/odoo/src/odoo/19.0/addons/product/models/product_template.py", line 850, in _create_variant_ids Product.create(variants_to_create) File "/home/odoo/src/odoo/19.0/odoo/orm/decorators.py", line 365, in create return method(self, vals_list) ^^^^^^^^^^^^^^^^^^^^^^^ File "/home/odoo/src/odoo/19.0/addons/stock_account/models/product.py", line 277, in create products = super().create(vals_list) ^^^^^^^^^^^^^^^^^^^^^^^^^ File "/home/odoo/src/odoo/19.0/odoo/orm/decorators.py", line 365, in create return method(self, vals_list) ^^^^^^^^^^^^^^^^^^^^^^^ File "/home/odoo/src/odoo/19.0/addons/product/models/product_product.py", line 677, in create products = super(ProductProduct, self.with_context(create_product_product=False)).create(vals_list) ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ File "/home/odoo/src/odoo/19.0/odoo/orm/decorators.py", line 365, in create return method(self, vals_list) ^^^^^^^^^^^^^^^^^^^^^^^ File "/home/odoo/src/odoo/19.0/addons/mail/models/mail_thread.py", line 328, in create threads = super(MailThread, self).create(vals_list) ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ File "/home/odoo/src/odoo/19.0/odoo/orm/decorators.py", line 365, in create return method(self, vals_list) ^^^^^^^^^^^^^^^^^^^^^^^ File "/home/odoo/src/odoo/19.0/odoo/orm/models.py", line 4709, in create records = self._create(data_list) ^^^^^^^^^^^^^^^^^^^^^^^ File "/home/odoo/src/odoo/19.0/odoo/orm/models.py", line 4931, in _create records.modified(self._fields, create=True) File "/home/odoo/src/odoo/19.0/odoo/orm/models.py", line 6805, in modified for field, records, create in itertools.chain.from_iterable(todo): File "/home/odoo/src/odoo/19.0/odoo/orm/models.py", line 6916, in _modified_triggers yield from records._modified_triggers(subtree) File "/home/odoo/src/odoo/19.0/odoo/orm/models.py", line 6916, in _modified_triggers yield from records._modified_triggers(subtree) File "/home/odoo/src/odoo/19.0/odoo/orm/models.py", line 6909, in _modified_triggers records = model.search([(field.name, 'in', real_records.ids)], order='id') ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ File "/home/odoo/src/odoo/19.0/odoo/orm/models.py", line 1378, in search return self.search_fetch(domain, [], offset=offset, limit=limit, order=order) ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ File "/home/odoo/src/odoo/19.0/odoo/orm/models.py", line 1408, in search_fetch query = self._search(domain, offset=offset, limit=limit, order=order or self._order) ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ File "/home/odoo/src/odoo/19.0/odoo/orm/models.py", line 5369, in _search query.add_where(domain._to_sql(self, self._table, query)) ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ File "/home/odoo/src/odoo/19.0/odoo/orm/domains.py", line 1091, in _to_sql return field.condition_to_sql(field_expr, operator, value, model, alias, query) ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ File "/home/odoo/src/odoo/19.0/odoo/orm/fields_relational.py", line 476, in condition_to_sql return super().condition_to_sql(field_expr, operator, value, model, alias, query) ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ File "/home/odoo/src/odoo/19.0/odoo/orm/fields.py", line 1259, in condition_to_sql sql_expr = self._condition_to_sql(field_expr, operator, value, model, alias, query) ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ File "/home/odoo/src/odoo/19.0/odoo/orm/fields.py", line 1265, in _condition_to_sql sql_field = model._field_to_sql(alias, field_expr, query) ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ File "/home/odoo/src/odoo/19.0/odoo/orm/models.py", line 2930, in _field_to_sql sql = field.to_sql(self, alias) ^^^^^^^^^^^^^^^^^^^^^^^^^ File "/home/odoo/src/odoo/19.0/odoo/orm/fields_relational.py", line 460, in to_sql sql_field = super().to_sql(model, alias) ^^^^^^^^^^^^^^^^^^^^^^^^^^^^ File "/home/odoo/src/odoo/19.0/odoo/orm/fields.py", line 1218, in to_sql raise ValueError(f"Cannot convert {self} to SQL because it is not stored") ValueError: Cannot convert product.template.product_variant_id to SQL because it is not stored The above server error caused the following client error: RPC_ERROR: Odoo Server Error RPC_ERROR at makeErrorFromResponse (https://atmashop.odoo.com/web/assets/1/07c46b1/web.assets_web.min.js:3198:165) at XMLHttpRequest.<anonymous> (https://atmashop.odoo.com/web/assets/1/07c46b1/web.assets_web.min.js:3205:13) ​



0
Portretas
Atmesti
Codesphere Tech

Hello,
Trying to pull the latest code and update base module.
Let me know if it is not resolved.

Portretas
Zehntech Technologies Inc.
Best Answer

Hello,

This issue typically occurs when product variants are disabled and later re-enabled, especially if existing products were created during the period when variants were inactive.

The error you're seeing indicates a data inconsistency while Odoo is trying to regenerate product variants (in your case, while adding attributes like color).

You can try the following steps:

  • Ensure that the product does not already have conflicting variant records
  • Try creating a new test product and add attributes to check if the issue is product-specific
  • If the issue is only with existing products, it may require data cleanup (removing inconsistent attribute lines or variants)
  • Also, make sure all related modules (Inventory, Sales, Website, POS) are properly updated

In many cases, this requires a backend check to safely fix the inconsistent records.

Hope this works for you! If you need any help implementing this or want a more optimized approach, feel free to reach out for further discussion

Regards,

Zehntech Technologies Inc.

santosh.sekwadia@zehntech.com

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

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

Registracija
Related Posts Replies Rodiniai Veikla
Show Attribute with only 1 value on configurator/quote
variants attributes
Portretas
Portretas
1
bal. 23
4497
Cannot delete attribute's value Solved
variants attributes
Portretas
1
lapkr. 22
5965
How to "hide" variants/attributes but still show products in POS odoo17 Solved
pos variants attributes
Portretas
Portretas
Portretas
2
lapkr. 24
4798
Price extra for attribute depending on custom value [product variants, attributes]
pricing variants attributes
Portretas
Portretas
1
liep. 23
6349
[V8]best way to import product variants
v8 variants attributes
Portretas
Portretas
2
geg. 16
10713
Bendrija
  • Mokomosios medžiagos
  • Dokumentacija
  • Forumas
Atvirasis kodas
  • Atsisiųsti
  • Github
  • Runbot
  • Vertimai
Paslaugos
  • Odoo.sh talpinimas
  • Palaikymas
  • Atnaujinti
  • Pritaikytas programavimo kūrimas
  • Švietimas
  • Susirask buhalterį
  • Susiraskite partnerį
  • Tapkite partneriu
Apie mus
  • Mūsų įmonė
  • Prekės ženklo turtas
  • Susisiekite su mumis
  • Darbo pasiūlymai
  • Renginiai
  • Tinklalaidės
  • Internetinis Tinklaraštis
  • Klientai
  • Teisinis • Privatumas
  • Saugumas
الْعَرَبيّة 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 Svenska ภาษาไทย Türkçe українська Tiếng Việt

Odoo yra atvirojo kodo verslo programų rinkinys, kuris apima visas įmonės poreikius: CRM, El. Prekybą, Apskaitą, Atsargų, Kasų sistemą, Projektų valdymą ir kt.

Unikali Odoo vertės pasiūla – būti tuo pačiu metu labai lengvai naudojama ir visiškai integruota sistema.

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