Can I vibe code Bazaarvoice?

Build a production-grade, multi-tenant E-commerce Review & Q&A microservice called 'OpenReviewEngine' using Next.js 14 App Router, PostgreSQL, Prisma, and Tailwind CSS.

CORE DATA MODELS:
1. Merchant (id, name, apiKey, domain, createdAt)
2. Product (id, merchantId, externalProductId, gtin, sku, title)
3. Review (id, productId, merchantId, rating [1-5], title, body, reviewerName, reviewerEmail, isVerifiedBuyer, status [PENDING, APPROVED, REJECTED], helpfulCount, createdAt)
4. Question (id, productId, merchantId, questionText, authorName, authorEmail, status, createdAt)
5. Answer (id, questionId, answerText, authorName, isOfficialStoreResponse, createdAt)
6. ReviewMedia (id, reviewId, url, type [IMAGE, VIDEO])

KEY IMPLEMENTATION REQUIREMENTS:
1. API & SDK LAYER:
   - REST endpoints for fetching reviews (`GET /api/v1/reviews?productId=X&page=1&limit=10`) with aggregated metrics (average rating, rating distributions).
   - REST endpoint for submitting reviews (`POST /api/v1/reviews`) with payload validation (Zod) and rate limiting (Upstash Redis sliding window).
   - Generate SEO-optimized JSON-LD Schema (`AggregateRating` and `Review`) server-side for any given product ID.
   - Embeddable vanilla JavaScript widget (`/public/widget.js`) that injects review summaries, star icons, review lists, photo galleries, and submission forms onto any HTML page without external CSS dependencies (Shadow DOM encapsulation).

2. AUTOMATED MODERATION ENGINE:
   - Webhook or background job triggered on review submission.
   - Run submission text through basic profanity filters and simple sentiment scoring.
   - Automatically transition status to 'APPROVED' if rating >= 3 and zero flagged keywords; otherwise set to 'PENDING'.

3. ADMIN DASHBOARD:
   - Clean UI to list, filter (by status, rating, SKU), search, batch-approve, and batch-reject pending reviews and Q&A.
   - Reply interface allowing store managers to publish official responses to reviews and questions.

4. POST-PURCHASE TRIGGER SIMULATOR:
   - Webhook endpoint (`POST /api/v1/webhooks/order-fulfilled`) that accepts order payloads, logs pending review request triggers, and generates signed review submission links.

OUT OF SCOPE:
- Retail network syndication protocols or multi-retailer distribution feeds.
- Complex ML-based image moderation models.
- Native mobile SDKs (iOS/Android).

Ensure zero runtime errors, include full Prisma schemas, and provide copy-pasteable JavaScript snippet code for embedding the widget on standard ecommerce store PDPs.

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