E-commerce Product Database & Automation Development

Title: Build Product Database & Automation for E-Commerce Catalog

WHAT WE NEED
We're building an e-commerce product catalog and need help setting up a database system that ties together product info, content, and images.

Basically:

Create a master Excel file that holds product data (specs, pricing, descriptions, images)
Set up basic web scraping to pull product images and specs from websites
Integrate AI content generation to auto-fill product descriptions and SEO fields
Export everything in a format ready for our CMS (Sanity)
THE WORKFLOW
Excel → Supabase (our database) → Sanity (our CMS) → Website

THE WORK
Excel template — columns for product details, specs, pricing, images, SEO content
Image scraper — pulls images from websites, compresses them, organizes them
AI integration — auto-generates product descriptions, meta text, benefits
Supabase integration — data syncs from Excel to our Supabase account
CMS export — formats data for Sanity import (direct, no manual re-entry)
DELIVERABLES
Populated Excel file with products from different brand catalogues (PDFs ,jpg. etc)
Image database (organized, compressed)
Scraping script (documented so we can reuse it)
AI content generation setup (working, tested)
Supabase → Sanity export pipeline (automated, repeatable)
Clear documentation for independent operation
CRITICAL REQUIREMENT
We take full ownership of this tool after delivery. This means:

No ongoing dependency on external help
We should be able to add new products, run scrapers, and export to Sanity independently
All workflows must be simple, documented, and non-technical
We're "no-code" / "low-code" oriented — keep it straightforward
TECHNICAL SKILLS NEEDED
Web scraping (Python, Node.js, n8n, or similar)
Excel/CSV automation
API integration (Claude, OpenAI, or equivalent)
Supabase & Sanity API familiarity (basic)
Image processing