Odoo Help


How to connect products with suppliers

Rodrigo Alonso Iglesias
on 3/3/15, 1:47 PM 1,333 views

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.

Example products

name,price,nothing,stock,external id,supplier tax,this is the supplier I have problem with,delay,cantidad minima,compra,barras

Ac. Ajedrea,29.909,100,3,1408,P_IVA10_BC,5051,1,1,,8422950000000
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

what version of odoo are you using?

Martin Temmink
on 3/3/15, 5:13 PM
Michael Thomas
On 3/3/15, 5:31 PM

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.


Odoo Training Center

Access to our E-learning platform and experience all Odoo Apps through learning videos, exercises and Quizz.

Test it now

Question tools

1 follower(s)


Asked: 3/3/15, 1:47 PM
Seen: 1333 times
Last updated: 3/16/15, 8:10 AM