SourcePilot

AI autopilot for product sourcing – from idea to supplier in one workflow

Score: 7.8/10TGReady to Spawn
Brand Colors

The Opportunity

Problem

Solo indie hackers building ecommerce stores struggle with poor product discovery and sourcing reliable suppliers for physical goods.

Solution

SourcePilot is an AI agent that automates the entire sourcing process: input a product idea, get researched suppliers, pricing comparisons, and even sample order scripts. Tailored for solo indies, it learns from your store to refine future runs. End-to-end reliability without spreadsheets or endless emails.

Target Audience

Solo indie hackers building ecommerce stores selling physical goods

Differentiator

End-to-end AI workflow with auto-negotiation templates and order tracking

Brand Voice

professional

Features

Idea Input

must-have16h

Describe product, get full sourcing report

Supplier Research

must-have24h

Aggregates from multiple platforms with pros/cons

Price Comparison

must-have14h

Side-by-side costs, MOQs, shipping

Negotiation Templates

must-have12h

AI-generated email scripts for suppliers

Workflow Tracker

must-have18h

Track sourcing status from idea to order

Learning Engine

must-have20h

Improves based on past successful sources

Bulk Runs

nice-to-have11h

Source 10 products at once

Sample Order Automation

nice-to-have13h

Generate order links/forms

Integration with Email

nice-to-have16h

Send negotiations directly

Predictive Scoring

future22h

Forecast supplier success probability

Voice Input

future25h

Sourcing via voice commands

Total Build Time: 191 hours

Database Schema

users

ColumnTypeNullable
iduuidNo
emailtextNo
preferencestextYes
created_attimestampNo

Relationships:

  • one-to-many with workflows

workflows

ColumnTypeNullable
iduuidNo
user_iduuidNo
product_ideatextNo
statustextNo
completedboolNo

Relationships:

  • foreign key to users(id)
  • one-to-many with reports

reports

ColumnTypeNullable
iduuidNo
workflow_iduuidNo
suppliers_jsontextNo
best_scoreintNo

Relationships:

  • foreign key to workflows(id)

templates

ColumnTypeNullable
iduuidNo
nametextNo
contenttextNo

API Endpoints

POST
/api/workflows

Start new sourcing workflow

🔒 Auth Required
GET
/api/workflows/:id

Get workflow status/report

🔒 Auth Required
POST
/api/workflows/:id/negotiate

Generate templates

🔒 Auth Required
PUT
/api/reports/:id

Update report feedback

🔒 Auth Required
GET
/api/user/workflows

List user workflows

🔒 Auth Required
PUT
/api/preferences

Update user prefs

🔒 Auth Required

Tech Stack

Frontend
Next.js 14 + Tailwind + shadcn/ui
Backend
Next.js API + Supabase Edge
Database
Supabase Postgres
Auth
Supabase Auth
Payments
Stripe
Hosting
Vercel
Additional Tools
OpenAI GPT-4oCron jobs

Build Timeline

Week 1: Auth and basic workflow

35h
  • User setup
  • Workflow CRUD

Week 2: AI research engine

40h
  • Report generation
  • Supplier aggregation

Week 3: Comparisons and templates

40h
  • Price tables
  • Negotiation AI

Week 4: Tracker and learning

40h
  • Status UI
  • Feedback loop

Week 5: Polish and payments

30h
  • Dashboard
  • Stripe tiers
Total Timeline: 5 weeks • hours

Pricing Tiers

Free

$0/mo

No templates

  • 3 workflows/month
  • Basic reports

Pro

$25/mo

Standard AI

  • Unlimited workflows
  • Full reports
  • Templates
  • Tracking

Elite

$69/mo

None

  • All Pro + Priority AI
  • Bulk runs
  • Email integration

Quick Stats

Build Time
0h
Target MRR (6 mo)
$0
Market Size
$0.0M
Features
11
Database Tables
4
API Endpoints
6