Odoo is the world's easiest all-in-one management software. It includes hundreds of business apps:
CRM | e-Commerce | Accounting | Inventory | PoS | Project management | MRP | etc.
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.
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.
Please try to give a substantial answer. If you wanted to comment on the question or answer, just use the commenting tool. Please remember that you can always revise your answers - no need to answer the same question twice. Also, please don't forget to vote - it really helps to select the best questions and answers!
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.Register
Odoo Training Center
Access to our E-learning platform and experience all Odoo Apps through learning videos, exercises and Quizz.Test it now
|Asked: 7/18/14, 6:36 AM|
|Seen: 873 times|
|Last updated: 3/16/15, 8:10 AM|