| # | Phone model | CASE | GLASS | Sheet row |
|---|
Orders → Picking list
Upload a Pancake order export (.xlsx/.csv: Order ID, Products, Status, Note) or a simple list (Order ID | Phone model | Qty). One sold case = 1 CASE + 1 GLASS. Staff can download the list; only Admin can deduct stock.
Drop the order file here or click to choose
Drop the Excel file here or click to choose
Accepts the Stock_In_Out ledger (tabs STOCK_OUT / STOCK_IN: Phone model + Type + Qty) or a simple file with columns Phone model, Case qty, Glass qty.
Accepts the Stock_In_Out ledger (tabs STOCK_OUT / STOCK_IN: Phone model + Type + Qty) or a simple file with columns Phone model, Case qty, Glass qty.
| # | Phone model | Sold | /day | CASE | GLASS | Days left | Runs out | Suggest CASE | Suggest GLASS | Status |
|---|
Applied receipts
| # | Time | Type | File | Note | Lines | CASE | GLASS | Status |
|---|
Google Sheet connection
Access PINs
Admin PIN = full access. Staff PIN = Stock tab + Orders → Picking list (download only, no stock deduction).
Reorder defaults
How this version protects the stock
- Duplicate check is by whole file only (same file already applied and not undone → warning). Lines are never skipped because a similar line existed in another day's receipt.
- Undo returns exactly the amounts that were written (recorded per line), and a receipt can be undone only once.
- Writing runs in the background with a receipt key; if the connection drops, the same key is retried and the Apps Script refuses to write twice. The receipt is recorded before writing starts.
Server version: kho-v2 2026-09-24