Can I vibe code Shopper Approved?

Build a custom, full-stack customer review management microservice using Next.js App Router, Tailwind CSS, PostgreSQL, Prisma, and Resend.

1. DATA MODEL:
- Customer: id, email, name
- Order: id, external_order_id, customer_id, fulfilled_at, status
- Product: id, external_product_id, title, handle
- Review: id, order_id, product_id, customer_id, rating (1-5 integer), title, body, status (pending, approved, rejected), verified_buyer (boolean), created_at
- ReviewResponse: id, review_id, body, created_at

2. WORKFLOWS & LOGIC:
- Expose a POST /api/webhooks/order-fulfilled endpoint. On receipt, queue a scheduled review request job 14 days in the future.
- Post-purchase email contains a secure signed token URL leading to a clean, fast review submission form.
- When submitted, set review status to 'pending' if rating <= 3 or text contains profanity; auto-approve if 4 or 5 stars.
- Generate dynamic JSON-LD structured data block (<script type="application/ld+json">) on product pages for AggregateRating schema compliant with Google's rich result guidelines.

3. FRONTEND WIDGETS:
- Embedded Star Rating Summary component displaying average score, total reviews, and breakdown distribution bars.
- Paginated Customer Reviews list with sorting (newest, highest rating, lowest rating).
- Lightweight JS snippet loadable via single script tag on any store frontend.

4. ADMIN DASHBOARD:
- Queue view for pending reviews with Approve / Reject / Reply buttons.
- Ability to edit merchant responses and export review data as CSV.

5. FAILURE MODES & OUT OF SCOPE:
- Webhooks must be idempotent using external_order_id.
- Ignore order webhooks if order status changes to cancelled/refunded prior to email dispatch.
- Out of scope: Google Ads Seller Ratings syndication (requires official Google partnership) and video upload processing.

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