Private Shopify Custom App: AI-Assisted Hardware Diagnostics Pipeline

We are launching a high-ticket consumer appliance sales and mechanical repair service business in the United States. We are utilizing a standard Shopify platform to manage hardware sales, parts inventory, and recurring care service memberships.
We require an experienced full-stack developer to build a private, custom Shopify application to streamline our mechanical repair diagnostics pipeline. The app will act as a training copilot to help bench technicians troubleshoot and execute repairs with high speed and precision.
To minimize development hours and keep our budget tight, the internal technician dashboard must be built using an embedded low-code framework (such as Retool or Bubble) integrated directly within our Shopify Admin panel via a secure app proxy or iframe.

Core Workflow & High-Level Requirements

1. Customer Front-End Intake (Liquid/Shopify UI)

• A clean submission page embedded on our live Shopify storefront.
• The customer inputs hardware metadata, describes the symptoms, and uploads a clear photo or short video snippet of the mechanical issue (up to 10MB).
• Data Parameter: Data writes directly to a secure backend database (PostgreSQL/Supabase preferred) and links to their Shopify Customer Profile. No processing or automated data is shown to the end customer.

2. Private Technician Bench Panel (Retool or Bubble Embedded)

• A hidden dashboard embedded inside the Shopify Admin panel for our internal bench technicians.
• Displays a queue of incoming open repair tickets. Clicking a ticket loads the customer's text/image metadata alongside an internal diagnostic workflow tool.
• The AI Integration: Technicians trigger an internal action passing the context to a multimodal LLM API (gpt-4o or similar). The API references custom technical documentation files mapped in our database to return a structured troubleshooting guide onto the bench display.

3. Technician Field Verification & Conditional Logic Locks

• Technicians must be able to upload a secondary "internal/exposed chassis" photo directly from the bench for secondary vision analysis.
• The dashboard features a strict conditional step-locking mechanism. Technicians must perform manual tool measurements (e.g., logging electrical or pressure data) and check off mandatory safety criteria before the dashboard will allow the ticket to be closed or update Shopify inventory data.

Technical Stack Expectations

• Frontend: Shopify Liquid/JSON (Public), Retool or Bubble (Internal Admin)
• Backend Database: Supabase / PostgreSQL + Secure cloud image storage bucket
• AI Framework: Direct OpenAI API integration (gpt-4o) via minimal webhooks
• E-Commerce Sync: Shopify Admin API (GraphQL preferred) to sync ticket history with Shopify Customer IDs
Full technical specifications, detailed prompt architectures, and database schema mappings will be provided to qualified candidates upon execution of a standard mutual NDA.