I want to import into Odoo 13 CE certain data from approximately 800 purchase orders we created in Odoo 12 EE, but have failed at multiple attempts spanning many hours, using various combinations of fields and file formats.
I have a good amount of experience importing data into various editions of Odoo, beginning with Odoo 10, including imports of contacts, products, sales orders, purchase orders, and bank data.
Our goal is to import the following purchase order data into Odoo 13 CE, resulting in the imported POs being in draft RFQ state, ready for confirmation:
Order Reference (the "PO number")
Order Date
Vendor
Vendor Reference, if applicable
Source Document, if applicable
Notes, if applicable
Order Line data as follows (may span multiple order lines)
Product
Scheduled Date
Quantity
Unit Price
In Odoo 13 CE I have already managed to import thousands of contacts and sales orders from Odoo 12 EE, as well as the needed products. I have also managed to import all of the non-order-line data for our purchase orders. It is the order-line-data import that is proving to be an intractable problem.
I have reviewed the required fields in the Purchase Order Line model, of which there are four:
name
order_id
price_unit
product_qty
Of these four, I suspect that I may not be providing the correct "order_id" data for the order lines, but I cannot find among available export fields in the Odoo 12 EE data what that data might be. It does not appear to be the "External ID" for the order line, even though Odoo 12 EE and Odoo 13 CE both generate such external IDs.
I would appreciate knowing, if possible, exactly which fields I should export from Odoo 12 EE in order to fill in the purchase-order-line data in Odoo 13 CE. Thank you.
