Need a customized project? We build it to your exact requirements.Contact us on WhatsApp

Free Wholesale Price Calculator – Google Sheets Apps Script

B33 Accounting & Finance Tools & Utilities Premium Plan Weekly Plan VIP Premium Plan
❤️
Need a Custom Business Solution?
Connect with us on WhatsApp to discuss your requirements. Our team will design and develop a tailored software solution aligned with your business workflow, operational needs, and growth objectives.
Wholesale Price Calculator Web App Tutorial | Easily Calculate Prices with Tax and Discounts | B33
You get
  • Google Sheet link
  • Source code file
  • Resale rights
  • Edit rights
  • Setup guide
  • AI setup help

Key Features

Product dropdown fed from your sheet Quantity and price entered per item Add Item for as many products as the order needs Running total updated as items are added Tax percentage applied to the total Discount entered as a cash amount not a percentage Final price shown after tax and discount Printable slip with shop name address and telephone Cash received line on the slip Materialize UI styling Sheet ID set in one place in the script Deploys as a Google Apps Script web app

Description

The counter calculator. A customer asks what twelve of these and five of those will come to — you pick the items, type the quantities, and the total is on screen with the tax and the discount already in it. No notepad, no phone calculator, no arithmetic in front of the customer.

Built for speed, not paperwork

Products come from a dropdown fed by your sheet, so nothing is typed. Enter the quantity and the price, press Add Item for the next one, and the running total moves as you go. It is deliberately lighter than an invoicing system: there is no customer record to create and no sale to save before you can quote a number.

Tax and discount the way shops actually do it

Tax goes on as a percentage — enter 18 and the total carries eighteen per cent. But the discount is a cash amount, not a percentage, because that is how it is negotiated at a counter: "I'll take fifty off." Handling the two differently is a small thing that makes the tool match the conversation instead of fighting it.

Print it if the customer wants it

A printable slip carries your shop name, address and telephone number, the items, the totals and a cash-received line — enough for a customer to take away, without pretending to be a tax invoice. The styling uses Materialize, so it looks presentable without design work.

Where it goes next

If you need the quote saved, stock reduced and the invoice emailed, the stock-aware invoice web app is the next step up. This one is for the moment before that — the quick price.

Requirements

  • A Google account (Gmail or Google Workspace)
  • Google Sheets and Google Apps Script — no hosting or server needed
  • A product list sheet feeding the dropdown
  • Your Sheet ID set in the script
  • Your shop name, address and telephone for the printed slip

What's Included

  • Complete Google Apps Script source code
  • Product dropdown driven by your sheet
  • Multi-item order calculator with running total
  • Percentage tax and cash-amount discount
  • Printable slip with shop details and cash received
  • Materialize UI styling
  • Google Sheets structure for the product list
  • Deployment walkthrough for publishing as a web app
  • Step-by-step video walkthrough of the full build
  • Free support from the developer

Item Details

Versionv1.0
PublishedAug 22, 2025
PlatformGoogle Apps Script
DatabaseGoogle Sheets
CategoryAccounting & Finance, Tools & Utilities
Tagswholesale price calculatorwholesale price calculator google sheetsprice calculator web appprice calculator google apps scriptorder total calculator with taxtax and discount calculatorshop billing calculatorquotation calculator google sheets
VideoWatch walkthrough
LicenseRegular License
Subscription Verification Required
This is a free file. Subscribe to our YouTube channel to unlock the source code + Google Sheet. One click — no payment. Google only confirms you are subscribed.
Verify Now
Free download

Subscribe & Unlock Source Code

Subscribe on YouTube, then verify with one click. No payment, no card. Google is used only to confirm your subscription.

What you get

  • Code.gs + HTML filesThe complete Apps Script project
  • Google SheetYour own copy with the data
  • Setup guideInstall steps from start to finish

Not subscribed yet? Subscribe to our channel

Browse More Free Files
Custom development

Need this customized for your business?

Extra modules, your branding, integrations or reports built on top of this file. You get a clear quote and timeline before any work starts, and support after delivery.

400+Projects delivered
91+Countries served

20–30% advance to start · Clear quote before work begins · Support after delivery

What we customize

  • Features & functionsNew features, changes to existing scripts, custom formulas and automations
  • API & integrationsWhatsApp, payment gateways, CRM and more
  • Design & UI changesYour branding, layout redesign, dark mode, mobile layout
  • Full custom projectsDashboards, billing, inventory, CRM, built from scratch
Free
Source Code File

People choose these

Paid picks from the same category

Grocery Store POS System with Barcode Scanner | Google Sheet POS + Apps Script + AI Grocery Store POS System with Barcode Scanner | Google Sheet POS + Apps Script + AI 385 views this month Apps Script How to Build an App with Claude AI: Complete Church Management System in Google Sheets How to Build an App with Claude AI: Complete Church Management System in Google Sheets 187 views this month Apps Script Manage Your Installments Like a Pro: Complete Web App Demo Manage Your Installments Like a Pro: Complete Web App Demo 216 views this month PHP

Reviews & Feedback

What buyers and YouTube viewers say about this project.

Sort
@VIVEKSINGH-cr8ql via YouTube
Maine bahut sare coode le rakkhe bhaiya app se 😊😊😊😊😊😊😊😊😊
@VIVEKSINGH-cr8ql via YouTube
Nice Work sir you are great