Expected duration: Ongoing Project Overview: We are looking for a Python/Odoo developer to build a simple tool for our staff. The tool needs to read Purchase Orders (PDFs) sent by our customers and automatically create a Draft Sales Order in Odoo.
The Goal: Our staff should be able to drop a PDF into the tool (or a specific folder), and the system should extract the data and push it to Odoo.
Key Constraints:
No Monthly Fees: We do not want to use paid OCR subscriptions (like AWS or Google Cloud). You must use free/open-source Python libraries to read the text.
Windows Desktop: The tool must run on Windows 10/11 computers. It needs to be easy for non-technical staff to use (e.g., a simple .exe file).
Scope of Work:
Input: The tool accepts a PDF file. (PDFs from the same customer may come in 1, 2, 3, or 4 page formats)
Identify Customer: Determine which customer sent the file (e.g., by reading the filename or the header text).
Extract Data: specific fields need to be pulled:
PO Number
Date
Line Items (SKU, Quantity, Price)
Product Mapping: The tool must match the "Customer SKU" found on the PDF to our "Internal Product Reference" in Odoo.
Odoo Integration: Use the Odoo API to create the order.
Requirements:
The solution must be able to handle different PDF layouts for different customers (we can discuss how you want to handle this configuration).
