Odoo is the world's easiest all-in-one management software.
It includes hundreds of business apps:

CRM
e-Commerce
会計
在庫
PoS
プロジェクト
MRP

All apps

全てのポスト人々バッジ

タグ (全て表示)

odoo accounting v14 pos v15

このフォーラムについて

ヘルプ

Sale order / Quotation import multiple items

importing sales.order

4 返信

8075 ビュー

Abdulmonem

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

Ashish Singh

最善の回答

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,
- Order Lines / Product / Database ID
- Order Lines / Quantity
- Order Lines / Unit Price
- Customer / Database ID
For more info please refer to the below screenshot,
- https://prnt.sc/rdjh7u

Hope above solution will fix your issues. In case you still have the same issue then you can share your CSV.

Thanks,

Ashish Singh (Team Lead)

Webkul Software Private Limited

Abdulmonem

著作者

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

Ashish Singh

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

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

Abdulmonem

著作者

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

Ashish Singh

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 -

https://www.google.com/search?q=webkul&oq=webkul+&aqs=chrome..69i57j69i60l3j0l2.4182j0j7&sourceid=chrome&ie=UTF-8#lrd=0x390ce561c5555555:0xcfb40ae166ce6c21,1

Thanks

Ashish Singh

Mindaugas

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

Abdulmonem

著作者

Thank you Mindaugas

Mindaugas

welcome, hope it helps

Abdulmonem

著作者

Sure it helps mistake that I was repeating Order reference number for each line on CSV file

Best Regrades

Abdulmonem

Mindaugas

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).

ディスカッションを楽しんでいますか？読むだけでなく、参加しましょう！

今すぐアカウントを作成して、限定機能を利用したり、素晴らしいコミュニティと交流しましょう！

登録

関連投稿	返信	ビュー
Import SO Line with Section - V12 解決済 importing sales.order sections	1 10月 19	4996
V17 .sh import excel file: time data '2025-01-31' does not match format '%m.%d.%Y' importing	3 7月 25	3171
Odoo journal entry modification after posting by import importing	1 4月 25	2363
Transform Quotations to sales orders or invoices in a bulk action sales.order	3 2月 25	3307
Import Sales Orders Status 解決済 import excel importing sales.order	2 11月 24	1997