This question has been flagged
2 Replies
3919 Views
excelpurchase_orderimportingpricelistodoo
Avatar
opera

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

Avatar
Discard
Avatar
Thomas Guénard
Best Answer

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
Avatar
Discard
Avatar
michel Guénard
Best Answer

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.

Avatar
Discard