Odoo Help


Importing products and suppliers

Peter Gower
on 10/30/14, 6:22 PM 6,367 views

I am trying to import a list of products and also the associated supplier for the product with there product refrence. I have got the product importing fine but I am struggling finding what fields to use for the supplier name and there reference. Can this all be imprted on one CSV file ?


michel Guénard

--michel Guénard--

| 5 5 8
--michel Guénard--

VP operations & finance Social entrepreneur Certified Public Accountant Past Chief internal auditor

michel Guénard
On 10/30/14, 7:12 PM

Yes you can import suppliers.

First create one supplier form using your Odoo instance. Once all needed fiels are setup and verified, then export this supplier data onto a csv file, with all mandatory field plus others you may need.

This file will show you the column names to reuse for the import of all other suppliers.


Thanks guys sorted it using the following Name,Internal Reference,Products / Products / Public Category,Can be Purchased,Can be Sold,Sale Price,Cost Price,Product Type,Products / Supplier /Supplier / External ID,Products / Supplier /Supplier Product Code,Products / Supplier /Supplier Product Name,sale_delay

Peter Gower
on 11/1/14, 11:34 AM

Ben Bernard

--Ben Bernard--

| 4 3 6
Jakarta, Indonesia
--Ben Bernard--
Ben Bernard
On 10/31/14, 12:42 AM

seller_ids / name

Peter Gower
On 11/1/14, 7:35 AM

Thanks for the info seller_ids / Name does not appear in the list when trying to import the product. I have a supplier set up and whant to import all there products but when I view the product i want it to show the supplier and there product code.



below the columns of an export for a product with supplier's information id name ean13 seller_ids/name/id seller_ids/min_qty list_price orderpoint_ids/product_min_qty default_code taxes_id/id seller_ids/product_name seller_ids/product_code __export__.product_product_102348 Guitare Sigma Table Acajou Massiv __export__.res_partner_1490 1.0 440.0 000M15 __export__.account_tax_49 supplier's product name supplier product code

AD LIBITOM, michel Guénard
on 11/1/14, 9:55 AM
Inforing Oy
On 1/27/15, 8:10 AM

But where the option "import-export" is?

Need the same for products...

when viewing a product (or any other object) list, tick the small box on the left side of the product name; this will open a new sub menu on the top of the list; there you will find an import or export button.

AD LIBITOM, michel Guénard
on 1/27/15, 4:25 PM

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: 10/30/14, 6:22 PM
Seen: 6367 times
Last updated: 3/16/15, 8:10 AM