How I Built a Full‑Cycle Procurement Management System in 2 Hours

Problem Overview

Many companies keep procurement information in separate silos: requests in Excel, supplier quotes in WhatsApp, orders in another sheet, delivery status by phone, and payment confirmation with finance. This fragmentation makes it impossible to answer basic questions such as “What are the current purchase demands?” or “Which suppliers are at risk?” quickly.

Step 1 – Unified Purchase Request

By creating a single purchase‑request form that captures department, requester, product name, specifications, quantity, required date, estimated amount, and usage scenario, the request automatically flows from the applicant to the department head and then to the purchasing team.

Standardised entry point for all demands.

Automatic approval routing.

Historical records searchable.

Purchase tasks generated automatically.

Result: Previously, “who asked for it, why, when, and whether the quantity was reasonable” were unknown; now they are recorded and visible.

Step 2 – Supplier Management

Many SMEs store supplier information in personal WeChat contacts, personal Excel files, or phone address books, leading to loss of data when a purchaser leaves. The solution builds a supplier database that records basic information (name, contact, product range, settlement method) and transactional data (historical quotes, deal prices, delivery cycles, quality records).

When evaluating a supplier, the system can show concrete metrics such as “96% on‑time delivery in the past six months” instead of relying on personal relationships.

Step 3 – Online Quotation & Price Tracking

A quotation table records product details, supplier quote, quote date, historical price, and final deal price. The system automatically calculates price changes, e.g., “last year the part cost ¥50, this year the quote is ¥65 – a 30% increase.” This turns price negotiations from intuition‑based to data‑driven.

Step 4 – Purchase Order Management

An order‑management table stores order number, supplier, product details, quantity, unit price, delivery date, and current status (pending, in production, awaiting shipment, arrived, completed). Real‑time status updates let managers see which orders are normal and which are delayed without opening dozens of Excel files.

Step 5 – Receiving & Inventory Integration

After delivery, the warehouse records actual received quantity, inspection result, and inbound details. The system automatically updates inventory, order status, and generates inbound records, ensuring that purchasing, warehouse, and finance all see the same data.

Step 6 – Payment Management Closure

A payment‑management table links purchase orders, inbound records, and invoice information, automatically summarising paid amount, pending amount, and overdue orders. This creates a complete financial traceability from order to payment.

Step 7 – Procurement Dashboard (Driving‑Cab)

Key metrics are displayed for executives: monthly purchase spend, category spend ratios, supplier on‑time delivery rate, purchase amount ranking, delayed orders, and pending payments. The dashboard replaces manual meetings with instant data visualisation.

Why Many Procurement Systems Fail

Companies often spend large sums on complex ERP systems but still revert to Excel because the processes are not properly designed. The core issue is not the lack of a big system but whether the procurement workflow is fully operational.

Essential first‑stage capabilities include unified demand capture, supplier management, online order tracking, automatic receipt sync, and transparent payment flow.

Low‑Code Platform Advantage

A low‑code tool can quickly model the actual procurement process, allowing fields and workflows to be adjusted without redeveloping code, thus keeping the system aligned with business changes.

In summary, digitising procurement transforms it from a reactive, fire‑fighting activity into a proactive cost‑management centre with end‑to‑end visibility.