Odoo Help

0

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

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

The Question has been closed

by
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/pricelist_ids/id

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?

Thanks

0

Ray Carnes

--Ray Carnes--
16818
| 9 7 9
Atlanta, United States
--Ray Carnes--

Senior Odoo Analyst

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

Completed Odoo Functional and Technical Training.

Major Skills:

  • 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:

https://bugs.launchpad.net/openobject-server/+bug/1194893

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.

Bista Solutions US, 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.

Bista Solutions US, 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.

Register

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)

Stats

Asked: 10/14/13, 8:28 AM
Seen: 1639 times
Last updated: 3/16/15, 8:10 AM