Odoo Help


Import Products with supplier and purchase price

on 2/20/13, 5:10 AM 4,211 views

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




| 5 4 6
Zagreb | Karlovac, Croatia

there is only 10 kind of people the ones that understand binary ... and others

On 2/20/13, 9:44 PM

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

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

on 3/14/13, 3:52 AM

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!

on 3/27/13, 3:57 PM

@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...
on 3/28/13, 4:06 PM

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.

on 3/28/13, 8:00 PM


  • take a look here, i'm not able to post link but try searching this site for keywords import, csv ..
on 3/28/13, 8:13 PM

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 ?

on 4/1/13, 6:36 AM

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

on 4/2/13, 4:43 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: 2/20/13, 5:10 AM
Seen: 4211 times
Last updated: 3/16/15, 8:10 AM