Hi everyone,
I’m currently working on importing Vendor Purchase Orders into Odoo from an Excel file for clients in the food industry.
In this case, they regularly purchase ingredients from suppliers, and these lists often come from Excel files provided by the supplier. We would like to import these files directly into Odoo to generate purchase orders with multiple lines.
However, we want to make sure that during the import:
1. Odoo recognizes the existing vendor and does not create a duplicate.
2. Odoo matches existing products (ingredients) instead of creating new ones.
3. The purchase order lines are correctly attached to the purchase order.
Could someone clarify which columns are required or recommended in the Excel import to ensure proper matching?
For example:
- For the vendor, is it better to use the Name, ID, or External ID?
- For the products, should we use Internal Reference, Barcode, Name, or External ID to avoid duplicates?
- Are there any best practices when importing purchase orders with multiple lines?
If anyone has a sample import template for purchase orders, that would also be very helpful.
Thank you very much for your help!
Hello,
It is best practice to use the External ID for the vendor and the External ID for the existing products in the order lines. This ensures Odoo matches the existing records perfectly without creating duplicates.
Let me know if you need assistance regarding this
Thanks
info@codespheretech.in
Hi,
Yes, this is possible using Odoo’s standard Purchase Order import functionality, but using the correct identifiers is important to avoid duplicates.
A few best practices:
Vendor Matching
You can use Vendor Name if it is unique in the system.
For more reliable matching, it is recommended to use External ID or Database ID.
Product Matching
The most reliable field is Internal Reference (Default Code).
Alternatively, Barcode or External ID can also be used.
Using the Product Name may work but can sometimes create duplicates if names vary.
Purchase Order with Multiple Lines
Each row in the Excel file represents a purchase order line.
Use the same Purchase Order reference/number for rows that belong to the same PO.
Include fields like:
Order Reference
Vendor
Order Date
Product
Quantity
Unit Price
A good approach is to first export a sample Purchase Order from Odoo and use that structure as your import template.
Hope this works for you! Feel free to reach out for further discussion.
Regards,
Zehntech Technologies Inc.
santosh.sekwadia@zehntech.com