Normalizing carrier rate sheets without losing commercial intent_
Parallaxis created a controlled import path that validates headers, normalizes prefixes and money fields, previews material changes, and requires approval before a tariff becomes effective. Operations can compare old and
- Carrier rate normalization
- Prefix-tree normalization
- Effective-date validation
Carrier price lists arrive with different prefix formats, effective dates, increments, currencies, and destination names. Manual copy-paste turns every update into a billing risk.
Parallaxis created a controlled import path that validates headers, normalizes prefixes and money fields, previews material changes, and requires approval before a tariff becomes effective.
Operations can compare old and new commercial terms before activation, trace a rated call back to the applicable row, and reject malformed updates before they reach production.
Overview
Carrier price lists arrive with different prefix formats, effective dates, increments, currencies, and destination names. Manual copy-paste turns every update into a billing risk.
Parallaxis created a controlled import path that validates headers, normalizes prefixes and money fields, previews material changes, and requires approval before a tariff becomes effective.
The engineering decision
The importer treats a rate sheet as a dated commercial artifact. It flags overlapping prefixes, missing effective times, unexpected price swings, and ambiguous rounding rules.
How the system works
The implementation separates intake, validation, state changes, side effects, and reporting. That separation makes failures visible and allows one layer to change without rewriting the entire workflow.
Operational users see explicit statuses and exceptions; technical teams retain identifiers, timestamps, versions, and logs needed to reproduce a result.
Outcome
Operations can compare old and new commercial terms before activation, trace a rated call back to the applicable row, and reject malformed updates before they reach production.
Project highlights
- Prefix-tree normalization
- Effective-date validation
- Currency and increment handling
- Rate-delta preview
- Approval and rollback path
- Tariff provenance