Maintain · commerce client · 2026
AI Product Catalog Pipeline for Drop-ship E-commerce
Built an end-to-end AI pipeline that turns raw product photos into live, SEO-ready Shopify listings with a human-in-the-loop approval gate. Client had access to a manufacturer catalog in China and needed to scale listing creation without hiring a content team.
- Operator uploads product photos into a single intake location.
- Pipeline sends images to the OpenAI API for vision analysis, returning structured JSON.
- Google Apps Script writes generated content — title, description, SEO terms, tags, color, price — into a review sheet.
- Reviewer ticks an approval checkbox on rows they accept.
- Approved rows auto-populate to Shopify as live products.
