Apps & APIs
Partsnap Portal — DNet Lookup & Sales Analytics Dashboard
Internal Flask and Dash portal that consolidates DNet/List lookup, sales-file uploads, parsing previews, missing-value summaries, monthly analytics, and exports into one operational dashboard.
Internal portal command view
Partsnap Portal Dashboard
DNet/List lookup, sales upload parsing, missing-value summaries, monthly analytics, and exports
Login
Access
Lookup
DNet / List
Upload
Sales file
Analyze
Monthly
Export
CSV / XLSX
Portal navigation
Workflow preview
Dash / Plotly| View | Input | Output | Status |
|---|---|---|---|
| DNet Lookup | Part / MFG | Price reference | Ready |
| Sales Upload | CSV / XLSX | Preview table | Parsed |
| Missing Values | Uploaded file | Summary | Review |
| Monthly View | Sales file | Price Extension | Chart |
Dashboard outputs
Business problem
Lookup and sales analytics workflows needed a portal interface instead of separate files, scripts, and one-off dashboard views. Users needed a cleaner way to search DNet/List values, upload sales files, preview data, and review monthly analytics from one place.
The process needed an internal application layer that could make pricing lookup and sales-file analysis easier to access without requiring users to run scripts directly.
System built
Built a Flask and Dash internal portal with login and verification, DNet/List lookup modes, Dash tables, CSV/XLSX upload parsing, sales-file previews, exports, missing-value summaries, SQLite-backed lookup support, and monthly analytics views.
The system turns disconnected lookup and sales analysis steps into a single portal experience that feels more usable for business review.
Portal signals
Signals reviewed
The portal evaluates access state, lookup requests, uploaded files, parsing results, and dashboard outputs before returning review-ready views.
Portal flow
How it works
Authenticate
Guide users through login, registration, and verification before exposing lookup or analytics tools.
The portal creates a controlled entry point so internal tools feel like one application instead of disconnected scripts.
Look Up
Search DNet and List values with latest and historical lookup modes.
The lookup layer gives users a faster path to pricing references without manually searching through source files.
Upload
Parse uploaded sales files and prepare preview tables, validation summaries, and export-ready records.
Upload parsing turns one-off file review into a repeatable workflow inside the portal interface.
Analyze
Generate monthly analytics views, missing-value summaries, and price extension analysis.
The analytics layer helps users understand patterns and exceptions without leaving the portal.
Export
Deliver review-ready outputs that can be downloaded, shared, or used for follow-up analysis.
Exports make the portal useful beyond the screen by supporting business review and operational reporting.
Application layers
What the portal coordinates
Portal access layer
Handles login, registration, verification, and protected access to the internal dashboard experience.
Lookup layer
Provides DNet and List lookup modes with manufacturer filters and latest or historical views.
Upload parser
Reads uploaded sales files, builds previews, summarizes missing values, and prepares clean records.
Analytics layer
Creates monthly views, price extension analysis, dashboards, tables, and export-ready outputs.
Impact signals
What the portal improved
DNet and List lookup portal for faster pricing reference
Sales-file previews, parsing, summaries, and exports
Monthly Price Extension analysis for business review
Login and verification flow for controlled internal access
Dash tables and Plotly visuals for portal-based analytics
Operational value
Internal tools converted into a usable portal
One place for lookup work
Consolidates DNet/List reference work into a portal instead of relying on scattered files and manual searches.
Faster sales-file review
Turns uploaded files into previews, summaries, and analysis outputs without separate scripts.
Cleaner business visibility
Monthly analytics views help users see pricing extension and sales-file patterns in a more structured way.
Portal-ready foundation
Shows how internal tools can evolve from scripts into a usable application layer for operations.
Why this project matters
Pricing lookup and sales analysis work better when they live inside one portal.
This project shows how internal scripts and file-based workflows can evolve into a more usable business application. By combining lookup tools, uploads, previews, summaries, analytics views, and exports, the portal gives users a cleaner way to interact with operational data.
The value is not only the dashboard. The value is creating an internal interface that makes pricing reference and sales analysis easier to access, repeat, and explain.
Confidentiality note
Visuals and descriptions are sanitized conceptual representations. They do not expose private company data, customer records, credentials, raw exports, internal pricing, operational screenshots, or proprietary source files.