To import Purchase Orders, you first need a CSV or Excel file prepared with the required information. Each row in the file should represent one product line in a Purchase Order.<\/p>\n\n\n\n
- \n
- partner_id<\/strong>: Vendor name. This must exactly match an existing vendor in the system.<\/li>\n\n\n\n
- partner_ref<\/strong>: Vendor reference number (optional). Appears as the bill number in the Goods Receipt (GR) Bill.<\/li>\n\n\n\n
- date_order<\/strong>: Purchase Order date in the format
YYYY-MM-DD<\/code>. Must be today or a future date.<\/li>\n\n\n\n- order_line\/product_id<\/strong>: Product code. Must match an existing product in the system.<\/li>\n\n\n\n
- order_line\/mrp<\/strong>: Maximum Retail Price (MRP), tax-inclusive. Used for markup and markdown calculations.<\/li>\n\n\n\n
- order_line\/product_qty<\/strong>: Quantity to be ordered. Decimal values are allowed only for “No Tracking” products.<\/li>\n\n\n\n
- order_line\/price_unit<\/strong>: Basic Cost (before tax and discount). This is the vendor’s base price.<\/li>\n\n\n\n
- order_line\/discount<\/strong>: Discount percentage on the basic cost. Must be between 0 and 100.<\/li>\n<\/ul>\n\n\n\n
![\"Odoo](\"https:\/\/tenthplanet.in\/odoo\/wp-content\/uploads\/sites\/8\/2025\/11\/Tenth-Planet-Odoo-Purchase-Purchase-Order-Excel-file.png\")
<\/figure>\n\n\n\nOnce the file is ready, you can import it by going to the Purchase module and clicking the Actions icon. From there, choose the \u201cImport record\u201d option and upload your file. Odoo will display a mapping screen where you must ensure that your column headers are correctly matched with the system\u2019s fields, such as Vendor, Vendor Reference, PO Date, Product, MRP, Quantity, Basic Cost, and Discount.<\/p>\n\n\n\n
![\"Odoo](\"https:\/\/tenthplanet.in\/odoo\/wp-content\/uploads\/sites\/8\/2025\/11\/Tenth-Planet-Odoo-Purchase-Import-Purchase-Order.png\")
<\/figure>\n\n\n\nBefore saving anything, it is best to click the \u201cTest<\/strong>\u201d button to let Odoo validate the data. If there are any issues, Odoo will show error messages so you can correct your file. After validation succeeds, clicking \u201cImport<\/strong>\u201d will create the Purchase Orders in the system automatically.<\/p>\n\n\n\n
![\"Odoo](\"https:\/\/tenthplanet.in\/odoo\/wp-content\/uploads\/sites\/8\/2025\/11\/Tenth-Planet-Odoo-Purchase-Purchase-Order-from-Import-1024x467.png\")
<\/figure>\n\n\n\nExporting Purchase Orders<\/strong><\/h2>\n\n\n\n
Exporting Purchase Orders in Odoo is also very simple. Start by opening the Purchase module and selecting the Purchase Orders menu. You can use filters and grouping options to organize the data in the way you want, for example, by vendor, status, date range, or buyer. Once your report view looks right, click the Actions icon and choose \u201cExport All.\u201d Odoo will download the data as an Excel file, which you can use for analysis.<\/p>\n\n\n\n
![\"Odoo](\"https:\/\/tenthplanet.in\/odoo\/wp-content\/uploads\/sites\/8\/2025\/11\/Tenth-Planet-Odoo-Purchase-Export-Purchase-Orders-1024x344.png\")
<\/figure>\n\n\n\nDetails Included in the Exported File<\/strong><\/h2>\n\n\n\n
When you open the exported Excel file, you\u2019ll see key information such as the company name, report date range, the user who exported it, and the timestamp. The file also contains important PO details like priority, PO reference, confirmation date, vendor, buyer, order deadline, and order status. <\/p>\n\n\n\n
It shows the source document, total amount, currency, and billing status, which can be \u201cNothing to Bill,\u201d \u201cWaiting Bill,\u201d or \u201cFully Billed.\u201d Arrival and expected arrival dates are also included. These details make the exported report helpful for quick review, tracking, and analysis.<\/p>\n\n\n\n
![\"Odoo](\"https:\/\/tenthplanet.in\/odoo\/wp-content\/uploads\/sites\/8\/2025\/11\/Tenth-Planet-Odoo-Purchase-Details-in-Exported-PO-1024x439.png\")
<\/figure>\n","protected":false},"excerpt":{"rendered":"Managing Purchase Orders efficiently is important for smooth operations, especially when working with large volumes of data. Odoo allows users […]<\/p>\n","protected":false},"author":21,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[383],"tags":[583,582,459],"class_list":["post-33569","post","type-post","status-publish","format-standard","hentry","category-purchase","tag-export-purchase-order","tag-import-purchase-order","tag-purchase"],"acf":[],"_links":{"self":[{"href":"https:\/\/tenthplanet.in\/odoo\/wp-json\/wp\/v2\/posts\/33569","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/tenthplanet.in\/odoo\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/tenthplanet.in\/odoo\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/tenthplanet.in\/odoo\/wp-json\/wp\/v2\/users\/21"}],"replies":[{"embeddable":true,"href":"https:\/\/tenthplanet.in\/odoo\/wp-json\/wp\/v2\/comments?post=33569"}],"version-history":[{"count":0,"href":"https:\/\/tenthplanet.in\/odoo\/wp-json\/wp\/v2\/posts\/33569\/revisions"}],"wp:attachment":[{"href":"https:\/\/tenthplanet.in\/odoo\/wp-json\/wp\/v2\/media?parent=33569"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/tenthplanet.in\/odoo\/wp-json\/wp\/v2\/categories?post=33569"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/tenthplanet.in\/odoo\/wp-json\/wp\/v2\/tags?post=33569"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}
- partner_ref<\/strong>: Vendor reference number (optional). Appears as the bill number in the Goods Receipt (GR) Bill.<\/li>\n\n\n\n