Can I vibe code TrustSpot?

Build a custom, lightweight ecommerce review system using Next.js, PostgreSQL (Prisma), and Tailwind CSS. The system must collect, moderate, and render product reviews with photo uploads and JSON-LD schema for SEO.

1. DATA MODEL:
- Store Products: id, external_id (e.g., Shopify ID), name, sku.
- Orders: id, external_order_id, customer_email, customer_name, fulfilled_at, review_email_sent (boolean).
- Reviews: id, product_id, order_id, rating (1-5 integer), title, body, author_name, status (pending, approved, rejected), is_verified_buyer (boolean), created_at.
- ReviewMedia: id, review_id, url, type (image/video).

2. INGESTION & EMAIL TRIGGER:
- Create an API route POST /api/webhooks/orders/fulfilled that accepts ecommerce order payloads and saves the order details.
- Create a scheduled job (Node CRON or QStash) that runs daily: checks for fulfilled orders older than 7 days where review_email_sent is false. Sends a transactional review request email via Resend API containing a magic link with a signed JWT token.

3. REVIEW SUBMISSION FLOW:
- Build a frontend page /submit-review?token=JWT.
- Verify the token, render a form allowing 1-5 star selection, title, body text, and client-side multi-file image upload directly to AWS S3 using pre-signed URLs.
- On POST /api/reviews, insert the record with status='pending' and is_verified_buyer=true if token is valid.

4. EMBEDDABLE WIDGET & SEO:
- Create an endpoint GET /api/reviews/product/:productId returning approved reviews, rating breakdown stats, and average score.
- Generate an embeddable Web Component script that builds a clean UI: star summary, filtering, photo gallery, and appends a valid <script type="application/ld+json"> block containing schema.org AggregateRating and Review microdata.

5. ADMIN DASHBOARD:
- Build a secure moderation view at /admin/reviews listing 'pending' reviews with bulk actions for 'Approve' and 'Reject'.

Out of scope: Google Shopping XML feeds, complex email template builders, or automated AI sentiment analysis.

$ each button prefixes agent-specific run instructions · build your own product, never copy proprietary code, trademarks or designs