Can I vibe code Report Pundit?

Build a custom Shopify reporting app using Next.js (App Router), PostgreSQL (Prisma ORM), and Tailwind CSS.

1. DATA INGESTION ENGINE:
- Implement Shopify GraphQL API sync using the Bulk Operations API for historical backfills (Orders, Line Items, Products, Customers, Refunds, Draft Orders).
- Create webhooks for real-time updates: orders/create, orders/updated, inventory_levels/update.
- Store data in a normalized relational PostgreSQL schema. Maintain tables for: stores, orders, line_items, products, variants, customers, refunds, and metafields.

2. CUSTOM REPORT BUILDER:
- Build a UI with TanStack Table allowing users to select columns, apply filter groups (AND/OR logic), set dynamic date ranges, and re-order columns via drag-and-drop.
- Support calculated fields (e.g., Gross Margin = (Total Price - Cost per item) / Total Price).
- Allow saving report configurations as JSON objects in the database.

3. SCHEDULER & EXPORT ENGINE:
- Build a background job runner using BullMQ and Redis.
- Implement export formats: CSV, XLSX, and PDF.
- Support automated destinations: Email (via Resend), Google Drive (via Google Sheets API), and SFTP servers.
- Add a cron tab UI to specify schedule intervals (Daily at 8am, Weekly on Mondays, Monthly on the 1st).

4. EDGE CASES & RESILIENCE:
- Implement exponential backoff retry logic for Shopify API rate limits (GraphQL cost governance).
- Handle bulk dataset streams line-by-line using Node.js Streams to prevent out-of-memory errors on large CSV generations.
- Format non-standard currency fields and convert historical orders based on store currency settings.

5. OUT OF SCOPE:
- Do not build third-party ad network connectors (Meta/Google Ads) in phase 1.
- Exclude live chat embedded in the dashboard.

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