How to CSV-import products (product.templates) with a relation to their respective main suppliers in Odoo V8?
All the suppliers are in de database. Now I am trying to import (via the normal csv import funcionality) all products into Odoo, and this, of course, linked to their respective suppliers (or rather: just one main supplier).
If I first export ("Import compatible export) one product record (not linked to a supplier) with minimal data (only product external ID and Main Supplier External ID), I get:
If I add the supplier to the product and do the same export, I get:
However, removing the supplier from the product and then importing the exact csv I just exported, doesn't link the product to the supplier. The csv validates allright and there are no errors during the import either. Still, the product is not linked to the supplier.
I tried several ways of linking the product to the supplier, for instance via:
Main Supplier / External ID
Products / Main Supplier / External ID
Products / Products / Main Supplier / External ID (what does this mean, actually?)
Looking up the external identifiers via "Settings - Sequences and Identiefiers - External Identiefiers" shows that the external ID's are correct, both for product as for supplier.
I've tried with product variants as well, but that didn't work either.
This question is closely related to (or the same as):
Thanks in advance!
From my own experience
When importing products with their suppliers'names:
1. the column identification must be "Supplier / Supplier"
2 the suppliers' names must be spelled exactly as they are in your database (including low/upper case)
3 you must have (in your csv file) a column called "supplier / minimal quantity" where you key in the appropriate quantity (by default 1 or 0)
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/6/15, 10:34 AM|
|Seen: 1052 times|
|Last updated: 3/16/15, 8:10 AM|