A bulk-order ecommerce portal built for wholesalers, running entirely on Google Sheets and Apps Script. A buyer lands on the storefront, opens a product and fills in a colour-and-size quantity matrix — and as the quantity climbs, tier pricing drops the rate automatically. The cart slides in, a pin code calculates shipping, and the order can be printed, sent over WhatsApp, or checked out on the spot as a guest.
This is built around how wholesale actually works, not retail. Orders are entered as a grid rather than one item at a time. Prices move in slabs — 1 to 19 pieces at one rate, 20 and above at another — and the total recalculates live. Shipping is worked out by zone and pin code, with a free-above threshold and a flat charge below it. Buyers who want a formal quote get one: the admin builds a quotation with searchable products, custom terms and internal notes, and converts it to an order in one click when it is accepted.
An Ask AI chatbot answers buyer questions — payment terms, bulk discounts — from a knowledge base you maintain, using your own Gemini API key and chosen model. Conversations can be saved back to the sheet so you can see what buyers keep asking.
Wholesalers, distributors, garment and textile suppliers — any business taking large repeat orders from trade buyers who need quantity grids, slab pricing and quotations rather than a single Add to Cart button.
| Version | v1.0 |
| Published | May 10, 2026 |
| Platform | Google Apps Script |
| Database | Google Sheets |
| Category | E-commerce |
| Tags | |
| Video | Watch walkthrough |
| License | Regular License |
| Code.gs Files | Complete Apps Script source code files |
| HTML Files | All HTML template files included |
| Google Sheet | Your own copy with all data and scripts |
| Setup Guide | Step-by-step video tutorials included |
| 6 Months Support | Bug fixes, tweaks, and guidance — all free |
| Free Updates | All future updates included at no extra cost |
We don't just deliver and disappear — every project comes with 6 months of free support. Bug fixes, small tweaks, and guidance included. Choose us without any worry.
What We Customize
20-30% advance to start • Clear pricing before we start • 6 months free support after delivery
What buyers of this file added to the same order
Petrol Station Management System in Google Sheets (Shifts, Tanks & Accounts)
2 buyers took both
How to Build a Full HR & Payroll ERP with Google Apps Script and React | Salary Slip + Attendance
2 buyers took both
Build a Gym Management System with Claude Code & Google Sheets
2 buyers took both
What buyers and viewers say about Build a B2B Ecommerce Web Portal with Gemini AI + Google Sheets.