12 Commits
Author SHA1 Message Date
Christian Vidal WolfandClaude Sonnet 4.6 2eed94b94b fix(dataProcessor): parse DD/M/YY dates from column C in sell-out CSV
Add support for European day-first date format (e.g. "23/2/26" = 23 Feb 2026)
in the sell-out CSV pipeline so months and years are correctly extracted from
column C of Amazon Sell Out 2023-2025.csv.

- normalizeMonth: detect DD/MM/YY when first part > 12, return "Mon-YY"
- mapRowToRecord: add 'C', 'Date', 'Fecha', 'DATA' to month column aliases
- validateSellOutHeaders: accept date columns as substitute for YEAR + MONTH

Co-Authored-By: Claude Sonnet 4.6 <noreply@anthropic.com>
2026-03-03 13:07:59 +01:00
christian.vidalandClaude Sonnet 4.6 17a3df9fb3 feat(bsr): fetch BSR.xlsx from Dropbox instead of local file
- Rewrite api/fetch-bsr.ts to proxy BSR.xlsx from the Dropbox URL,
  matching the same pattern as fetch-buybox.ts and other data sources
- Add /api/fetch-bsr proxy in vite.config.ts for local dev

Co-Authored-By: Claude Sonnet 4.6 <noreply@anthropic.com>
2026-03-02 18:37:39 +01:00
Christian Vidal WolfandClaude Opus 4.6 2bce0a839b feat: add Supabase vendor data integration (BSR, ratings, buy box)
- Create vendor_daily_data table schema and Supabase client service
- Add upload API route for Vendor Central CSV parsing and upsert
- Add VendorDataView with BSR trend, ratings, and buy box charts
- Integrate new Vendor tab into app navigation (desktop + mobile)
- Add vendor CSV upload card to FileUpload modal

Co-Authored-By: Claude Opus 4.6 <noreply@anthropic.com>
2026-02-20 13:19:25 +01:00
Christian Vidal Wolf 5e2abfb1e2 fix: read API key from process.env for Vercel builds 2026-02-10 15:32:14 +01:00
Christian Vidal Wolf a259538ff4 fix: exhaustive API key lookup and injection for Vercel 2026-02-10 15:24:52 +01:00
Christian Vidal Wolf 01026da882 fix: support both API_KEY and GEMINI_API_KEY in vite config 2026-02-10 15:18:49 +01:00
Christian Vidal Wolf 3a4410c3b5 Fix Buy Box warning detection for Spain (B0D3874WSD) and update Vite proxies 2026-02-05 10:48:37 +01:00
Christian Vidal Wolf e1e6f127be feat: Add UK inventory sync from Dropbox
- Create new API endpoint api/fetch-uk-inventory.ts
- Add processUKInventoryExcel function in dataProcessor.ts
- Update handleVendorStockFetch to load PANEU + UK in parallel
- Configure Vite proxy for UK inventory endpoint
- UK stock correctly populates 'uk' field in vendorStockMap
2026-02-02 09:24:49 +01:00
Christian Vidal Wolf 7e58e8aba4 feat: Sync PANEU inventory from Dropbox
- Add new API endpoint for PANEU stock from Dropbox
- Update handleVendorStockFetch to use new endpoint
- Configure Vite proxy for local development
2026-02-02 09:13:20 +01:00
Christian Vidal Wolf 84d0291360 refactor: simplified data loading with direct fetch endpoint 2026-01-17 11:12:39 +01:00
Christian Vidal Wolf 470db20458 feat: Automate Dropbox data loading with Vite proxy 2026-01-16 10:20:22 +01:00
Christian 9ba63ab8f8 feat: Initialize Craze Analytix project structure
Sets up the project with Vite, React, Tailwind CSS, Gemini AI integration, and necessary dependencies for data analysis. Includes initial configuration for TypeScript, Tailwind, and project metadata.
2025-12-11 11:25:26 +01:00