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.
Hi, I have a .csv database in wich I have about 1,4k products, and also I have about 60 suppliers that I've moved to another .csv. So now when I first import all 60 suppliers, products will conect. The main in problem is I am not able to connect products with suppliers. I've used Main Supplier, Main Supplier/External ID (using 50xx id for the 60 suppliers) and it doesn't work.
name,price,nothing,stock,external id,supplier tax,this is the supplier I have problem with,delay,cantidad minima,compra,barras
Ac. Almendras 1L,9.917,100,7,41015,P_IVA21_BC,5039,1,1,,8424410000000
Ac. Almendras plan 500ml,5.7,100,0,41014,P_IVA21_BC,5039,1,1,,ACAL
Ac. Es. manzanilla,10.818,100,0,1478,P_IVA10_BC,5001,1,1,,8435040000000
In the Supplier .csv I've set manual IDs so those are different suppliers but I dont get to see any of them in the product-supplier view.
Edit: im using Versión 8.0-c825d05
Edit: First, verify that the suppliers you imported (suppliers are just companies in the partner model) have the Supplier field set to True. You can just export a csv from OpenERP with those partners and look at the supplier field. Or, you could just look under the Sales & Purchases tab (on v8) for that company and see if supplier is checked.
If that field is checked for those partners, (I might be oversimplifying your problem) I would try to import all your products and all of your suppliers seperately. Then, export the products and suppliers, which will give you the export id's for both. Reference the 2 and then import the products csv you exported with the correct "seller_ids/company_id/id" column. The correct ID for supplier will now be in the database for each product.
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: 3/3/15, 1:47 PM|
|Seen: 1142 times|
|Last updated: 3/16/15, 8:10 AM|