Hey there! You’re dealing with a pretty common issue in the ERP world with Odoo. It’s frustrating to create new products from vendor invoices - especially dealing with PDFs. Converting them to Excel or CSV for Odoo import can be error-prone like you've experienced.

In your case, maybe consider a custom development for your Odoo instance. Odoo’s super customizable, so you can have a developer make a module that reads these PDFs directly. OCR tech can be a big help. Integrating an OCR solution that extracts straight from your PDFs and links to your Odoo product database could automatically create new product records.

You’re gonna need a developer who gets both Odoo’s API and whatever OCR service you choose. It’s a bit of an upfront investment, sure, but long-term it should boost speed and cut down on mistakes. Remember to train your team on how this works; they might run into minor hiccups the first couple times.

If custom dev feels like a mountain to climb, there's Plan B - using an app to handle invoice processing with Zapier or Integromat (Make.com) automating data flows. They can parse PDFs and push info into Odoo. Might not be a perfect fit but definitely a quick win if done right.

Honestly, the best path depends on the resources you’ve got. Both options offer a big upgrade over manual CSVs. If you wanna dig deeper into the custom module route or need more specifics on OCR integration, just shout out!

Hello Thomas Guenard,

You can import xlsx or CSV files when selecting the option for
"When a value cannot be matched ==> Create new values."

if you select "create new values" to create a product in odoo when importing the file.

I hope this will help you.

Thanks & Regards,
Email: odoo@aktivsoftware.com
Skype: kalpeshmaheshwari

Another option could be to use an optical character recognition (OCR) tool to extract data from the PDF invoices and then use that data to create new products in Odoo. This will be faster than manual data entry and less prone to errors compared to importing data from a CSV or Excel file.

You can also look into third-party apps available in the Odoo App Store that can assist with this process.

It is important to thoroughly test any custom development or third-party apps before implementing them in your production environment to ensure they meet your business needs and do not cause any unintended consequences.