PROMPT
Act as Senior Database Design Strategist for Developer Prompt (15+ years, scaled Sustainable Fashion Ecom to 8-figures, ex-FAANG, generated $50M+ with this system).
CONTEXT:
Business: Sustainable Fashion Ecom - $500k ARR, team 13, targeting SMB owners, stage Seed
Current: CAC $143, LTV $521, churn 9%, traffic 42769/mo, conversion 5.5%
Assets: 50k IG 100 UGC videos
Goal: increase conversion 32% in 90 days
Constraint: Budget $8k/mo, no-code only
Tone: friendly expert
FRAMEWORK: QUEST + proprietary 4-step.
TASK: Complete Database Design system for Developer Prompt / Sustainable Fashion Ecom.
PHASE 1 DIAGNOSIS (First Principles):
- What 99% get wrong about database design for Sustainable Fashion Ecom
- 5 Whys root cause for increase conversion 32%
- Hidden cost of failure
- Contrarian insight top 1% know
PHASE 2 STRATEGY - Name your framework (e.g., Database Design Flywheel):
Step1 DECONSTRUCT: Objective, Action using Shopify Plus, Metric, Timebox 123min, Example for Sustainable Fashion Ecom
Step2 DISTILL: Objective, Action template, Metric, Timebox, Example
Step3 DEPLOY: Objective, Action, Metric, Timebox, Example
Step4 DOMINATE: Scale after 7 days, leading indicator, iteration rule if metric < threshold
PHASE 3 EXECUTION PACK (3 Variants Ready-to-Paste into Shopify Plus):
Variant A (Us vs Them): Subject/headline 10 options with hypothesis, preview 3, body 250 words with {{FirstName}} tags PS PPS, visual brief, CTA, send logic delay trigger segment. Include placeholder [BRAND][AUDIENCE][DATA] + filled example for Sustainable Fashion Ecom
Variant B (Social Proof Avalanche): Same structure different angle
Variant C (Re-engagement): Same structure third angle
Each variant must be fundamentally different not reworded
PHASE 4 QA CHECKLIST (10-point): Specificity, No AI speak (delve/unlock/tapestry banned), One person one problem, Actionability 24h, Measurable leading/lagging, Differentiation moat, Constraint fit, Edge cases fallback, Legal GDPR, CEO test proud?
PHASE 5 NEXT 7 DAYS: Day1 2h audit enrich, Day2 3h build A, Day3 2h B+C tracking, Day4 1h QA 2 users, Day5 launch 10% segment, Day6 optimize winner kill loser, Day7 scale 100% SOP Loom
PHASE 6 PRO TIPS: 1% tweak 10x database design, failure mode avoid, tool stack saves 10h/week Shopify Plus+Clay+Instantly+Figma+Linear, delegate VA Loom script
OUTPUT: Markdown H2/H3 tables copy blocks ready for Notion/Google Docs/Shopify Plus, both placeholder and filled side by side
No generic advice, every sentence actionable, specific numbers, decision tree If [condition] then A else B, no buzzwords without definition
Unique ID: PH-07998 | Developer Prompt | Database Design | Sustainable Fashion Ecom | increase conversion 32% | QUEST | b5c971f4