Odoo is the world's easiest all-in-one management software.
It includes hundreds of business apps:
Hi,
Odoo V13
I Would like to know how to import sales order or quotation with multiple lines / products.
When I added multiple products on the same CSV file it created multiple Sale order for each product.
I tried to add the sales order number (reference ) the result was duplicating the sales order number and each order has one product from the list
Regards,
Abdulmonem
Hi, Abdulmonem
It seems you are placing wrong columns in your CSV. Please refer to the below lines of the CSV in order to prepare order with the multiple lines,
| partner_id | order_line/price_unit | order_line/product_uom_qty | order_line/product_id/id |
| 12 | 250 | 150 | 156 |
| 100 | 10 | 158 | |
| 50 | 15 | 20 | |
| 20 | 5 | 21 |
Then you can simply upload that CSV.
And make sure below columns will be selected inside import table,
For more info please refer to the below screenshot,
Hope above solution will fix your issues. In case you still have the same issue then you can share your CSV.
Dear Ashish,
Thank you for comment the issue is from where i can get the partner ID to replace it with partner name
Thank you
Abdulmonem
Hi, Abdulmonem
From user interface by default id is not visible inside the view but you can inherit the tree view and add below line
<field name="id"/>
Or when you open any record the id is visible inside the Url.
But you can achieve the same thing by placing exact partner name instead of partner id.
Thanks
Ashish Singh
Hi Ashish,
Thank you for you help I reviewed me CSV file I notice that the mistake that I was repeating Order reference number for each line on CSV file
Best Regrades
Abdulmonem
Hi Abdulmonem
It's great that your issue is resolved. If you liked my assistance then I would really appreciate if you can take out a few minutes out of your busy schedule and put a google review for us here -
Thanks
Ashish Singh
| Order reference | Delivery Date | Customer | Salesperson | Order Lines / Product | Order Lines / Description | Order Lines / Unit Price | Order Lines / Quantity |
| SO-2020-000038 | 2020-01-08 10:00:00 | customer aaa | Administrator | 5555666 | 5555666 | 4,50 | 100 |
| 444777 | 5555666 | 9,00 | 120 |
Thank you Mindaugas
welcome, hope it helps
Sure it helps mistake that I was repeating Order reference number for each line on CSV file
Best Regrades
Abdulmonem
in odoo basically-all import when it have header and line structure will be quite the same (bom, contact with contacts and etc, PO is different case).
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 | |
|---|---|---|---|---|
|
Import SO Line with Section - V12
Đã xử lý
|
|
1
thg 10 19
|
4995 | |
|
3
thg 7 25
|
3171 | ||
|
1
thg 4 25
|
2363 | ||
|
3
thg 2 25
|
3307 | ||
|
Import Sales Orders Status
Đã xử lý
|
|
2
thg 11 24
|
1997 |
1. Use the live chat to ask your questions.
2. The operator answers within a few minutes.
