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.
Create an account today to enjoy exclusive features and engage with our awesome community!
Registracija| Related Posts | Replies | Rodiniai | Veikla | |
|---|---|---|---|---|
|
Product import xslx
Solved
|
|
3
rugp. 25
|
886 | |
|
Import Products by SKU
Solved
|
|
2
kov. 24
|
3604 | |
|
1
vas. 22
|
2216 | ||
|
No import button
Solved
|
|
5
lapkr. 21
|
12661 | |
|
1
kov. 17
|
3115 |
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.