B2B Wholesale Ecommerce Website – Google Sheets Apps Script

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.

What it does

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.

Highlights

• Storefront with news ticker, search, category filters, unlimited banners and an editable FAQ block
• Product cards carrying a size chart, multiple photos and an optional YouTube demo video
• Orders from storefront checkout and from quotations land in one list, with chevron pipeline filters and a full timeline
• Payments recorded against an outstanding balance, invoices issued and emailed, balances payable from the invoice
• Returns with line picking, a refund toggle and mark refunded / replaced / received / rejected
• A print-jobs module for custom artwork orders — artwork file, proof mockup, vendor, customer approval, printing status
• Customer portal with orders, favourites, saved addresses and profile
• Dispatch with AWB tracking and automatic shipping emails

The AI assistant

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.

Who it is for

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.