https://drive.google.com/drive/folders/156cQ-_oYjrwSx3o-Z7pkVmv4R3U9Gzx5?usp=sharing
๐ฅ The Project
We're Whiskey Library, a bourbon subscription company serving 4,000+ enthusiasts. We need a custom Shopify embedded app to automate our Mystery Box fulfillment process.
I've already done the hard part โ I have a complete technical spec, database schema, architecture diagram, and step-by-step implementation guide ready. I need a developer who can execute quickly using Cursor AI (or similar AI coding tools) and ship an MVP in 48 hours.
๐ฏ What the App Does
Core Function: Automatically build optimal bourbon mystery box combinations and assign them to orders.
Two Product Tiers:
$150 Mystery Box โ Must contain โฅ$170 retail value
$300 Mystery Box โ Must contain โฅ$330 retail value
Key Features (MVP):
Product Sync - Pull all Shopify products tagged "mystery box" with cost, retail price, and inventory levels
Customer History Tracking - Track what bourbons each customer has received (no duplicates ever)
Box Builder Algorithm - Optimize box combinations to:
Meet retail value minimums
Minimize our cost (maximize margin)
Exclude products customer already received
Ensure vendor diversity (no 3 bottles from same distillery)
Order Queue - Display pending mystery box orders sorted by date (FIFO)
Assignment Flow - One-click assign box to order, which:
Adds detailed order note (for packing slip)
Decrements inventory in Shopify
Updates customer history
Adds order tags
Reports Dashboard - Show metrics: avg cost, avg margin, boxes made (filterable by date range)
๐ Tech Stack (Already Decided)
Shopify Remix template (official Shopify CLI)
React + Polaris (Shopify's component library)
Node.js backend
PostgreSQL + Prisma ORM
Shopify Admin GraphQL API
Hosted on Railway or Render
๐ What I'm Providing
โ
Complete technical specification document
โ
Database schema (Prisma models ready to use)
โ
Architecture diagrams
โ
All GraphQL queries written
โ
Step-by-step Cursor prompts (copy-paste ready)
โ
Shopify Partner account with development store set up
โ
API credentials ready
You're not designing anything. You're executing a detailed plan with AI assistance.
๐ค Who I'm Looking For
MUST HAVE:
Proficient with Cursor AI or similar AI coding assistants
Experience building Shopify embedded apps (not themes)
Comfortable with React, Node.js, PostgreSQL
Can debug AI-generated code quickly when it breaks
Available for focused 48-hour sprint
NOT LOOKING FOR:
Developers who code everything from scratch (use AI!)
People who disappear without updates
Those unfamiliar with Shopify Admin API
โฐ Timeline
48 hours from start to deployed MVP
I expect progress updates every 8-12 hours. Quick Loom video or screenshots showing what's working.
๐ฐ Budget & Payment
$800 USD - Fixed Price - Paid on Completion
No milestones. You deliver the working MVP, I pay in full.
Why this rate works:
You have complete documentation (no discovery phase)
AI tools do the heavy lifting
Focused sprint, not weeks of back-and-forth
Opportunity for ongoing paid work (V2 features worth $2-3k+)
๐ To Apply, Include:
Your AI coding workflow - How do you use Cursor/Copilot/Claude?
A Shopify app you've built - Embedded app, not a theme
Your availability - Can you start within 48 hours and commit to the sprint?
One question about the project - Prove you read this
๐ซ Generic proposals without these = auto-reject
๐ฎ Future Work
Deliver this well and there's $2,000-3,000+ in follow-up work:
Klaviyo integration
AI bottle recommendations
Barcode scanning
Mobile optimization
Airtable sync
TAGS/SKILLS:
Shopify, Shopify App Development, React.js, Node.js, PostgreSQL, GraphQL, Cursor AI, API Integration
PROJECT LENGTH:
Less than 1 week
EXPERIENCE LEVEL:
Intermediate
SCREENING QUESTIONS:
"How do you use AI coding tools (Cursor, Copilot, Claude) in your development workflow?"
"Have you built a Shopify embedded app before? Briefly describe it."
"Can you start within 48 hours and commit to a focused 2-day sprint?"