Sari la conținut
Odoo Meniu
  • Autentificare
  • Try it free
  • Aplicații
    Finanțe
    • Contabilitate
    • Facturare
    • Cheltuieli
    • Spreadsheet (BI)
    • Documente
    • Semn
    Vânzări
    • CRM
    • Vânzări
    • POS Shop
    • POS Restaurant
    • Abonamente
    • Închiriere
    Site-uri web
    • Constructor de site-uri
    • eCommerce
    • Blog
    • Forum
    • Live Chat
    • eLearning
    Lanț Aprovizionare
    • Inventar
    • Producție
    • PLM
    • Achiziție
    • Maintenance
    • Calitate
    Resurse Umane
    • Angajați
    • Recrutare
    • Time Off
    • Evaluări
    • Referințe
    • Flotă
    Marketing
    • Social Marketing
    • Marketing prin email
    • SMS Marketing
    • Evenimente
    • Automatizare marketing
    • Sondaje
    Servicii
    • Proiect
    • Foi de pontaj
    • Servicii de teren
    • Centru de asistență
    • Planificare
    • Programări
    Productivitate
    • Discuss
    • Artificial Intelligence
    • IoT
    • VoIP
    • Knowledge
    • WhatsApp
    Aplicații Terțe Odoo Studio Platforma Odoo Cloud
  • Industrii
    Retail
    • Book Store
    • Magazin de îmbrăcăminte
    • Magazin de Mobilă
    • Magazin alimentar
    • Magazin de materiale de construcții
    • Magazin de jucării
    Food & Hospitality
    • Bar and Pub
    • Restaurant
    • Fast Food
    • Guest House
    • Distribuitor de băuturi
    • Hotel
    Proprietate imobiliara
    • Real Estate Agency
    • Firmă de Arhitectură
    • Construcție
    • Property Management
    • Grădinărit
    • Asociația Proprietarilor de Proprietăți
    Consultanta
    • Firma de Contabilitate
    • Partener Odoo
    • Agenție de marketing
    • Law firm
    • Atragere de talente
    • Audit & Certification
    Producție
    • Textil
    • Metal
    • Mobilier
    • Mâncare
    • Brewery
    • Cadouri corporate
    Health & Fitness
    • Club Sportiv
    • Magazin de ochelari
    • Centru de Fitness
    • Wellness Practitioners
    • Farmacie
    • Salon de coafură
    Trades
    • Handyman
    • IT Hardware and Support
    • Asigurare socială de stat
    • Cizmar
    • Servicii de curățenie
    • HVAC Services
    Altele
    • Organizație nonprofit
    • Agenție de Mediu
    • Închiriere panouri publicitare
    • Fotografie
    • Închiriere biciclete
    • Asigurare socială
    Browse all Industries
  • Comunitate
    Învăță
    • Tutorials
    • Documentație
    • Certificări
    • Instruire
    • Blog
    • Podcast
    Empower Education
    • Program Educațional
    • Scale Up! Business Game
    • Visit Odoo
    Obține Software-ul
    • Descărcare
    • Compară Edițiile
    • Lansări
    Colaborați
    • Github
    • Forum
    • Evenimente
    • Translations
    • Devino Partener
    • Services for Partners
    • Înregistrează-ți Firma de Contabilitate
    Obține Servicii
    • Găsește un Partener
    • Găsiți un contabil
    • Meet an advisor
    • Servicii de Implementare
    • Referințe ale clienților
    • Suport
    • Actualizări
    Github Youtube Twitter Linkedin Instagram Facebook Spotify
    +1 (650) 691-3277
    Obține un demo
  • Prețuri
  • Ajutor
Trebuie să fiți înregistrat pentru a interacționa cu comunitatea.
Toate postările Oameni Insigne
Etichete (Vezi tot)
odoo accounting v14 pos v15
Despre acest forum
Trebuie să fiți înregistrat pentru a interacționa cu comunitatea.
Toate postările Oameni Insigne
Etichete (Vezi tot)
odoo accounting v14 pos v15
Despre acest forum
Suport

Error While adding Attributes to the Product

Abonare

Primiți o notificare când există activitate la acestă postare

Această întrebare a fost marcată
variantsattributes
1 Răspunde
1086 Vizualizări
Imagine profil
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
Imagine profil
Abandonează
Codesphere Tech

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

Imagine profil
Zehntech Technologies Inc.
Cel mai bun răspuns

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
Imagine profil
Abandonează
Îți place discuția? Nu doar citi, alătură-te!

Creează-ți un cont astăzi pentru a beneficia de funcții exclusive și a interacționa cu minunata noastră comunitate!

Înscrie-te
Postări similare Răspunsuri Vizualizări Activitate
Show Attribute with only 1 value on configurator/quote
variants attributes
Imagine profil
Imagine profil
1
apr. 23
4491
Cannot delete attribute's value Rezolvat
variants attributes
Imagine profil
1
nov. 22
5952
How to "hide" variants/attributes but still show products in POS odoo17 Rezolvat
pos variants attributes
Imagine profil
Imagine profil
Imagine profil
2
nov. 24
4797
Price extra for attribute depending on custom value [product variants, attributes]
pricing variants attributes
Imagine profil
Imagine profil
1
iul. 23
6348
[V8]best way to import product variants
v8 variants attributes
Imagine profil
Imagine profil
2
mai 16
10712
Comunitate
  • Tutorials
  • Documentație
  • Forum
Open Source
  • Descărcare
  • Github
  • Runbot
  • Translations
Servicii
  • Hosting Odoo.sh
  • Suport
  • Actualizare
  • Custom Developments
  • Educație
  • Găsiți un contabil
  • Găsește un Partener
  • Devino Partener
Despre Noi
  • Compania noastră
  • Active de marcă
  • Contactați-ne
  • Locuri de muncă
  • Evenimente
  • Podcast
  • Blog
  • Clienți
  • Aspecte juridice • Confidențialitate
  • Securitate
الْعَرَبيّة 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 este o suită de aplicații de afaceri open source care acoperă toate nevoile companiei dvs.: CRM, comerț electronic, contabilitate, inventar, punct de vânzare, management de proiect etc.

Propunerea de valoare unică a Odoo este să fie în același timp foarte ușor de utilizat și complet integrat.

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