Lot Scanner Pro

Quick Scan

Camera off

or type it in

Scan a tag or enter a Lot ID to log a sale or count.

New Shipment

Lot ID

Date received

Storage location

Product name

Supplier

Tracking mode

Yield rate

—

Total qty

—

Cost/unit

—

Cost paid (ETB)

Documentation status

Doc reference / notes

Lot Directory

0

Total Lots

0

Low Stock

0

No Docs

0

Value (ETB)

How to import: In Excel, go to Lot Register tab, press Ctrl+Shift+End to select all data, copy, then paste below.

Sync to Excel / Sheets

Each block copies as tab-separated text. Tap a block, then paste into the matching Excel column. Or use Push to Google Sheets if you have set up sync in Settings.

New Lots0

Lot Register tab

Sales0

Sales Log tab

Physical Counts0

Physical Count tab

Important: Only clear each section after you have successfully synced to Google Sheets or pasted the data into Excel and saved your workbook.

Lot Tags - Print Page

Log Sale

Lot

Date

Qty sold

Unit price (ETB)

Customer / notes

Physical Count

Lot

System shows as of last sync.

Count date

Physical count

Likely cause (if variance)

Notes

Counted by

Copy Manually

Auto-copy did not work. Tap the box below, select all, then copy.

Settings

Scan Behavior

After scanning a lot

Choose what happens immediately after a successful scan. "Auto-open" skips the result card and goes straight to logging.

Google Sheets Sync

Web App URL

Setup Guide

Open your Google Sheet (create one if needed).
Go to Extensions → Apps Script.
Delete the default myFunction and paste the script below.
Click Save (disk icon).
Click Deploy → New deployment.
Type "Lot Scanner Pro" in description.
Set Execute as: Me and Who has access: Anyone.
Click Deploy, then Authorize and allow permissions.
Copy the Web App URL and paste it above.

Apps Script Code:

Backup & Restore

Export creates a JSON file with all your data. Keep it safe. Import restores from that file.

Danger Zone

Edit Lot

Lot
Changes here update the local directory only.

Product Name

Storage Location

Selling Unit

Remaining Qty

Total Qty

Cost per Unit (ETB)

Documentation Status

Doc Notes

Edit Sale

Lot

Date

Qty sold

Unit price (ETB)

Customer / notes

Edit Count

Lot

Count date

Physical count

Likely cause

Notes

Counted by

Edit New Lot

Lot

Product Name

Date Received

Storage Location

Supplier

Tracking Mode

Cost Paid (ETB)

Documentation Status

Doc Notes