Enterprise Multi-Supplier Architecture

From Supplier Catalogs to High-Margin Quotations in Minutes

A dynamic platform enabling administrators to manage multiple suppliers, import heterogeneous product catalogs, organize dynamic category schemas, compute complex dimensional costs, and issue frozen, professional quotations.

Open DashboardTry CSV Import WizardBuild Calculation Sheet
Multi-Vendor

Zero SKU collisions across suppliers via vendor_id + code.

Dynamic Schemas

Configurable category attributes with zero database schema migrations.

Math & W×H Engine

Calculates area in m², waste allowance %, markups, and live catalog price refresh.

Frozen Snapshots

Immutable quotation versions with PDF print layout and customer view.

System Architecture

End-to-End System Data Flow

Understand how supplier data enters the platform, transforms through configurable schemas, calculates with exact mathematical precision, and produces immutable quotations.

Interactive Architecture

Click Any Stage to Inspect Data Flow & Payloads

Active: Vendors & Dynamic Schemas
01

Vendors & Dynamic SchemasConfigurable Schemas

Administrators register multiple suppliers with isolated identities and configure custom category attributes (dimensions, finishes, materials, units) via the UI with zero code.

✓ Metadata-driven attributes without rigid physical SQL migrations.
Stage Input StreamInbound Data
{
  "vendor": {
    "name": "Apex Timber Corp",
    "code": "VEND-APX",
    "paymentTerms": "Net 30"
  },
  "category": "Doors",
  "fields": [
    {
      "key": "width",
      "type": "dimension",
      "unit": "mm",
      "required": true
    },
    {
      "key": "height",
      "type": "dimension",
      "unit": "mm",
      "required": true
    },
    {
      "key": "finish",
      "type": "text",
      "defaultValue": "Natural Oak"
    }
  ]
}
Engine Output & State TransitionVerified Output
{
  "status": "configured",
  "schemaVersion": "v1.0",
  "dynamicAttributesAllowed": true,
  "schemaMigrationsRequired": false
}
Live Calculation Simulator

Interactive Dimensional Costing Playground

Adjust dimensions, waste %, and markup sliders to see how the mathematical calculation engine processes prices in real time.

Strict 2-Decimal Arithmetic
$35.00 / m²
+10%
+20%
Formula BreakdownLive Output
Single Item Area:2.88 m²
Total Area (2 units):5.76 m²
Raw Material Cost:$201.60
Waste Allowance (10%):+$20.16
Cost Basis with Waste:$221.76
Markup Margin (20%):+$44.35
Client Quoted Price
$266.11
Gross Profit
+$44.35 (16.7%)
Operational Guide

Step-by-Step: How to Use the Platform

From empty database on Day One to issuing high-margin client quotations in 4 simple steps.

1Setup
Create Vendors & Schemas
Define categories & dynamic fields before importing files.
Go to Vendors to record supplier contacts, codes, and payment terms.
Go to Categories to create categories (e.g. Doors, Hardware, Panels).
Configure custom attributes (e.g. Width, Height, Material, Finish) without writing code.
2Import
Run 8-Step CSV Wizard
Upload supplier price lists with multi-column mapping.
Select vendor & target category in the Import Wizard.
Upload CSV or TXT file; delimiter sniffer detects commas, semicolons, and tabs.
Map headers to schema fields, choose mode (Upsert, Price Update), preview differences, and commit.
3Costing
Draft Calculation Sheet
Calculate quantities, dimensions, waste %, and markups.
Search catalog products across multiple suppliers simultaneously.
Enter dimensions ($W \times H$ in mm) for area items; waste % and markup % calculate instantly.
Group line items by sections (e.g. Cabinetry, Hardware, Finishes) with live subtotals.
4Quotation
Generate & Export Quote
Issue immutable quotations and export to PDF / CSV.
Click Generate Quotation to lock the calculation into an immutable snapshot.
Toggle between Customer View (margins hidden) and Internal Operational View.
Download sanitized CSV or open print-ready HTML for one-click browser PDF printing.
Key Highlights

Built for Real-World Procurement

Inspect the underlying capabilities designed specifically to handle supplier messiness, volatile pricing, and custom specifications.

Multi-Vendor Identity Separation
How the system prevents SKU collisions when multiple vendors sell the same product code.

In real supply chains, Vendor A might use code DR-001 for an Oak Veneer Door at $120.00, while Vendor B uses DR-001 for an Aluminum Drawer Pull at $14.50.

// Composite Unique Identity Index:
UNIQUE INDEX supplier_products_vendor_code_idx ON supplier_products (vendor_id, normalized_product_code);

Codes are automatically stripped of extraneous whitespace, uppercased, and scoped strictly to their respective supplier. When a vendor uploads their monthly price updates, only their products are updated—preventing cross-vendor data corruption.

Ready to Start

Transform Your Pricing Operations Today

Experience the speed and accuracy of a unified vendor inventory, mathematical calculation engine, and quotation system.

Open WorkspaceManage Vendors