Can I vibe code Reviews.io?

Build a self-hosted E-Commerce Review Collection and On-Site Widget System using Node.js, Express, PostgreSQL, Prisma ORM, and Tailwind CSS, designed to replace core Reviews.io functionality.

CORE REQUIREMENTS AND DATA MODEL:
1. Database Entities:
   - Store: id, name, domain, api_key, webhook_secret, settings (JSON).
   - Order: id, store_id, external_order_id, customer_email, customer_name, line_items (JSON), order_date, status, invite_scheduled_at, invite_sent_at.
   - Review: id, store_id, order_id, product_id, reviewer_name, reviewer_email, rating (1-5), title, body, status ('pending', 'approved', 'rejected'), photos (array of S3 URLs), video_url, verified_purchase (boolean), created_at.
   - Reply: id, review_id, author_name, body, created_at.

2. Webhook Ingestion & Job Queue:
   - Construct a `/api/v1/webhooks/shopify/orders-fulfilled` endpoint that verifies HMAC signatures from Shopify/WooCommerce webhooks.
   - Parse order details and schedule a delayed background job (using BullMQ and Redis) set to trigger review request emails N days after order fulfillment (configurable per store, default 7 days).
   - Deduplicate orders using `external_order_id`.

3. Review Collection & Submission Flow:
   - Provide a unique tokenized collection URL (`/collect/:invite_token`) sent via email (using Resend or SendGrid API).
   - Form interface allows rating overall experience (company review) and individual product items (product reviews), adding text, custom tags/attributes (e.g. "Fit: True to Size"), and uploading image attachments directly to S3/Cloudflare R2 via presigned URLs.
   - Mark reviews from tokenized invites as `verified_purchase = true`. Allow unverified submissions through a public form endpoint if configured.

4. Embeddable Frontend Widgets & Rich Snippets API:
   - Build a lightweight JS widget loader (`/widget.js`) that renders cleanly on storefronts without external framework dependencies.
   - Component 1: Product Page Review Widget (star summary, filterable review list with photos, star distribution histogram).
   - Component 2: Floating Site Rating Badge (shows average aggregate rating and total verified reviews).
   - API Endpoint: `/api/v1/public/reviews?product_id=X&domain=Y` returning review data alongside pre-formatted JSON-LD AggregateRating schema (`https://schema.org/AggregateRating`) for Google Organic Rich Snippets.
   - Implement caching headers (Cloudflare edge-compatible or Redis API response caching) to guarantee sub-50ms response times.

5. Admin Dashboard:
   - Overview metrics: Total Reviews, Average Rating, Response Rate, Review Invite Conversion Rate.
   - Review Moderation Queue: Bulk approve/reject, flag spam, reply to reviews, export reviews to CSV.
   - Widget Customizer: Visual preview to edit star colors, font styling, CSS overrides, and display settings.

OUT OF SCOPE:
- Google Seller Ratings official syndication (requires Google Partner API licensing).
- SMS campaign sending engines or carrier routing (stick to email triggers).
- Native iOS/Android SDKs.

FAILURE MODES TO PREVENT:
- Unchecked upload endpoints allowing direct backend file streaming (use direct browser-to-S3 presigned URLs with strict mime-type checks).
- Widget rendering blocking core storefront page loads (widget script must load async/defer and render into shadow DOM or isolated container).

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