Problems to Solve
Problems to Solve
Problem #61SourceRedditFriction Level: 8/10

Manual supplier price list reconciliation delays procurement decisions

1. The Problem — What is Difficult or Frustrating?
I have to spend a lot of time manually checking and updating supplier price lists to keep up with price changes.
2. Who Experiences It — The Affected Audience

Procurement professionals

3. The Proposed Tool — Specific Web App or Software Concept
A web application that automatically imports supplier price lists (PDF, CSV, Excel), maps them to internal product catalogs, and highlights real-time discrepancies against approved pricing tiers.
4. Core Features & Architecture
1.
Supplier Price List Importer

Drag-and-drop upload of supplier files (PDF, CSV, Excel) with automatic parsing and data extraction, including unit prices, discounts, and effective dates.

SolvesEliminates manual data entry and file conversion delays when updating supplier price lists.
2.
Internal Catalog Linker

Matches supplier products to internal product IDs using fuzzy matching (e.g., SKU, description, or UPC) and allows manual override for ambiguous matches.

SolvesRemoves the need to manually reconcile product names or codes between supplier and internal systems.
3.
Discrepancy Highlighter

Flags price changes, missing items, or tiered discounts that deviate from the internal approved pricing baseline, with a side-by-side comparison view.

SolvesReplaces manual spreadsheets and email chains used to track supplier price adjustments.
4.
Version History Tracker

Logs supplier price list versions, timestamps, and who approved internal updates, with a diff view to track changes over time.

SolvesEliminates reliance on shared folders or versioned filenames to track historical supplier price updates.
5. Potential Value — Operational Impact

Procurement teams regain weeks of time annually by eliminating manual price list reconciliation, allowing them to focus on negotiating contracts instead of chasing supplier updates.

Limitations & Technical Boundaries
Cannot resolve ambiguities in supplier data (e.g., mismatched product descriptions or missing SKUs) without human intervention, and requires initial setup to map supplier fields to internal catalogs.
6. Suggested Validation Questions (Not Researched Facts)

Suggested exploration questions to confirm real demand, alternatives, and willingness to pay before building:

  • Demand question: How frequently does manual supplier price list reconciliation consume a significant portion of your weekly procurement workload?
  • Possible existing alternatives to check: Tools like Coupa, Jaggaer, or SAP Ariba for procurement; Gap to test: whether these cover *automated PDF-to-spreadsheet parsing* for supplier price lists without manual mapping.
  • Willingness-to-pay question: What monthly subscription fee would feel fair to eliminate the need for manual supplier price list reconciliation entirely?
Technical Feasibility & Platform Terms Risk

Dependent on suppliers providing structured data exports (CSV/Excel) or requiring OCR accuracy for unstructured PDFs, which may vary by supplier.

🛠️ Technical Blueprint & Implementation Concept
Build a React‑based SPA with Material‑UI for drag‑and‑drop file upload and a side‑by‑side diff view. Use react‑dropzone for file handling, and display parsed tables with ag‑Grid. The backend runs on Python FastAPI, containerized with Docker. For PDF extraction, integrate pdfplumber and Tesseract OCR via pytesseract, feeding raw text into a custom parser that leverages the Camelot library for table detection. CSV/Excel files are read with pandas and openpyxl. After ingestion, store normalized rows in a DuckDB instance (embedded, zero‑config) to enable fast SQL diff queries. Product matching uses rapidfuzz for fuzzy string scoring combined with a pre‑computed Levenshtein distance matrix; SKU exact matches are prioritized. Expose a matching endpoint (/match) that returns candidate internal IDs with confidence scores, allowing the UI to present a modal for manual override. Discrepancy logic lives in a FastAPI route (/compare) that joins supplier rows to the internal catalog table, applies business rules (price tier thresholds, effective‑date windows) and returns JSON diff objects. Version history is persisted in PostgreSQL (hosted on RDS) with audit triggers; each upload creates a new version record linked to the DuckDB snapshot. Webhooks from the UI call /approve to mark a version as accepted, emitting a Kafka event for downstream ERP integration. Authentication uses OAuth2 with Keycloak, and all endpoints are protected via JWT. Deployment on Kubernetes with an NGINX ingress, using HorizontalPodAutoscaler to scale the OCR workers.
📊 The Limitations of Current Alternatives
Current workflows rely on ad‑hoc Excel diffing or manual copy‑paste from supplier PDFs, which forces procurement analysts to spend hours cleaning data, aligning columns, and hunting for mismatched SKUs. Enterprise suites like Coupa or SAP Ariba provide price‑rule enforcement but lack a built‑in PDF table extractor, so users still need separate OCR tools and custom scripts. Those platforms also charge per‑user licensing and require extensive configuration, making them overkill for mid‑size firms that only need automated reconciliation. The absence of a unified fuzzy‑match engine means teams must manually resolve every naming discrepancy, creating bottlenecks and error‑prone spreadsheets.
🎯 Key Engineering Value & Benefits
The tool eliminates repetitive data‑entry cycles, cutting the time to reconcile a supplier list from hours to minutes and ensuring price discrepancies are surfaced instantly. By leveraging DuckDB for in‑memory diff calculations, compute costs stay low, and the fuzzy‑match engine reduces human error in product mapping. Automated version tracking provides an auditable trail, supporting compliance without extra manual documentation, and the Kafka‑driven approval hook enables seamless downstream ERP updates, streamlining the entire procurement decision pipeline.
Relevant Platform Categories
Spreadsheets & Finance

Categories where this tool could be deployed or integrated.

Featured In Curated Collection

25 Tool Ideas for Cloud Reliability, DevOps & Compliance Ops

Part of the Problems 51–75 collection published on Sep 29, 2026.

View Full 25-Idea Collection
Explore More

Related Problems to Solve

Industry ForumProblem #10
Friction: 8/10

Automated Invoice Accuracy and Compliance Verification for Accounting Teams

The Problem

Automating tedious invoice verification tasks, such as manually verifying invoices for accuracy and compliance with accounting standards

Audience:Accounting clerks, finance analysts, and accounts payable specialists
Proposed Tool:

A web application that ingests invoices from email attachments, cloud storage, or ERP exports, then automatically flags discrepancies against configurable validation rules (e.g., line-item mismatches, tax code errors, approval thresholds) and generates compliance-ready reports.

Industry ForumProblem #14
Friction: 9/10

Manual handling of repetitive file and data tasks in office workflows

The Problem

Individuals and office workers waste hours performing repetitive, manual tasks like file renaming, data extraction from PDFs, and spreadsheet updates because they lack accessible automation tools.

Audience:Office workers, administrative staff, and finance professionals
Proposed Tool:

A web application that offers a drag-and-drop interface for office workers to define and execute automated workflows for file renaming, PDF data extraction, and spreadsheet updates using pre-built templates and natural language prompts.

YouTubeProblem #21
Friction: 8/10

Manual Data Transfer Between Spreadsheets Creates Repetitive Work

The Problem

Users waste considerable time manually copying and pasting data between multiple spreadsheets because they lack simple automated data syncing solutions.

Audience:Finance analysts, data entry clerks, and small business owners
Proposed Tool:

A web application that automates rule-based data copying and pasting between spreadsheets using a point-and-click interface, with real-time preview and error handling.