Odoo Help

Welcome!

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

0

how to import ORDER LINES in PURCHASE ORDER??

By
Alcaline
on 9/5/14, 10:02 PM 2,582 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

Your Answer

Please try to give a substantial answer. If you wanted to comment on the question or answer, just use the commenting tool. Please remember that you can always revise your answers - no need to answer the same question twice. Also, please don't forget to vote - it really helps to select the best questions and answers!

About This Community

This community is for professionals and enthusiasts of our products and services. Read Guidelines

Question tools

1 follower(s)

Stats

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