Skip to Content
This question has been flagged
1 Odpoveď
7794 Zobrazenia
Avatar
Rodrigo Alonso Iglesias

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

Avatar
Zrušiť
Martin Temmink

what version of odoo are you using?

Avatar
Michael Thomas
Best Answer

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. 

Avatar
Zrušiť