Items Master Contract Upload
Spec §11.1 — Hospital Admin can upload CSV/XLSX. Required columns: VendorId, GTIN, ContractPrice.
Drop CSV or XLSX file here
or click to browse files
Accepted: .csv, .xlsx (max 10MB)Required Columns
| Column Name | Required | Description |
|---|---|---|
| VendorId | Required | Vendor identifier matching registered vendors |
| GTIN | Required | Primary match key for item identification |
| ContractPrice | Required | Contracted unit price (USD) |
| UOM | Optional | Unit of measure |
| EffectiveDate | Optional | Contract effective date |
| ExpirationDate | Optional | Contract expiration date |
| ContractRef | Optional | Contract reference number |
Spec §11.2 — Matching precedence: 1) GTIN, 2) Normalized alternate identifier, 3) Future manual override
Matching Rules
- GTIN — primary match key
- Normalized alternate identifier — if configured
- Manual override — future release
Upload History
| Upload Date | Filename | Records | Matched | Unmatched | Status | Uploaded By |
|---|---|---|---|---|---|---|
| 2026-02-28 09:15 | stryker-contract-q1-2026.csv | 1,245 | 1,198 | 47 | Processed | Sarah Mitchell |
| 2026-02-15 14:30 | medline-contract-2026.xlsx | 832 | 810 | 22 | Processed | Sarah Mitchell |
| 2026-02-10 11:45 | cardinal-health-update.csv | 567 | 401 | 166 | Partial | James Rivera |