Odoo Help


Trying to find the field which imports supplier´s info [Closed]

on 1/8/14, 12:38 PM 1,872 views

The Question has been closed

Ray Carnes
on 01/08/2014 17:37:20

When we go into Sales->Products You can see all the info about products, and under the procurements tab we can and should add a supplier for the product, right?

What I am trying to do is finding the correct field that imports from a CSV into that specific field, been trying many of the supplier options that we get when we export from OpenERP out to a CSV file and the fields either will not be recognized when I try to import it back or the field will be recognized but it will not add the supplier in the procurement tab after successfully importing my data.


Ray Carnes

--Ray Carnes--
| 9 7 9
Keyport, United States
--Ray Carnes--

Senior ERP Analyst

OpenERP 6.1, 7.0; Odoo 8.0, 9.0, 10.0.

Completed Odoo Functional and Technical Training.

Functional Areas:

  • CRM/Sales

  • Inventory

  • Manufacturing

  • Accounting

  • Purchasing

Major Skills:

  • Business Process Reengineering

  • Efficiency Consulting

  • User Needs and GAP Analysis;

  • Functional and Technical Design;

  • Prototyping and Proof of Concepts;

  • Requirements Specifications;

  • Agile Implementation;

  • Data Migration;

  • Configuration & Customization (UI and code);

  • Integration - Odoo and non Odoo Applications and Services;

  • Training and Knowledge Transfer;

  • Go Live Support;

  • Helpdesk;

  • Version Upgrades and Migration.

  • Accounting Expert.

I have over 20 years of experience empowering and enabling users with enterprise information systems that make a real and measurable difference in their ability to proactively manage their businesses and organizations. 

I am a skilled Communicator and I only take the serious things seriously!

Ray Carnes
On 1/8/14, 2:52 PM

You should export a record to see the structure of the CSV you need.

The MANDATORY fields you need for Supplier Info are:




You also need the product information.

A sample CSV that imports a new product with yourself as the Supplier would look like:

id                    your.xmlid
categ_id/id           product.product_category_all
cost_method           Standard Price
valuation             Periodical (manual)
name                  Name of Product
procure_method        Make to Stock
product_tmpl_id/id    {NULL}
type                  Stockable Product
uom_po_id/id          product.product_uom_unit
supply_method         Buy
uom_id/id             product.product_uom_unit
seller_ids/name/id    base.main_partner
seller_ids/delay      1
seller_ids/min_qty    1

Note: This file will work on runbot, the fields you need depend on your configuration choices.

I've uploaded a formatted CSV to http://www.filesnack.com/files/c7j075lj

Can you tell me where in the DB I can find the data that goes into seller_ids/name/id? I know the name of the partner but I do not know how to type it out so that OpenERP will recognize it.

EDIT:I imported it with base.main_partner and the name of our company appeared under "supplier" I typed it wrong in order to get an error and get the "all possible answers" prompt. After I found the company that I want I noticed it has "complete ID" and "record ID" aside from the name, gonna try with that.

EDIT2: using "completeID" for the specific company made the trick, thanks for all the help!

on 1/8/14, 3:39 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

0 follower(s)


Asked: 1/8/14, 12:38 PM
Seen: 1872 times
Last updated: 3/16/15, 8:10 AM