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 ?