Odoo Help

Welcome!

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

1

dream for importing orders lines

By
opera
on 5/14/15, 5:22 AM 633 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

0
Thomas
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
date_order
picking_type_id/id stock.picking_type_in
location_id/id stock.stock_location_stock
partner_id/id __export__.res_partner_20092
minimum_planned_date
order_line/product_id/id __export__.product_product_303759 __export__.product_product_299806
order_line/date_planned
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
name
order_line/taxes_id/id __export__.account_tax_46 __export__.account_tax_46
0

michel Guénard

--michel Guénard--
1033
| 5 5 8
VIROFLAY, France
--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.

Your Answer

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

This community is for professionals and enthusiasts of our products and services. Read Guidelines

Question tools

2 follower(s)

Stats

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