Odoo Help


How to connect products with suppliers

Rodrigo Alonso Iglesias
on 3/3/15, 1:47 PM 689 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. 

Your Answer

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.


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: 689 times
Last updated: 3/16/15, 8:10 AM