Odoo is the world's easiest all-in-one management software.
It includes hundreds of business apps:
A product has been created in openerp, when exported, its external ID is
product.product_product_48
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.
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...
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.
Crie uma conta hoje mesmo para aproveitar os recursos exclusivos e interagir com nossa incrível comunidade!
Inscreva-se| Publicações relacionadas | Respostas | Visualizações | Atividade | |
|---|---|---|---|---|
|
2
mai. 25
|
777 | ||
|
Import Products by SKU
Resolvido
|
|
2
mar. 24
|
3381 | |
|
PRODUCT LISTS IMPORTING ISSUE
Resolvido
|
|
1
fev. 22
|
2161 | |
|
No import button
Resolvido
|
|
5
nov. 21
|
12616 | |
|
1
mar. 17
|
3082 |
1. Use the live chat to ask your questions.
2. The operator answers within a few minutes.
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.