BOM V2

bySurya Prakash Guna Sekhar

MateFinder v2 Build Prompt for 8080.ai — Fresh Project Paste everything below the line as the project prompt for a NEW project. This version bakes in every correction from the first attempt so the requirements, flows, and pages generate correctly on the first pass. Build a production-grade internal web application called BOM Lookup for a wire harness manufacturer. Its purpose: when an engineer or estimator enters a connector or housing part number, the app instantly returns the complete mating system for that part — the mating connector, compatible terminals (filtered by wire gauge), seals/cavity plugs, wedgelock/secondary lock, and recommended crimp tooling — each with direct purchase links to distributors, sorted with the cheapest in-stock option first. This replaces manually Googling mating parts one at a time. Personas — EXACTLY TWO. Do not create any others. User: engineer/estimator. Searches parts, views results, exports BOMs. Admin: everything User does, plus manages the database. Do NOT create personas such as Inventory Manager, Operations Manager, Procurement Specialist, or Data Analyst. Do not create user flows or pages for any persona other than User and Admin. Pages — EXACTLY THESE EIGHT. Do not create any others. Landing Login Search Results Admin Dashboard Admin Parts Admin Flags Admin Reports There is no user-facing Dashboard page, no SearchLog page, no standalone Parts page, no MatingMap page, and no DistributorOffers page. Search-log reporting lives inside Admin Reports. The mating map is a database table, not a page or visual diagram tool. Distributor offers render inside the Results page. Core user flow User types a manufacturer part number (e.g. "DT06-12S") into a single prominent search box. Search must be fuzzy/typo-tolerant, matching part number, series name, and aliases. User optionally sets: required quantity (default 100) and wire gauge (AWG). Results page shows the queried part pinned at top (qty and wire gauge still editable), then grouped sections in this order: Mating Connector, Terminals (filtered by wire gauge if given), Seals & Cavity Plugs, Wedgelock / Secondary Lock, Crimp Tooling. Every part in every section shows: manufacturer, part number, short description, and distributor offers — distributor name, unit price at the entered quantity, stock, and a direct product link opening in a new tab — sorted cheapest-first, out-of-stock offers greyed at the bottom of each list. Per-part checkboxes and a "Copy BOM" button exporting selected parts as CSV and tab-separated clipboard text: part number, manufacturer, description, qty, best unit price, best distributor, link. A failed search shows "Not in our database yet" with a one-click "Request this part" action that logs the query for admins. Data model (Postgres) parts: id, manufacturer, part_number (unique, indexed), description, category (housing_plug, housing_receptacle, terminal, seal, wedgelock, tool, other), series, positions, gender, wire_gauge_min, wire_gauge_max, datasheet_url, aliases (text array). mating_map: id, part_id, related_part_id, relation_type (mates_with, uses_terminal, uses_seal, uses_wedgelock, crimped_by), notes, verified (bool), created_by, created_at. This is a relational table that search traverses to assemble the grouped results. It is not a visual diagramming feature. distributor_offers (cache): part_id, distributor, sku, product_url, currency, price_breaks (JSONB), stock, fetched_at. search_log: query, matched_part_id (nullable), user_id, created_at. Used only for the Admin Reports unmatched-searches report. Distributor pricing integration Integrate the Nexar (Octopart) GraphQL API for live distributor offers (price breaks, stock, product URLs) by manufacturer part number. API token via environment variable, integration behind a clean service interface. Cache offers in distributor_offers for 24 hours; show "prices as of <time>" with a manual refresh button. Fallback mode (the app must be fully usable with zero API keys configured): without a Nexar token, each part renders working distributor search links built from the part number — Digi-Key (https://www.digikey.com/en/products/result?keywords={PN}), Mouser (https://www.mouser.com/c/?q={PN}), Newark (https://www.newark.com/search?st={PN}), Arrow (https://www.arrow.com/en/products/search?q={PN}), Waytek (https://www.waytekwire.com/search/?query={PN}) — labeled "Search on <distributor>" with no price shown. Admin area Admin Parts: CRUD for parts and mating relationships, relation picker with autocomplete, CSV bulk import for both parts and relations with downloadable templates. Admin Flags: any user can flag an incorrect mating suggestion; flags appear in a review queue with a Verify action. Admin-verified relations show a "Verified" badge in results. Admin Reports: unmatched-searches report from search_log (most-searched part numbers returning no results). This is a simple report, not an analytics suite. Admin Dashboard: simple overview (part count, relation count, pending flags, recent unmatched searches). No invented analytics, charts of user activity, or trend visualizations. Seed data (required — the app must demo with real content on first boot) Seed example parts and mating relations, all with verified=false, structured in a data file so more families can be added: Deutsch DT: DT06-2S…DT06-12S plugs mating DT04-2P…DT04-12P receptacles; size-16 terminals [phone] / [phone]–16 AWG); W2S–W12S / W2P–W12P wedgelocks; HDT-48-00 crimp tool. Deutsch DTM: DTM06-xS plugs, DTM04-xP receptacles, size-20 terminals [phone] / [phone], WM-xS / WM-xP wedgelocks. Molex MX150: example sealed housings with 33012-series terminals. TE AMPSEAL 16: example plug/cap pairs with appropriate terminals. Visual design (exact values — do not substitute) Background #FAFAF6, surface #F2F2F2, text #1B2A41 (dark navy), muted text #7F8C8D, border #D5D8DC, accent #B06A2A (copper) with #8C4E1A for hover/darker states. Copper means #B06A2A — never bright orange ( #FF6600). Part numbers and prices in a monospace font everywhere, including input placeholder text. Landing page structure, top to bottom: (1) nav — Home, Search, Sign In only; admin pages appear in navigation only after admin sign-in; (2) hero headline "Find the complete mating system" with subline and a dominant search box (placeholder: "Enter part number (e.g. DT04-2P)"); (3) a small static illustration of housing–mating–terminals; (4) a features section titled "Everything you need in one search" with four cards: Smart Search (fuzzy matching finds your connector even with partial or variant part numbers), Wire Gauge Filter (filter compatible terminals by wire gauge), Price Comparison (distributor offers sorted by cheapest in-stock first with direct purchase links), Export BOM (copy the complete bill of materials with one click); (5) CTA "Ready to find your parts?" with text "Sign in to search the parts database, or manage it as an admin." and Try Search / Sign In buttons; (6) footer with Product (Home, Search Parts) and Legal columns — admin links in the footer only for signed-in admins. Motion: minimal and functional. No looping hero animations or self-assembling component scenes. Do not add saved searches, BOM history, or any feature not listed in this prompt. Tech and quality React frontend, FastAPI backend, Postgres with Alembic migrations. RESTful API. Unit tests for mating-system assembly (given a part id, return correct grouped related parts) and offer sorting (cheapest in-stock first, out-of-stock last). All secrets via environment variables. README covering local run, Nexar token configuration, CSV bulk import, and template formats. Explicitly out of scope No purchasing/checkout in-app (links out only). No scraping of distributor sites. No public access — internal users only. No analytics dashboards. No saved searches or history features.

LandingResultsAdmin PartsAdmin ReportsAdmin DashboardAdmin FlagsLoginSearch
Landing

Comments (0)

No comments yet. Be the first!

Project Tasks

87 workspace tasks
#1

Database Schema & Migration

57m 0s100 cr estimated
Done
#2

Seed Data Script

80 cr estimated
Backlog
#3

Backend API Services

71.93 cr estimated
Backlog
#4

RBAC Implementation

59.94 cr estimated
Backlog
#5

API Client Service Layer

70.3 cr estimated
Backlog
#6

Integration Tests

120 cr estimated
Backlog
#7

CI/CD Pipeline Setup

72.09 cr estimated
Backlog
#8

Implement Navigation for Landing Page

52.72 cr estimated
Backlog
#9

Implement Landing Hero Headline for Landing Page

35.15 cr estimated
Backlog
#10

Implement Landing Hero Illustration for Landing Page

35.15 cr estimated
Backlog
#11

Implement Landing Hero Search for Landing Page

52.72 cr estimated
Backlog
#12

Implement Landing Features for Landing Page

35.15 cr estimated
Backlog
#13

Implement Landing How It Works for Landing Page

35.15 cr estimated
Backlog
#14

Implement Landing CTA for Landing Page

35.15 cr estimated
Backlog
#15

Implement Footer for Landing Page

35.15 cr estimated
Backlog
#16

Implement Login Form Container for Login Page

87.87 cr estimated
Backlog
#17

Implement Login Inputs for Login Page

52.72 cr estimated
Backlog
#18

Implement Login Actions for Login Page

35.15 cr estimated
Backlog
#19

Implement Error Display for Login Page

1h 4m 40s17.57 cr estimated
Done
#20

Implement Admin Dashboard Header for Admin Dashboard

17.57 cr estimated
Backlog
#21

Implement Admin Dashboard Sidebar for Admin Dashboard

35.15 cr estimated
Backlog
#22

Implement Admin Dashboard Welcome for Admin Dashboard

17.57 cr estimated
Backlog
#23

Implement Admin Dashboard Stats for Admin Dashboard

35.15 cr estimated
Backlog
#24

Implement Admin Dashboard Quick Actions for Admin Dashboard

17.57 cr estimated
Backlog
#25

Implement Admin Dashboard Activity Feed for Admin Dashboard

17.57 cr estimated
Backlog
#26

Implement Admin Dashboard Alerts for Admin Dashboard

35.15 cr estimated
Cancelled
#27

Implement Search Header for Search Page

35.15 cr estimated
Backlog
#28

Implement Search Input Section for Search Page

52.72 cr estimated
Backlog
#29

Implement Search Filters Bar for Search Page

35.15 cr estimated
Backlog
#30

Implement Search Results Grid for Search Page

52.72 cr estimated
Backlog
#31

Implement Search Results Detail for Search Page

70.3 cr estimated
Backlog
#32

Implement Search Empty State for Search Page

35.15 cr estimated
Backlog
#33

Implement Search Export Bar for Search Page

52.72 cr estimated
Backlog
#34

Implement Admin Parts Page Header for Admin Parts

52.72 cr estimated
Backlog
#35

Implement Admin Parts Table Container for Admin Parts

52.72 cr estimated
Backlog
#36

Implement Admin Parts Table for Admin Parts

52.72 cr estimated
Backlog
#37

Implement Admin Parts Table Actions for Admin Parts

52.72 cr estimated
Backlog
#38

Implement Admin Parts Pagination for Admin Parts

35.15 cr estimated
Backlog
#39

Implement Admin Parts Import Modal Container for Admin Parts

52.72 cr estimated
Backlog
#40

Implement Admin Parts Import Modal for Admin Parts

35.15 cr estimated
Backlog
#41

Implement Admin Parts Import Results for Admin Parts

35.15 cr estimated
Backlog
#42

Implement Admin Flags Header for Admin Flags

52.72 cr estimated
Backlog
#43

Implement Admin Flags Queue Container for Admin Flags

52.72 cr estimated
Backlog
#44

Implement Admin Flags Queue Row for Admin Flags

52.72 cr estimated
Backlog
#45

Implement Admin Flags Detail Panel for Admin Flags

70.3 cr estimated
Backlog
#46

Implement Admin Flags Detail Actions for Admin Flags

52.72 cr estimated
Backlog
#47

Implement Admin Reports Header for Admin Reports

35.15 cr estimated
Backlog
#48

Implement Admin Reports Filter Bar for Admin Reports

52.72 cr estimated
Backlog
#49

Implement Admin Reports Metrics for Admin Reports

35.15 cr estimated
Backlog
#50

Implement Admin Reports Table Container for Admin Reports

52.72 cr estimated
Backlog
#51

Implement Admin Reports Table for Admin Reports

70.3 cr estimated
Backlog
#52

Implement Admin Reports Table Actions for Admin Reports

35.15 cr estimated
Backlog
#53

Implement Admin Reports Export for Admin Reports

52.72 cr estimated
Backlog
#54

Implement Results Header for Results Page

52.72 cr estimated
Backlog
#55

Implement Results Filters for Results Page

52.72 cr estimated
Backlog
#56

Implement Results Grouped Container for Results Page

70.3 cr estimated
Backlog
#57

Implement Results Grouped Mating for Results Page

52.72 cr estimated
Backlog
#58

Implement Results Grouped Terminals for Results Page

52.72 cr estimated
Backlog
#59

Implement Results Grouped Seals for Results Page

52.72 cr estimated
Backlog
#60

Implement Results Grouped Cavity Plugs for Results Page

52.72 cr estimated
Backlog
#61

Implement Results Grouped Wedgelocks for Results Page

52.72 cr estimated
Backlog
#62

Implement Results Grouped Secondary Locks for Results Page

52.72 cr estimated
Backlog
#63

Create Results API Endpoints

95.9 cr estimated
Backlog
#64

Create Admin API Endpoints

95.9 cr estimated
Backlog
#65

Update Flag Data Model

100 cr estimated
Backlog
#66

Integrate Results Backend and Frontend

140 cr estimated
Backlog
#67

Integrate Admin Backend and Frontend

140 cr estimated
Backlog
#68

Implement Admin Dashboard System Health

2m 6s87.87 cr estimated
To Do
#69

Implement Admin Dashboard System Actions

87.87 cr estimated
Backlog
#70

Nexar Graph QL Integration

83.92 cr estimated
Backlog
#71

Integrate Nexar API

1h 31s95.9 cr estimated
To Do
#72

Integrate Search Backend and Frontend

120 cr estimated
Backlog
#73

Implement Auth Middleware

32m 59s83.92 cr estimated
Backlog
#74

Define Data Retention Policies

100 cr estimated
To Do
#75

Create E2E Tests

46m 3s180 cr estimated
Backlog
#76

Create Search API Endpoints

95.9 cr estimated
Backlog
#77

Implement Search Integration

120 cr estimated
Cancelled
#78

Develop Search Log Model

100 cr estimated
Backlog
#79

Implement Role-Based Access Control

83.92 cr estimated
Cancelled
#80

Create Parts API Endpoints

95.9 cr estimated
Backlog
#81

Develop Mating Map Model

120 cr estimated
Backlog
#82

Implement Search Log API

59.94 cr estimated
Backlog
#83

Integrate Admin Parts Backend and Frontend

140 cr estimated
Backlog
#84

Create Admin Reports API Endpoints

71.93 cr estimated
Backlog
#85

Develop Distributor Offers Cache Model

120 cr estimated
Backlog
#86

Integrate Admin Reports Backend and Frontend

140 cr estimated
Backlog
#87

Deploy develop branch to stage

9m 7s20 cr estimated
Done
Landing design preview
Landing: View Info
Login: Sign In
Admin Dashboard: View Overview
Admin Parts: Manage Parts
Admin Parts: Import CSV
Admin Parts: Manage Relationships
Admin Flags: Review Queue
Admin Flags: Verify Flag
Admin Reports: View Unmatched Searches
Search: Enter Part Number
Results: View Mating System
Results: Export BOM
Landing design preview
Landing: View Info
Login: Sign In
Admin Dashboard: View Overview
Admin Parts: Manage Parts
Admin Parts: Import CSV
Admin Parts: Manage Relationships
Admin Flags: Review Queue
Admin Flags: Verify Flag
Admin Reports: View Unmatched Searches
Search: Enter Part Number
Results: View Mating System
Results: Export BOM