Odoo Automation: Convert PDF Purchase Orders to Sales Orders

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).

Budget: GBP 6/hour

Proposals: 11 freelancers have applied