The module named "VKS Import Excel" can help you solve this problem easily: https://apps.odoo.com/apps/modules/16.0/vks_import_excel.

Please contact me via email anhtuan.acoi@gmail.com if you need further assistance.

Per the Odoo assistance I am informed that "importing purchase orders, will require a product name, with a product ID is not possible."

This is an issue as it will create duplicates of products if the name is even slightly different from was is in your db

Hi, you can follow https://youtu.be/SgFmOD9Q2S4?si=46y7nPM_rumGs9NU

I hope it helps, thanks

There is no direct solution for it but you can do this using the create value at runtime import of the record.

For one-time export the purchase order template xlsx or CSV file according to your needed fields

Second, suppose you have vendors that are not predefined in your system and there are products also not predefined in the system so while importing there are three options given if your value does not match with the system record select create new value so according to that your vendor are created and also your product are created then after only you update your things that remaining in both fields.

If this is useful for you then please first check and test in the testing database
Hope it will be useful for you.