ℹ
All active prices must originate from an approved supplier import. Manual price entry is disabled. Emergency overrides require a reason, expiry date, and are fully audited.
Active Suppliers
—
with imported prices
Materials Priced
—
of — in catalog
Pending Approvals
—
staged items awaiting review
Last Import
—
No imports yet
Active Overrides
—
emergency price overrides
Price Changes (30d)
—
logged in history
Supplier Sync Status
| Supplier | City | Last Import | Materials | Status | Action |
|---|---|---|---|---|---|
| Loading... | |||||
Pending Approvals
No pending items.
Supplier Connectors
ℹ
These 6 Calgary-area suppliers are pre-configured. CSV upload is the primary import method — prices are only valid after upload and admin approval. No live API integration yet (Phase 2).
Loading suppliers...
Material Catalog
| SKU | Material Name | Category | Unit | Best Price | Suppliers | Last Updated |
|---|---|---|---|---|---|---|
| Loading catalog... | ||||||
CSV Import Wizard
Phase 1 — Manual Upload
1Select Supplier
2Upload CSV
3Map Columns
4Normalize
5Fuzzy Match
6Approve
Select Supplier
Loading...
Upload CSV Price List
Supplier: —
ℹ
CSV must contain at minimum: product name/description and unit price. SKU/code is optional but improves matching accuracy.
Click to upload or drag and drop CSV file
Accepts .csv files up to 10 MB
Map CSV Columns
Tell us which column contains each field.
Normalize & Clean
Preview after cleaning whitespace, stripping currency symbols, standardizing units.
| Row | Product Name | SKU | Unit Price | Unit | Status |
|---|
Fuzzy Match Results
Each row is matched to the closest material in your catalog. Review and correct low-confidence matches.
| Supplier Name | Matched Material | Score | Unit Price | Override Match |
|---|
Review & Approve
Import job ID: —
⚠
Approving will write prices to the Active Prices table and log each change in Price History. This cannot be undone — you can import again to update prices.
| Material | Supplier | Unit Price | Match Score | Status |
|---|
Active Prices
| Material | Category | Supplier | Unit | Unit Price | Effective Date | Source | Action |
|---|---|---|---|---|---|---|---|
| Loading... | |||||||
Price History
| Date | Material | Supplier | Old Price | New Price | Change % | Source | Import Job |
|---|---|---|---|---|---|---|---|
| Loading... | |||||||
Product Mapping
Review supplier SKUs that couldn't be auto-matched to your catalog.
ℹ
Once you manually link a supplier SKU to a catalog material, the system remembers it for future imports automatically.
| Supplier | Supplier Product Name | Supplier SKU | Matched To | Confidence | Status | Action |
|---|---|---|---|---|---|---|
| Loading... | ||||||
Pricing Reports
Best Price Comparison by Material
| Material | Unit | Best Price | Savings | ||
|---|---|---|---|---|---|
| Loading... | |||||
Price Trend (Last 10 Changes)
| Material | Supplier | Previous | Current | Change | Date |
|---|---|---|---|---|---|
| No history yet. | |||||
Catalog Coverage
PHASE 2 LIVE
Backend Automation Active
Scheduled syncs, CSV auto-import, email ingestion, and PDF extraction are running. Manage configs and view run logs in the Sync Dashboard.