Solutions / Synthetic workflow example
Compare supplier prices on the same terms.
Different pack sizes make price lists difficult to compare. This example turns supplier files into unit prices and a ranking a buying team can review.
- Inputs
- Synthetic supplier price files with product, pack size, quantity and price.
- Preparation
- Normalize pack sizes and calculate comparable unit prices.
- Result
- Ranked offers with links back to their source files.
What the walkthrough shows
- Ten fictional suppliers provide thirty offers for three products. A lower pack price does not always mean a lower unit price.
- The workflow reads the files, normalizes pack quantities and writes comparable offers and rankings to PostgreSQL.
- A changed supplier price changes the ranking on the next demonstrated update. The buyer can trace an offer to the original file.
- The demonstration shows a scheduled update from a synthetic rehearsal. Setup and Git authoring are omitted from this shorter cut.
What you need to build your version
A technical owner configures access to your systems, defines queries and transformations, and agrees what the output should mean. Connections, permissions, matching rules and schedules depend on your workflow.
Evaluation boundaries
This is an Alpha demonstration using synthetic data, not a customer case study or a measured business outcome. The retained recording shows the product at the time of capture; the current interface may differ.
The example demonstrates data preparation and comparison. It does not choose suppliers or promise savings. Scheduled-run footage comes from a synthetic rehearsal.
Use test data and non-production systems. Verify the output and a failure case for your own evaluation.
Discuss your workflow
Tell us which systems you use, how often the process runs, and which result you need. We reply by email to arrange a free conversation.
Discuss your workflow