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.

0

Import sale order and delivery order

By
TK Fontaine
on 1/20/16, 10:47 AM 566 views

Hello,

I would like to import using csv a sale order(sale.order) and the delivery order(stock.picking) linked.
I tried to External ID, but I wasn't able to link both.

For example, I used :

Sale Order : 

External ID;partner_invoice_id/id;partner_shipping_id/id;partner_id/id;date_order;warehouse_id/id;pricelist_id/id;order_line/id;order_line/product_id/id;order_line/name;order_line/customer_lead;order_line/price_unit;order_line/product_uom_qty;order_line/product_uom/id

vente_3;base.res_partner_address_3;base.res_partner_address_3;base.res_partner_address_3;2016-01-21 00:00:00;stock.warehouse0;__export__.product_pricelist_3;__export__.sale_order_line_63;product.product_product_6;[A1232] iPad Mini;7.0;320.0;1.0;product.product_uom_unit

;;;;;;;__export__.sale_order_line_64;product.product_product_53;[TDKEY1] TypeMatrix Dvorak Keyboard;7.0;3000.0;1.0;product.product_uom_unit

Stock Picking:

External ID;Related/External ID;location_dest_id/id;move_type;priority;company_id/id;location_id/id;picking_type_id/id;move_lines_related/product_id/id;move_lines_related/date;move_lines_related/date_expected;move_lines_related/name;move_lines_related/location_dest_id/id;move_lines_related/location_id/id;move_lines_related/procure_method;move_lines_related/product_uom_qty;move_lines_related/company_id/id;move_lines_related/product_uom/id

BL_2;vente_3;stock.stock_location_customers;Partiel;Normal;base.main_company;stock.stock_location_stock;stock.picking_type_out;product.product_product_6;2016-01-21 00:00:00;2016-01-27 00:00:00;[A1232] iPad Mini;stock.stock_location_customers;stock.stock_location_stock;Par défaut : prendre dans le stock;1.0;base.main_company;product.product_uom_unit

;;;;;;;;product.product_product_53;2016-01-21 00:00:00;2016-01-27 00:00:00;[TDKEY1] TypeMatrix Dvorak Keyboard;stock.stock_location_customers;stock.stock_location_stock;Par défaut : prendre dans le stock;1.0;base.main_company;product.product_uom_unit


How could I link both ?

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

1 follower(s)

Stats

Asked: 1/20/16, 10:47 AM
Seen: 566 times
Last updated: 1/20/16, 11:09 AM