Siirry sisältöön
Sinun on rekisteröidyttävä, jotta voit olla vuorovaikutuksessa yhteisön kanssa.
Kaikki kirjoitukset Ihmiset Merkit
Tunnisteet (Näytä kaikki)
odoo accounting v14 pos v15
Tietoa tästä foorumista
Tämä kysymys on merkitty
importingsales.order
4 Vastaukset
8125 Näkymät
Avatar
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  

Avatar
Hylkää
Avatar
Ashish Singh
Paras vastaus

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
12250150156

10010158

501520

20521

  • 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,


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
Avatar
Hylkää
Abdulmonem
Tekijä

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

<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

Abdulmonem
Tekijä

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

Avatar
Mindaugas
Paras vastaus
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
Avatar
Hylkää
Abdulmonem
Tekijä

Thank you Mindaugas

Mindaugas

welcome, hope it helps

Abdulmonem
Tekijä

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

Aiheeseen liittyviä artikkeleita Vastaukset Näkymät Toimenpide
Import SO Line with Section - V12 Ratkaistu
importing sales.order sections
Avatar
Avatar
1
lokak. 19
5038
V17 .sh import excel file: time data '2025-01-31' does not match format '%m.%d.%Y'
importing
Avatar
Avatar
Avatar
3
heinäk. 25
3220
Odoo journal entry modification after posting by import
importing
Avatar
Avatar
1
huhtik. 25
2402
Transform Quotations to sales orders or invoices in a bulk action
sales.order
Avatar
Avatar
Avatar
3
helmik. 25
3371
Import Sales Orders Status Ratkaistu
import excel importing sales.order
Avatar
Avatar
Avatar
2
marrask. 24
2025