Ir al contenido
Menú
Se marcó esta pregunta
1 Responder
9337 Vistas

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

Avatar
Descartar
Mejor respuesta

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
Descartar
Autor

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

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.

Publicaciones relacionadas Respuestas Vistas Actividad
3
jul 19
6589
12
dic 23
39485
2
may 25
777
5
oct 23
23590
2
mar 24
3398