Odoo Help


dream for importing orders lines

on 5/14/15, 5:22 AM 1,166 views

odoo is a pain for importing purchase order mostly you only have a file with sku or ean13 quantity and price

i dream for a module who can handle that

open an order with customer or supplyer information

copy from a spreadsheet sku - quantity - price

past them into the order lines

verify and correct and validate

mostly yousr coworker give you a sreadsheet with their needs   they dont now the odoo internal id

it could be the same when a supplier send you a pricelist in excel or csv format

before with my 8sens software i could do that very simply

if someone has a simple solution to that he will be a saint

Thomas Guénard
On 7/10/16, 8:57 AM

below an example of my last imported PO (columns shown here as lines for clariy purposes)

<td align="left" sdnum="1036;0;@">2016-07-09 22:49:12 <td align="left" sdnum="1036;0;@">2016-07-10 <td align="left" sdnum="1036;0;@">2016-07-10 <td align="left" sdnum="1036;0;@">2016-07-10 <td align="left" sdnum="1036;0;@">07/10/4750
id __export__.purchase_order_7039
picking_type_id/id stock.picking_type_in
location_id/id stock.stock_location_stock
partner_id/id __export__.res_partner_20092
order_line/product_id/id __export__.product_product_303759 __export__.product_product_299806
order_line/name [K12] Guitare Admira Alba 1/2 [K18] GUITARE ADMIRA DIANA
order_line/price_unit 55.0 82
order_line/product_qty 3.0 1
order_line/product_uom/id product.product_uom_unit product.product_uom_unit
order_line/taxes_id/id __export__.account_tax_46 __export__.account_tax_46

michel Guénard

--michel Guénard--

| 5 5 8
--michel Guénard--

VP operations & finance Social entrepreneur Certified Public Accountant Past Chief internal auditor

michel Guénard
On 9/26/15, 1:52 PM

Looking forward to become a saint!

As far as I experienced it the steps are :

  1. Create products before anything else

  • create a product template with every information appropriate (name, internal reference,category, unit of measure, supplier, applicable tax etc...)

  • export this (template) product with all relevant information to a csv file(Utf-8/,).

  • open the csv file with openoffice or other spreadsheet software

  • add every products from your third party file with the same information as the ones from the template

  • delete the template line (first line)

  • delete the Id column

  • save the csv file(Utf-8/,)

  • import the file into Odoo

At this stage all the products are created.

Now, create a new order for the supplier

  1. The required supplier data must be available (namely minimum quantity (set to 1), email, fiscal status)

  2. create a new order for this supplier

  3. add one (first) product to be ordered

  4. save the order

  5. export the order (csv file(Utf-8/,)

  6. open the csv file(Utf-8/,)

  7. add every other products to be ordered

  8. Trick: the first line includes the reference to the order record; keep this line without change; the following lines corresponding to the added products SHALL NOT CONTAIN THESE DATA. ONLY PRODUCT DATA ARE NECESSARY

  9. SAVE THE csv file(Utf-8/,)

  10. IMPORT THE csv file(Utf-8/,)

This should do the job! Let me know.

About This Community

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


Odoo Training Center

Access to our E-learning platform and experience all Odoo Apps through learning videos, exercises and Quizz.

Test it now

Question tools

2 follower(s)


Asked: 5/14/15, 5:22 AM
Seen: 1166 times
Last updated: 7/10/16, 8:57 AM