High-Performance Organic Foods Storefront & Headless Google Sheets CMS

Executive Summary: Engineered a lightweight, high-conversion digital storefront and catalog for Indus Natural Store, an artisanal retailer specializing in pure ghee, raw organic honey, premium dry fruits, and cold-pressed organic staples. The solution eliminated recurring monthly SaaS platform subscriptions while enabling non-technical owners to manage products, pack sizes, and prices instantly through Google Sheets.

The Challenge: The brand required a fast, clean digital catalog to display organic food products, purity certifications, and varying pack sizes (e.g., 250g, 500g, 1L) without the high overhead, complex inventory databases, or checkout friction typical of monolithic e-commerce platforms.

Technical Architecture & Execution: • Headless Google Sheets Engine: Connected the frontend directly to a structured Google Sheets backend via REST APIs, allowing the client to update stock, seasonal honey harvests, batch ghee pricing, and promotional banners in real time without redeploying code. • Lightweight & Dependency-Free UI: Built with Vanilla JavaScript, semantic HTML5, and modern CSS to deliver sub-second mobile load speeds and zero third-party framework overhead. • Conversational WhatsApp Order Routing: Implemented dynamic cart state management with one-click WhatsApp routing, automatically converting cart selections, item weights, and total values into a pre-formatted, error-free order message. • Dynamic Filtering & Pack-Size Selectors: Built instant client-side category sorting (Ghee, Honey, Dry Fruits, Cold-Pressed Oils) and responsive pack-variant selectors for swift customer checkout.

Tech Stack & Tools: Vanilla JavaScript, HTML5, CSS3, Google Sheets API, REST APIs, WhatsApp Integration.

Business Outcomes: • Zero recurring monthly e-commerce platform fees. • 100% no-code inventory updates managed entirely through spreadsheets. • Direct-to-consumer conversational ordering with frictionless mobile conversion.