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.
Ok, here is the deal !
I have import data from my previous ERP using CSV files. I have import suppliers, tags, categories, and all products.
So far, so good.
Now I met an issue for every import using product external ID (i.e. inventory and order point).
First message return Missing Error exception between line 2 and 10320 of my csv file which is not really helpfull.
After investigation, I finally discovered that external IDs are not related to product_template table like indicate in ir_model_data table (field res_id indicate product.template), but they are looking for records in product_product instead which of course don't have the same ID.
I discovered this issue when trying to import order point list. Message was finaly much more explicit:
ERREUR: une instruction insert ou update sur la table « stock_warehouse_orderpoint » viole la contrainte de clé étrangère « stock_warehouse_orderpoint_product_id_fkey » DETAIL: La clé (product_id)=(20664) n'est pas présente dans la table « product_product ». à la ligne 72
Sorry message is in French, but we can see that my external product ID is looking for pk of product_product instead of product_template.
My Odoo release: 9.0c-20161117
Is there any fix of this issue ?
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: 11/30/16, 11:50 AM|
|Seen: 127 times|
|Last updated: 11/30/16, 12:52 PM|