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..
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.
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
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
|Asked: 9/5/14, 10:02 PM|
|Seen: 2254 times|
|Last updated: 8/9/15, 3:02 AM|