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.
For a project migrating from VirtueMart to Odoo, I need to keep the original Database ID in the product URL on the website. I need either to import products with their original Database ID or to change the product URL into something else using data from External ID or another field.
The simplest solution seems to change the product Database ID into the original one from VirtueMart. But how can I do that ? Can I edit tables in Postgresql without breaking all relational fields ? Is there a better solution ?
See this Daniel Reis answer on Stackoverflow http://stackoverflow.com/questions/34538959/in-odoo-what-is-an-external-id-and-what-are-its-uses/35686956 External IDs are stored in ir.model.data
IDs from product_templates are the ones used in URLs. One can import products directly in Postgresql tables product_template and product_product (which store product IDs related to product_template, like in variants). Then don't forget to update corresponding Postgresql's sequences with you last ID.
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: 10/8/16, 8:20 AM|
|Seen: 223 times|
|Last updated: 1/6/17, 8:20 AM|