Project Description
echnical System & Platform Requirements
1. Overall Platform Architecture
Build a centralized web platform that includes:
Campaign storytelling hub (profiles + grid)
Sponsorship package sales
Merchandise storefront
Participant submission and story system
Responsive web application (mobile-first)
Modular architecture so commerce, content, and storytelling systems operate independently but are connected via shared database
---
2. E-Commerce System (Merch + Sponsorships)
Payment processing via Stripe
Support for:
Sponsorship packages (tiered products)
Merchandise:
Hats
T-shirts
Hoodies
Wristbands
Product functionality:
Variants (size, colour, quantity)
Bundles (e.g., sponsor + merch kit)
Checkout features:
Tax calculation
Shipping logic (flat rate or dynamic)
Promo codes (optional)
Order tracking system:
Central order database
Status tracking (paid, processing, fulfilled)
---
3. Revenue Allocation & Financial Logic
Each order automatically split into:
Campaign revenue
Production company share
Options:
Manual reconciliation (initial phase)
Scalable integration via Stripe Connect (future phase)
Automated reporting:
Sales summaries
Payout tracking
Sponsorship revenue breakdowns
---
4. Order Notifications & Workflow Automation
Automated email system:
Producer receives notification for every order
Includes full order details + customer info
Customer receives:
Receipt
Confirmation email
Workflow automation via:
Zapier (optional orchestration layers
---
5. Sponsorship Package System
Custom checkout fields:
Business name
Contact info
Sponsorship tier selection
Optional story input
Internal tagging system:
Tracks sponsor level and campaign association
CRM-style tracking of sponsors:
Status (lead → active → featured)
---
6. Story Collection System (Survey Layer)
Structured participant intake via form tool such as Jotform or equivalent:
Personal background
Community involvement
Achievements and goals
Media uploads (photos, logos)
Data stored in centralized database for processing
---
7. LLM Story Generation Pipeline
AI-powered story creation using OpenAI API:
Converts structured survey responses into:
Narrative story (long-form)
Short bio version
Headline/tagline
Prompt engineering ensures:
Consistent tone across all stories
Alignment with campaign voice
AI also suggests:
Community pillar category assignment
---
8. Human Editing & Approval Workflow
After AI generation:
User reviews and edits their story
Versioned editing system:
Raw submission
AI draft
Final user-edited version
Admin moderation layer:
Approve / reject / request edits
Final editorial control before publishing
Status pipeline:
Draft → AI Generated → User Edited → Under Review → Approved → Published
---
9. Content Management System (CMS)
Central database (e.g., Airtable or custom backend)
Stores:
Participant profiles
Stories (all versions)
Sponsorship data
Merchandise orders
API-driven architecture to power frontend dynamically
---
10. Grid System
Main visual interface:
12 featured “faces” displayed on homepage grid
Each tile includes:
Image
Name
Short tagline
Click-through experience:
Full profile page per participant
Full story + media + category
Category system:
Users can filter by community pillar:
Agriculture
Tourism
Arts & culture
Business & innovation
Community leadership
Education & youth
Environment & sustainability
Dynamic scaling:
Grid expands beyond 12 while maintaining featured rotation
---
11. Data Structure & Tagging
Each profile includes:
Core identity fields
Community pillar tags
Sponsorship association (if applicable)
Enables:
Filtering
Search
Category browsing
Featured selection logic
---
12. Notifications & Lifecycle Automation
Event triggers:
Survey submission → AI story generation
User edits complete → admin review notification
Approval → publish to grid
Optional integrations:
Email marketing follow-ups
Sponsor onboarding flows
Automated communication loops for participants and admins
---
13. Merchandise Fulfillment System
Inventory or print-on-demand integration
Order routing:
Direct to fulfillment partner or internal production
Shipping tracking (optional enhancement)
Merch can be:
Standalone purchase
Bundled with sponsorships
---
14. Security, Permissions & Compliance
Role-based access control:
Participant (edit own submission)
Admin (full moderation)
System (automation layer)
Secure API handling for:
Payments
Form submissions
Content publishing
PCI compliance handled through Stripe
Data privacy compliance for user submissions
---
15. Scalability & Futur