Overview

Poppies is a full-stack artist portal and e-commerce platform for Poppies Art & Gifts, a 45-artist consignment cooperative in Ojai, California. It replaces Square Websites + Connecteam with a unified platform.

Architecture

• Frontend: React 18, Vite, Tailwind CSS, Radix UI (shadcn/ui)
• Backend: Express 4, JWT auth
• Database: PostgreSQL + Drizzle ORM (24 tables across 8 domains)
• Integrations: Square SDK (bi-directional POS sync), Google Drive, Mailchimp, AWS SES
• Deployment: GCP Cloud Run (poppies.netrunsystems.com)

Key Features

• 35 artist profiles with web-researched bios
• Shop with 191+ Square inventory items (bi-directional sync)
• Cart and checkout (CA 7.75% tax, $10 flat shipping over $100)
• Shift scheduling (replacing Connecteam)
• Team messaging with notifications
• Document library (Google Drive)
• Monthly commission tracking and payouts
• PWA with "Add to Home Screen"

SKU Format

[Artist Initials]-[Item#]-[MMYY] (e.g., JD-001-0326)