Odoo Help


update external Id of a product

Michael Zhang
on 7/18/14, 6:36 AM 1,263 views

A product has been created in openerp, when exported, its external ID is 


Any chance this external ID could be updated to other value?  We have a list of products from another database, we want to make products's external ID  in openerp the same as in the other database.




apparently, product.product_product_48 could be update to "product.product_product_" from openerp interface, Technical->External Identifiers, (where is the id of that product from another database.

Michael Zhang
on 7/20/14, 8:07 AM



| 5 4 6
Zagreb | Karlovac, Croatia

there is only 10 kind of people the ones that understand binary ... and others

On 7/18/14, 7:30 AM

Sure.. external_ids are stored in ir_model_data table

external ids are in form : module_name.external_id
so to get all exported ids for product you an run:
select module, name from ir_module_data where module='product';

Acourdingly, you can prepare and modify those records with sql update statement.. 


hope it helps...


Ludo - Neobis

--Ludo - Neobis--
| 2 2 5
Hoogvliet, Netherlands
--Ludo - Neobis--


Ludo - Neobis
On 7/18/14, 7:40 AM

No, not by default at least. It is also a bad idea, because OpenERP uses this idea in all sort of refences (in the many2one fields for example). Since the number is generated for you it is generally a bad practice to want to change it and/or base any business logic around it, other than using the api/orm.

For comparing products between 2 databases it is ofter better to compare another column, such as a required/readonly field.

About This Community

This platform is for beginners and experts willing to share their Odoo knowledge. It's not a forum to discuss ideas, but a knowledge base of questions and their answers.


Odoo Training Center

Access to our E-learning platform and experience all Odoo Apps through learning videos, exercises and Quizz.

Test it now

Question tools

1 follower(s)


Asked: 7/18/14, 6:36 AM
Seen: 1263 times
Last updated: 3/16/15, 8:10 AM