Cannot update product information through External ID

Question

Hello. I'm getting this error.
<type 'exceptions.AssertionError'>: External ID conflict, 10009 already refers to a `product.product` record, you can't define a `product.template` record with this ID.

I've checked the logs, and Odoo is trying to INSERT into database, instead of updating record.
Is anybody else having this problem?
Thanks

Ray Carnes · Answer

A product in Odoo is two things:  a product.template record and a product.product record.
Make sure you and your script knows why and when the script should be updating one versus the other.

Khaled Bayoumy · Answer

Hello everyone,
I have the same problem
But I noticed that I can update only through the same module I used to insert the products for the first time, It seems that it is a validation between different modules to overcome duplicate External ID
Example:
I imported the products firstly through the  invoicing module /Sales/Sellable products
so when updating these products I have to import from the same path
I hope this might help

Tyler Christensen · Answer

I am also experiencing this same issue. I will update as soon as I find some solution.

Aiheeseen liittyviä artikkeleita	Vastaukset	Näkymät
Update odoo records based on custom field import update employees	1 elok. 24	1653
Update data by import via .csv files? Ratkaistu import csv update	4 marrask. 23	32039
Correct import of related records to Odoo import vendor external_id	1 maalisk. 23	2763
how to update external id? Ratkaistu update database_id external_id	3 tammik. 21	40943
Weekly imports update the pricing for all our SKU's. Sometimes users create new products before the Import runs. This creates duplicates! How can I manage this? Ratkaistu import external_id v11.0	1 maalisk. 20	4572

Tämä kysymys on merkitty

Nautitko keskustelusta? Älä vain lue, vaan osallistu!