Odoo Help

Welcome!

This community 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.

0

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

By
John Peverall
on 10/14/13, 8:28 AM 1,461 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--
15717
| 9 7 9
Greater Los Angeles, United States
--Ray Carnes--

Senior Odoo Analyst

OpenERP 6.1, 7.0 and Odoo 8.0, 9.0 (Since 2012)

Completed Functional and Technical Training.

Major Skills:

  • Needs Discovery and Requirements Analysis;

  • Function and Technical Specifications;

  • Project Planning;

  • Prototyping and Proof of concepts;

  • Data migration;

  • Configuration & Customization (UI and modules);

  • Integration - data, business logic and service levels;

  • Training and Knowledge transfer;

  • Go Live support;

  • Help desk;

  • Version Migration.

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. 

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 community is for professionals and enthusiasts of our products and services. Read Guidelines

Question tools

0 follower(s)

Stats

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