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.
Luo tili jo tänään nauttiaksesi yksinoikeusominaisuuksista ja osallistuaksesi mahtavaan yhteisöömme!
Rekisteröidy| Aiheeseen liittyviä artikkeleita | Vastaukset | Näkymät | Toimenpide | |
|---|---|---|---|---|
|
Product import xslx
Ratkaistu
|
|
3
elok. 25
|
830 | |
|
Import Products by SKU
Ratkaistu
|
|
2
maalisk. 24
|
3427 | |
|
PRODUCT LISTS IMPORTING ISSUE
Ratkaistu
|
|
1
helmik. 22
|
2187 | |
|
No import button
Ratkaistu
|
|
5
marrask. 21
|
12632 | |
|
1
maalisk. 17
|
3105 |
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.