Ir al contenido
Odoo Menú
  • Iniciar sesión
  • Pruébalo gratis
  • Aplicaciones
    Finanzas
    • Contabilidad
    • Facturación
    • Gastos
    • Hoja de cálculo (BI)
    • Documentos
    • Firma electrónica
    Ventas
    • CRM
    • Ventas
    • TPV para tiendas
    • TPV para restaurantes
    • Suscripciones
    • Alquiler
    Sitios web
    • Creador de sitios web
    • Comercio electrónico
    • Blog
    • Foro
    • Chat en directo
    • e-learning
    Cadena de suministro
    • Inventario
    • Fabricación
    • PLM
    • Compra
    • Mantenimiento
    • Calidad
    Recursos Humanos
    • Empleados
    • Reclutamiento
    • Ausencias
    • Evaluación
    • Referencias
    • Flota
    Marketing
    • Marketing social
    • Marketing por correo electrónico
    • Marketing por SMS
    • Eventos
    • Automatización de marketing
    • Encuestas
    Servicios
    • Proyecto
    • Partes de horas
    • Servicio de campo
    • Servicio de asistencia
    • Planificación
    • Citas
    Productividad
    • Conversaciones
    • Inteligencia artificial
    • IoT
    • VoIP
    • Información
    • WhatsApp
    Aplicaciones de terceros Studio de Odoo Plataforma de Odoo Cloud
  • Sectores
    Comercio al por menor
    • Librería
    • Tienda de ropa
    • Tienda de muebles
    • Tienda de ultramarinos
    • Ferretería
    • Juguetería
    Alimentación y hostelería
    • Bar y pub
    • Restaurante
    • Comida rápida
    • Casa de huéspedes
    • Distribuidor de bebidas
    • Hotel
    Inmueble
    • Agencia inmobiliaria
    • Estudio de arquitectura
    • Construcción
    • Gestión inmobiliaria
    • Jardinería
    • Asociación de propietarios
    Consultoría
    • Asesoría contable
    • Partner de Odoo
    • Agencia de marketing
    • Bufete de abogados
    • Adquisición de talentos
    • Auditorías y certificaciones
    Fabricación
    • Textil
    • Metal
    • Muebles
    • Alimentos
    • Cervecería
    • Regalos corporativos
    Salud y bienestar
    • Club deportivo
    • Óptica
    • Gimnasio
    • Especialistas en bienestar
    • Farmacia
    • Peluquería
    Oficios
    • Servicios de mantenimiento
    • Hardware y soporte técnico
    • Sistemas de energía solar
    • Zapatero
    • Servicios de limpieza
    • Servicios de calefacción, ventilación y aire acondicionado
    Otros
    • Organización sin ánimo de lucro
    • Agencia de protección del medio ambiente
    • Alquiler de vallas publicitarias
    • Estudio fotográfico
    • Alquiler de bicicletas
    • Distribuidor de software
    Explorar todos los sectores
  • Comunidad
    Aprender
    • Tutoriales
    • Documentación
    • Certificaciones
    • Formación
    • Blog
    • Podcast
    Potenciar la educación
    • Programa de formación
    • Scale Up! El juego empresarial
    • Visita Odoo
    Obtener el software
    • Descargar
    • Comparar ediciones
    • Versiones
    Colaborar
    • GitHub
    • Foro
    • Eventos
    • Traducciones
    • Convertirse en partner
    • Servicios para partners
    • Registrar tu asesoría contable
    Obtener servicios
    • Encontrar un partner
    • Encontrar un asesor fiscal
    • Contacta con un experto
    • Servicios de implementación
    • Referencias de clientes
    • Ayuda
    • Actualizaciones
    GitHub YouTube Twitter Linkedin Instagram Facebook Spotify
    +1 (650) 691-3277
    Solicitar una demostración
  • Precios
  • Ayuda
Debe estar registrado para interactuar con la comunidad.
Todas las publicaciones Personas Insignias
Etiquetas (Ver todo)
odoo accounting v14 pos v15
Sobre este foro
Debe estar registrado para interactuar con la comunidad.
Todas las publicaciones Personas Insignias
Etiquetas (Ver todo)
odoo accounting v14 pos v15
Sobre este foro
Ayuda

Error While adding Attributes to the Product

Suscribirse

Reciba una notificación cuando haya actividad en esta publicación

Esta pregunta ha sido marcada
variantsattributes
1 Responder
1097 Vistas
Avatar
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
Avatar
Descartar
Codesphere Tech

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

Avatar
Zehntech Technologies Inc.
Mejor respuesta

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
Avatar
Descartar
¿Le interesa esta conversación? ¡Participe en ella!

Cree una cuenta para poder utilizar funciones exclusivas e interactuar con la comunidad.

Inscribirse
Publicaciones relacionadas Respuestas Vistas Actividad
Show Attribute with only 1 value on configurator/quote
variants attributes
Avatar
Avatar
1
abr 23
4495
Cannot delete attribute's value Resuelto
variants attributes
Avatar
1
nov 22
5961
How to "hide" variants/attributes but still show products in POS odoo17 Resuelto
pos variants attributes
Avatar
Avatar
Avatar
2
nov 24
4798
Price extra for attribute depending on custom value [product variants, attributes]
pricing variants attributes
Avatar
Avatar
1
jul 23
6349
[V8]best way to import product variants
v8 variants attributes
Avatar
Avatar
2
may 16
10712
Comunidad
  • Tutoriales
  • Documentación
  • Foro
Código abierto
  • Descargar
  • GitHub
  • Runbot
  • Traducciones
Servicios
  • Alojamiento Odoo.sh
  • Ayuda
  • Actualizar
  • Desarrollos personalizados
  • Educación
  • Encontrar un asesor fiscal
  • Encontrar un partner
  • Convertirse en partner
Sobre nosotros
  • Nuestra empresa
  • Activos de marca
  • Contacta con nosotros
  • Puestos de trabajo
  • Eventos
  • Podcast
  • Blog
  • Clientes
  • Información legal • Privacidad
  • Seguridad
الْعَرَبيّة 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 es un conjunto de aplicaciones empresariales de código abierto que cubre todas las necesidades de tu empresa: CRM, comercio electrónico, contabilidad, inventario, punto de venta, gestión de proyectos, etc.

La propuesta única de valor de Odoo es ser muy fácil de usar y estar totalmente integrado.

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