Skip to Content
Menu
This question has been flagged

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 ?

Avatar
Discard
Related Posts Replies Views Activity
0
May 23
1759
1
Sep 24
366
0
Jul 24
327
1
May 24
478
1
Nov 23
4379