Online Shopping Website by web app Script | Ecom Web With Google Sheet Inventory Management | C3

Version 2 of the eShop web app, rebuilt for shops that sell in bulk. The catalog lives in Google Sheets, the storefront reads it live, and the whole thing runs on Google Apps Script — no hosting bill, no database server, no platform commission.

Built for wholesale

Every product carries a price per unit, and the quantity dropdown is generated from the stock you actually hold, so a customer can never order units you do not have. Cross the bulk threshold and a 5% discount is applied automatically, with the new total shown before the order is confirmed. Set a product's stock to zero and it disappears from the storefront until you restock it.

Catalog and browsing

Products are grouped by category and subcategory — pick Electronics and the smartphones and laptops beneath it come with it — and a search box sits over the top. Each product shows a star rating you control from the sheet and, where you have supplied a link, a Live View button that sends the shopper to your own video review of that item. Shoppers can park items in a wishlist and move them into the cart later.

What you get

Three sheets do all the work: Products, Category and List Orders. Orders arrive as rows carrying the customer's name, contact and address, ready to filter or export. The layout is responsive, so the shop works on a phone as well as a desktop.