惯性聚合 高效追踪和阅读你感兴趣的博客、新闻、科技资讯
阅读原文 在惯性聚合中打开

推荐订阅源

V
Visual Studio Blog
U
Unit 42
让小产品的独立变现更简单 - ezindie.com
让小产品的独立变现更简单 - ezindie.com
The GitHub Blog
The GitHub Blog
Microsoft Azure Blog
Microsoft Azure Blog
有赞技术团队
有赞技术团队
Stack Overflow Blog
Stack Overflow Blog
爱范儿
爱范儿
博客园 - 司徒正美
Vercel News
Vercel News
I
InfoQ
GbyAI
GbyAI
C
Check Point Blog
B
Blog RSS Feed
Martin Fowler
Martin Fowler
B
Blog
MyScale Blog
MyScale Blog
腾讯CDC
博客园 - Franky
Blog — PlanetScale
Blog — PlanetScale
钛媒体:引领未来商业与生活新知
钛媒体:引领未来商业与生活新知
Hugging Face - Blog
Hugging Face - Blog
freeCodeCamp Programming Tutorials: Python, JavaScript, Git & More
博客园 - 三生石上(FineUI控件)

DEV Community

Authentication Security Deep Dive: From Brute Force to Salted Hashing (With Java Examples) Why AI Systems Don’t Fail — They Drift Spilling beans for how i learn for exam😁"Reinforcement Learning Cheat Sheet" I Replaced Chrome with Safari for AI Browser Automation. Here's What Broke (and What Finally Worked) How Python Borrows Other People's Work The $40 Architecture: Processing 1 Billion API Requests with 99.99% Uptime Vibe Coding: A Workflow Guide (From Zero to SaaS) Most webhook security guides protect the wrong side. The scary part is delivery. Headless CMS for TanStack Start: Build a Blog with Cosmic EU Age Verification App "Hacked in 2 Minutes" — What Actually Happened Comfy Cloud’s delete function does not actually remove files Running AI Models on GPU Cloud Servers: A Beginner Guide Event-driven media intelligence with AWS Step Functions and Bedrock I scored 500 AI prompts across 8 quality dimensions — here's what broke How to Call Google Gemini API from Next.js (Free Tier, No Backend Needed) The Portal Protocol: Reclaiming Human Connection in the Age of AI How to Fix Your Team's Scattered Knowledge Problem With a Self-Hosted Forum Intro to tc Cloud Functors: A Graph-First Mental Model for the Modern Cloud Designing Multi-Tenant Backends With Both Ownership and Team Access I Built a Neumorphic CSS Library with 77+ Components — Here's What I Learned PostgreSQL Performance Optimization: Why Connection Pooling Is Critical at Scale Cómo construí un SaaS multi-rubro para gestionar expensas en Argentina con FastAPI + Vue 3 🚀 I Built an Ethical Hacking Scanner Tool – Open Source Project I Replaced /usage and /context in Claude Code With a Single Statusline A Pythonic Way to Handle Emails (IMAP/SMTP) with Auto-Discovery and AI-Ready Design I Collected 8.9 Million Polymarket Price Points — Here's What I Found About How Markets Really Move EcoTrack AI — Carbon Footprint Tracker & Dashboard Everyone's Using AI. No One Agrees How. 5 self-hosted ebook managers worth trying in 2026 Building Your First AI Agent with LangChain: From Chatbot to Autonomous Assistant
How I built a Brazilian price comparator with AI across 6...
FabIAlista · 2026-04-26 · via DEV Community

FabIAlista

How I built a Brazilian price comparator with AI across 6 retailers

Brazilian e-commerce is fragmented. The same product costs different prices in Amazon BR, Mercado Livre, Carrefour, Magalu, Shopee, and Americanas — sometimes a 40% difference. Existing comparators are slow, full of ads, and miss most of the catalog.

So I built FabIAlista — a free, AI-powered price comparator with 9.000+ products across all six retailers, an OCR scanner that reads handwritten shopping lists, and a conversational AI that suggests substitutes.

What it does

  • Compare prices in real-time across 6 stores
  • OCR scanner: photograph a handwritten/printed shopping list, get the cheapest store
  • AI chat (Portuguese): "I want to make a barbecue for 10 people, R$ 200 budget" → it builds the list
  • Unified affiliate checkout: one click sends each item to the best store
  • Cashback integration with Awin, Lomadee, Admitad
  • 100% free, no signup wall, LGPD-compliant

The stack

  • Frontend: React + Vite + Tailwind, deployed on Hostinger VPS via Nginx
  • Backend: Node.js + Express, PostgreSQL, Redis cache, PM2 cluster
  • AI: Local Ollama (qwen2.5:14b) + fine-tuned fabia-8b, with Gemini API as free fallback
  • OCR: Tesseract 5.3.4 with por+eng traineddata, Sharp preprocessing
  • Vector search: ChromaDB on port 8200, indexed with 4068 products
  • SEO: 134 pre-rendered static HTML pages, schema.org Product + BreadcrumbList + AggregateRating, IndexNow API pushing to Bing/Yandex/Naver

Hard problems I solved

1. Multi-token search

Brazilian users search like "café 3 corações 500g torrado moído" — six tokens. Most engines OR these. I split queries into tokens and require all of them present, case-insensitive, accent-stripped. Result: precision went from 60% to 94%.

2. Affiliate URL drift

Every retailer changes their URL format every few months. Hardcoded affiliate links rotted constantly. Solution: always regenerate URLs at runtime via buildAffiliateUrl(product, store). Never persist them. Lost 3 weekends to this lesson.

3. Image CDN blocks

images-na.ssl-images-amazon.com returns 404 for hotlinked product images. I had to whitelist only the CDNs that actually allow embedding: vtexassets.com, vteximg.com.br, mlstatic.com, kabum.com.br, alicdn.com. Plus a fallback chain with WebP → AVIF → PNG.

4. SEO from zero

Started indexed with 0 pages on Google. Today: ~9.000 indexed across Google, Bing, Yandex. Key tactics:

  • 134 static pre-rendered HTMLs (one per category, brand, blog post, comparison page)
  • Sitemap split: products, categories, brands, pages, blog, images, local, comparisons
  • IndexNow API pushing every product update to Bing+Yandex+Naver in <1 sec
  • Schema.org Organization + WebSite + SearchAction + Product + BreadcrumbList

What I learned

  • Brazilian users don't trust signup walls. Bouncing rate dropped 60% when I removed forced login.
  • Local LLMs beat cloud for cost when you have GPU. RTX 5070 Ti runs qwen2.5:14b at ~8s/response, vs $0.003/req on Claude. Break-even at 100 reqs/day.
  • Scraping is a dead-end. Switched to official affiliate APIs everywhere. More stable, legal, monetizable.
  • Schema markup moves the needle. AggregateRating + Product schema added rich snippets that lifted CTR ~30%.

What's next

  • Mobile app (React Native + Expo) with native camera OCR
  • Voice search ("Alexa, what's the cheapest rice today?")
  • Black Friday Brazil 2026 dashboard (price history per SKU, alerts at -30%)

Try it out: https://www.fabialista.com.br

Feedback welcome — especially from Brazilians who've fought e-commerce price chaos.


Built solo in Recife-PE, Brazil.