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.
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
|Asked: 3/3/15, 1:47 PM|
|Seen: 647 times|
|Last updated: 3/16/15, 8:10 AM|