Odoo Help

0

how to import ORDER LINES in PURCHASE ORDER??

By
Alcaline
on 9/5/14, 10:02 PM 3,576 views

I have to import data in version 7 but when i'm importing data in the purchase order there is an error occur regarding the Order lines. How can i import the data without recieveing and error? Any help Please..
 

1
samba
On 9/6/14, 12:21 AM

Lee,

If you want to import order lines in PO, you have to add "order_line/product_id/id" field to your sheet and give product ids in this column. For example order1 has 3 order lines. in id column add unique id to that order and add these 3 product ids in "order_line/product_id/id" in adjescent rows. i.e you have to use 3 rows for one order, in first row under "id" column give id of order and in "order_line/product_id/id" column first product id, Give next product id in next row of column "order_line/product_id/id". Like this you can add any number of order lines to one order. If you want to add another order add unique order id in "id" column and proceed the above process to add order lines. I hope this will help you Lee. Good luck.

 

thanks samba:)

Alcaline
on 9/7/14, 9:03 PM
0
Mayur Maheshwari
On 8/9/15, 3:02 AM

To order line from csv, You can check HERE

Hope it Helps to you

0
Michel Hugues
On 9/7/14, 5:17 PM

On test DB, create a purchase order, export to csv, open it with spreadsheet.

To test, edit data and import the csv file

Example csv file, it works on my server:

Order Date,Supplier Reference,Supplier,location_id/id,pricelist_id/id,Order Lines / Product,Order Lines / Description,Order Lines / Quantity,Order Lines / Unit Price,Order Lines / Taxes,Order Lines / Scheduled Date
2014-1-11,Supplier_Reference1,Valid_Supplier-1,stock.stock_location_stock,purchase.list0,,,,,,
,,,,,Valid_Item-1,Valid_Item-1,500.00,3.50,Valid_Tax,2014-1-11
,,,,,Valid_Item-2,Valid_Item-2,1000.00,3.50,Valid_Tax,2014-1-11
2014-1-20,Supplier_Reference2,Valid_Supplier-1,stock.stock_location_stock,purchase.list0,,,,,,
,,,,,Valid_Item-3,Valid_Item-3,350.00,3.50,Valid_Tax,2014-1-20

thanks michel.

Alcaline
on 9/7/14, 9:04 PM

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.

Register

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

1 follower(s)

Stats

Asked: 9/5/14, 10:02 PM
Seen: 3576 times
Last updated: 8/9/15, 3:02 AM