This question has been flagged
1 Reply
7846 Views

Data export via Import/Export did not completely match our needs. I have to Import the purchase price. Where is this value stored ?

Avatar
Discard
Best Answer

In table product.template you have 2 price fields: lista_price (sale price) & standard_price (cost)

also, in table product.product you have other_price field ...

Avatar
Discard
Author

Thank you for your help. Import was succesful with over 2000 products. You need patience and time.

Hi Dotz. Thank you for asking and your notice it works now for you. Will you make a deatailed description of how you did it all. A lot of people will be happy with this. Including me!

@Dotz: please mark question answered :) @12907 : 2 possibe ways to import: -1- via Import/Export , with carefuly prepared csv file, or -2- via sql importing directly into database,

  • 1- is recomended for beginer, slower but safe mathod, -2- would be for expert users , much faster, but requires good understanding of relations between tables , not to mention sql tools etc...

I am interested in how to carefully prepare csv file. Can this be done by a non programmer without guidance? Please give a guide in an answer and we can give you Karma by voting on your guide.

http://help.openerp.com/question/5200/required-csv-import-fields-and-template-of-csv-files/

  • take a look here, i'm not able to post link but try searching this site for keywords import, csv ..
Author

I did most of the work with MS Excel and MS Access. Also I installed a postgres client to have a closer look to the table structure of the involved tables. In the moment I am writing a script with autoit to make import of products easier. If anyone can help me in uploading the source code, I make it public. Or how can I post a tutorial ?

You can best post the tutorial as an answer on this question.