Sacramento Groceries | Price Comparison App

The problem

Grocery prices in Sacramento vary dramatically between stores, but there is no good way to compare them. National deal apps like Flipp focus on chain circulars and miss the ethnic groceries, discount chains, and specialty shops that Sacramento shoppers actually use. So you either drive to three stores hoping to save money or just pay whatever your nearest one charges.

What I built

SacGroceries is a free price comparison platform that tracks 139,000+ products across 39 Sacramento-area stores. Search for any product, see prices from every store sorted by cost, and build shopping lists optimized by store and driving route. The platform covers 16 ethnic groceries, 5 discount chains, 4 premium markets, 3 warehouse clubs, traditional supermarkets, and specialty shops, from WinCo and Costco to Nugget Markets and Grocery Outlet.

Architecture

Edge computing: The entire backend runs on Cloudflare Workers with a D1 (SQLite) database. No servers to manage, no cold start delays, and API responses under 50ms because everything runs at the edge. The Hono framework handles routing, and TypeScript covers the full stack.

Data pipeline: Scheduled Workers running on cron triggers collect and normalize price data from store sources. An automated email pipeline processes 10+ weekly store circulars without manual intervention. Price data includes freshness metadata with color-coded indicators (fresh, aging, stale, outdated) so shoppers know exactly how current each price is. Older prices automatically purge after 6 months.

Client-side storage: Shopping lists persist in localStorage with IndexedDB for offline caching. The app works without installation, fully browser-based, with offline detection so saved lists are always accessible.

Key features

• Side-by-side price comparison across 39 stores with real-time search
• Shopping list builder with sequential product matching and unified multi-store view
• Weekly sale tracking from 10+ automated store circulars
• Recipe parsing that extracts ingredients from any recipe and matches them to store prices, with duplicate ingredient merging
• Price freshness indicators showing exactly how current each data point is
• Package size data for 48,000+ products enabling true unit-price comparison
• Community price submissions via web form and email, a “neighbors helping neighbors” model

Premium features

SacGroceries runs a freemium model at $2.99/month (or $24.99/year):

• Price history charts showing trends over time so shoppers can time purchases
• Smart list optimizer that factors in driving distances and current gas prices (via AAA data) to find the cheapest total trip, not just the cheapest per-item price
• Real driving distance calculations powered by OSRM routing
• Preferred store locations for personalized route optimization
• Price drop alerts with configurable thresholds

Content and community

The platform publishes weekly recaps analyzing price movements across Sacramento’s grocery market, plus monthly trend reports tracking category shifts across all 39 stores. The changelog documents the full development history from launch to current state.

The Sacramento angle

This project exists because I live in Sacramento and I got tired of overpaying for groceries. The store coverage reflects where Sacramento people actually shop, including the ethnic groceries on Stockton Boulevard, the discount chains in South Sacramento, and the premium markets in East Sac. National apps do not cover these stores. A local tool built by a local developer does.