App · digital-templates

OptikaDesk PH - Private Google Sheets Web App

Every grade, frame, lens, lab job, and balance on one order row.

Private Google Sheets Web App: Track optical customers with eye-examination records, frame and lens stock, orders that pair a frame with a lens type, laboratory jobs sent out for grinding, downpayments, balances, and release.

One-time price₱699
Buy now
  • Purchase without creating an account
  • Access sent to your checkout email after confirmed payment
  • Support for missing or broken delivery links
Product overview

Know what happens next.

Private Google Sheets Web App: Track optical customers with eye-examination records, frame and lens stock, orders that pair a frame with a lens type, laboratory jobs sent out for grinding, downpayments, balances, and release.

Product typeApp
Categorydigital-templates
DeliveryDownload link by email
Fileoptikadesk-ph-web-app.zip · 157 KB
Version1.0
LicensePersonal one-business license
Account requiredNo, guest checkout is available
Details

What to know before you use it.

Private Google Sheets Web App: Track optical customers with eye-examination records, frame and lens stock, orders that pair a frame with a lens type, laboratory jobs sent out for grinding, downpayments, balances, and release.

Compatibility

Works with

  • A Google account with Google Sheets and Apps Script; owner-only deployment by default
  • Philippine peso reporting
  • Asia/Manila date examples
Before you start

Requirements

  • A Google account with Google Sheets and Apps Script; owner-only deployment by default
  • Basic source records for the workflow
Product questions

Before you buy

Are the other editions included?

No. This delivery contains only the separately sold Private Google Sheets Web App.

Is this official accounting or regulated software?

No. No clinical, optical, or medical advice, diagnosis, prescription validation, PhilHealth or insurance claim filing, optometry licensing or regulatory compliance, laboratory system connection, official receipts, or tax filing.

Can I resell or share it?

No. The license permits internal use and customization for one business only.

Can a customer order two pairs from one eye examination?

Yes. Both orders point at the same exam ID, and each carries its own frame, lens, discount, and balance.

What if the lab returns a wrong lens?

Set the lab job status to Returned to Lab and update the expected date. The order stays At Lab and the tracker keeps counting against the promised date.

Does it check the prescription or connect to the lab system?

No. It stores what you enter and computes prices, balances, and stock. It does not validate prescriptions or talk to any laboratory system.

Supporting guide

Learn more before you continue.

Read the linked article for additional context, instructions, or an editorial review of this product.

How to Track Optical Orders, Lab Jobs and Balances Without Losing a Pair cover
digital-templates

How to Track Optical Orders, Lab Jobs and Balances Without Losing a Pair

A records routine for optical shops in the Philippines: keep the eye record, price frame plus lens, follow the job to the lab and back, and collect the balance at release.

Read the guide
Share this product