Automate Sage 50 Order Import

Customer: AI | Published: 29.10.2025
Бюджет: 250 $

I export my sales orders from Sage 50 Quantum as PDFs and then spend far too long copying the data into a master XLSX workbook. I want a small application or script that will do this import for me. Here’s what I need it to handle: • Read the PDF generated by Sage 50 Quantum, detect each line item, and map quantity, SKU, description, and price to matching columns in my existing XLSX order workbook. • Distinguish SKUs by both their numbers and embedded colour codes; some SKUs are not exact matches, so the tool must let me “teach” it new variations over time. • Whenever the program cannot recognise a SKU, it should automatically flag the line for manual review rather than guessing. • A simple way for me to maintain or extend the SKU-matching rules (spreadsheet lookup, editable config file, or a quick in-app form—whichever keeps maintenance easy). • Clear, step-by-step setup notes so I can run the import on demand without calling a developer each time. A lightweight solution in Python, VBA, or another mainstream language is fine as long as it works reliably on Windows and keeps my current XLSX format intact. Deliverables are: 1. A working executable or script with source code. 2. The editable SKU-mapping component. 3. Installation / usage guide and a quick hand-off session (screen share or concise video). If you have experience parsing PDFs, automating Excel, or integrating with Sage 50 data, I’d love to see examples. Let’s streamline this workflow together!