Data export via Import/Export did not completely match our needs. I have to Import the purchase price. Where is this value stored ?
Odoo is the world's easiest all-in-one management software.
It includes hundreds of business apps:
- CRM
- e-Commerce
- Kế toán
- Tồn kho
- PoS
- Project
- MRP
Câu hỏi này đã bị gắn cờ
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.
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 ..
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.
Bạn có hứng thú với cuộc thảo luận không? Đừng chỉ đọc, hãy tham gia nhé!
Tạo tài khoản ngay hôm nay để tận hưởng các tính năng độc đáo và tham gia cộng đồng tuyệt vời của chúng tôi!
Đăng kýBài viết liên quan | Trả lời | Lượt xem | Hoạt động | |
---|---|---|---|---|
|
3
thg 7 19
|
6460 | ||
|
12
thg 12 23
|
39247 | ||
|
2
thg 5 25
|
646 | ||
|
5
thg 10 23
|
23329 | ||
Import Products by SKU
Đã xử lý
|
|
2
thg 3 24
|
2639 |