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.
Stwórz konto dzisiaj, aby cieszyć się ekskluzywnymi funkcjami i wchodzić w interakcje z naszą wspaniałą społecznością!
Zarejestruj się| Powiązane posty | Odpowiedzi | Widoki | Czynność | |
|---|---|---|---|---|
|
2
maj 25
|
731 | ||
|
Import Products by SKU
Rozwiązane
|
|
2
mar 24
|
2968 | |
|
PRODUCT LISTS IMPORTING ISSUE
Rozwiązane
|
|
1
lut 22
|
2115 | |
|
No import button
Rozwiązane
|
|
5
lis 21
|
12535 | |
|
1
mar 17
|
3032 |
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.