Odoo Help


CSV Import Unable to import Supplier Part Code and Description [Closed]

John Peverall
on 10/14/13, 8:28 AM 1,924 views

The Question has been closed

Ray Carnes
on 10/18/2013 16:19:57

Created 2 product records manually then exported them, results as follows:

seller_ids/id __export__.product_supplierinfo_8, __export__.product_supplierinfo_8 seller_ids/company_id/id
seller_ids/delay 105, 105 seller_ids/min_qty
seller_ids/sequence 1,1

seller_ids/name/id __export__.product_supplierinfo_333_8, __export__.product_supplierinfo_333_9


seller_ids/product_code prod code1, prod code2 seller_ids/product_name prod desc1, prod desc2

Now if add further products from the same supplier I replicate seller_ids/id and seller_ids/sequence but as supplierinfo record does not exist what value do I assign to seller_ids/name/id?

When I try to import input file validates OK but none new product's supplier information is created nor existing product's information updated.

Could anyone explain procedure for adding supplier info to a product as it is too much of a task to do manually?



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 and 11.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 10/14/13, 7:05 PM

Please fix the export bug and try again:


product_supplierinfo_333_8 is evidence of this bug. It should be product_supplierinfo_[A SINGLE NUMBER]

Thanks for your assistance. Assume I install bzr branch lp:~therp-nl/openobject-server/7.0-lp1194893-export_xmlid_wrong_table_name, yes?

John Peverall
on 10/16/13, 9:57 AM

Yes. Since it is a change to three lines in one file, I made a diff and use that to patch.

Ray Carnes
on 10/16/13, 5:48 PM

Have fixed bug as suggested export data now shows seller_ids/name/id as __export__.res_partner_333. However I still get the validate error on import file as seller_ids/id (product_supplierinfo_XX) for new seller info is unknown until that record created. I have tried leaving blank and also as manually entered supplier info increments by 1 I have tried incrementing the last id. Both fail. What is the correct way to add new supplier info via CSV import?

John Peverall
on 10/17/13, 7:42 AM

Did you try importing the suppliers first? OpenERP is unable to create supplier information for products if the suppliers don't first exist in the system - there is nothing to link to.

Ray Carnes
on 10/17/13, 6:04 PM

I did have suppliers set up first. Resolved problem in that I was leaving seller_ids/name/id (Supplier / Supplier / External ID) blank for new records whereas there should be no column at all. Incidentally I also deleted other _export fields bar Product Category and Supplier. I assume the other _export fields are needed for update to avoid insert of new records. Thanks for your help.

John Peverall
on 10/18/13, 10:31 AM

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: 10/14/13, 8:28 AM
Seen: 1924 times
Last updated: 3/16/15, 8:10 AM