Skip to Content
Menu
Musisz się zarejestrować, aby móc wchodzić w interakcje z tą społecznością.
To pytanie dostało ostrzeżenie
1 Odpowiedz
9509 Widoki

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

Awatar
Odrzuć
Najlepsza odpowiedź

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

Awatar
Odrzuć
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.

Powiązane posty Odpowiedzi Widoki Czynność
3
lip 19
6764
12
gru 23
39763
3
sie 25
969
5
wrz 25
23987
2
mar 24
4271