Contact person: Business Client

Phone:Show

Email:Show

Location: Zürich, Switzerland

Budget: Recommended by industry experts

Time to start: As soon as possible

Project description:
"We are working on Odoo 19 (SaaS, Odoo Studio).
After Studio customizations, a critical server error occurs when saving products ([login to view URL]):

ValueError: Cannot convert product.template.product_variant_id to SQL because it is not stored


The error persists even when:

custom fields are removed from the views

the default Odoo views are restored

Objective

Identify and correctly fix the exact technical root cause, so that:

products can be saved without errors

non-stored fields (store = False) are no longer used in
domains, filters, related fields, automations, or ORM triggers

Mandatory Working Rules

NO trial-and-error

NO random changes

NO “quick fixes”

NO changes without prior explanation and approval

Every planned change must be explained first and approved by me before execution.

Required Technical Investigation

The freelancer must systematically inspect:

Domains & Filters

saved filters

automatic search filters

domains in views, fields, or actions

Related Fields (Odoo Studio)

especially chains involving
product_variant_id or product_variant_ids

any related field with store = False

Computed Fields

computed Studio fields

fields indirectly used in SQL queries

Automations

Studio automations

on-write / on-change triggers

Orphaned Studio Fields

fields no longer visible in views but still active internally

Acceptance Criteria (Very Important)

The task is considered complete only if:

The exact root cause is clearly identified
(e.g. Field X with Domain Y referencing non-stored Field Z)

It is clearly explained why the error occurs even when the field is not visible in the form

Products can be saved successfully without any server error

Explicitly NOT Wanted

rebuilding forms from scratch

deleting elements “just to try”

undocumented changes

multiple changes at once without a clear explanation

Effort & Payment

Estimated effort: 1–3 hours

Payment is based on proper analysis, not experimentation

Required Profile

Please apply only if you have:

strong Odoo ORM knowledge (v16–v19)

solid experience with Odoo Studio & [login to view URL]

proven ability to perform systematic root-cause analysis

If you want, I can also provide:

a short version for Fiverr

a screening checklist to evaluate the freelancer live

or a step-by-step validation plan once someone starts

Just tell me." (client-provided description)