Can I vibe code StoreYa?

1. System Overview: Build a lightweight product feed generator and ad metrics reporting system using Next.js, Prisma, and PostgreSQL.

2. Data Model:
- Create Store: id, name, domain, API credentials.
- Create Product: id, title, description, sku, price, compare_at_price, inventory_quantity, image_url, google_product_category, active status.
- Create AdChannel: id, provider ('google' or 'meta'), account_id, access_token, refresh_token.
- Create AdMetrics: id, date, channel_id, spend, impressions, clicks, conversions, gross_revenue.

3. Feed Generation Endpoint:
- Implement `/api/feeds/google-shopping.xml` returning an XML document valid for Google Merchant Center.
- Include standard elements: g:id, g:title, g:description, g:link, g:image_link, g:availability ('in stock' vs 'out of stock'), g:price, g:condition ('new'), and g:brand.
- Revalidate the feed feed route or cache with a 1-hour revalidation window.

4. Analytics & Metrics Sync:
- Build an API route `/api/cron/sync-ad-metrics` triggered daily.
- Implement read-only OAuth connections to fetch daily spend and performance data from Google Ads API and Meta Marketing API.
- Calculate Blended ROAS = Total Store Revenue / Total Ad Spend.
- Render a simple dashboard displaying daily spend vs revenue charts using Recharts.

5. Safeguard Automation:
- If 3-day rolling ROAS falls below 1.5x, trigger an automated email alert via Resend to notify the operator to adjust campaign budgets manually.

6. Out of Scope:
- Programmatic campaign creation or automated keyword bidding adjustments (use native Google/Meta Ads UI for management).

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