CNC Federal — Order Tracking Pipeline
Order-tracking + GSA reseller workflow for federal-supplies dropshippers: Red Falcon CSV intake, QuickBooks Online Sales sync, and Claude Vision OCR on vendor invoices, customer POs, and shipping docs.
Order-tracking pipeline for CNC Federal Supplies, a GSA / federal-supply dropship reseller (Clayton Trammell, clayton@cncfederal.com). Pulls Red Falcon CSV exports from the GSA portal, syncs QuickBooks Online Sales CSV, and uses Claude Sonnet 4 Vision to OCR vendor invoices, customer POs, and shipping documents into a single order timeline. Solves the dropship-reseller paperwork bottleneck end-to-end.
CNC Federal Order Tracking is a focused workflow tool for federal-supply dropship resellers. The customer is CNC Federal Supplies (Clayton Trammell, clayton@cncfederal.com). The data model is order-centric: users / orders / order_items / order_notes / order_documents / import_logs — not machines, work orders, or operators. Three ingestion paths feed the pipeline: Red Falcon CSV exports from the GSA portal (order intake), QuickBooks Online Sales CSV (revenue reconciliation), and Claude Sonnet 4 Vision PDF OCR for vendor invoices, customer POs, and shipping/tracking documents. The frontend ships 6 modules: auth, dashboard (kanban-style order pipeline + KPI cards + searchable orders), import (CSV preview + PDF OCR upload), orders, reports, and settings. Built with React 19 + Vite 8 + Tailwind 4 + dnd-kit + Recharts + date-fns + Playwright E2E coverage. Multi-stage Docker build (Node 22) for production deployment; VITE_API_URL env wires the backend.
- > Order-centric schema: users / orders / order_items / order_notes / order_documents / import_logs
- > Red Falcon CSV (GSA portal) intake
- > QuickBooks Online Sales CSV sync
- > Claude Sonnet 4 Vision OCR on vendor invoices + customer POs + shipping docs
- > Multi-stage Docker production build
- > Playwright E2E coverage
- → Backend API for live order data (currently mocked)
- → Generalize beyond CNC Federal to other GSA dropship resellers
- → Shipping-carrier tracking webhook ingestion (FedEx / UPS)
- → QuickBooks Online deeper sync (invoices, not just sales CSV)
- ! Backend API not wired yet — orders are mock data until backend ships
- ! Single-customer product today; productization depends on Clayton validating the workflow