0
Item Codes
0
DOs Processed
—
Low / Negative
0
Categories
Quick Start
Welcome to CK Stock Manager. Use the sidebar to navigate.
1. Current Stock — Upload your STOCK_BALANCE_V2 Excel or manually adjust quantities.
2. Scan DO — Upload a Delivery Order PDF to extract items and deduct from stock.
3. Production — Connect Google Sheets for daily meat & sauce production templates.
Current Stock
No stock loaded
Drop STOCK_BALANCE_V2 Excel here or click to browse
.xlsx only · Overwrites current stock
Search for an item to edit its quantity.
Edit History
Cleared automatically whenever a new stock balance Excel is uploaded, since past edits no longer apply to the new baseline.
Loading…
| Code | Name | Category | Base Qty | Base UOM | Pack UOM | Packs on Hand |
|---|---|---|---|---|---|---|
| Upload stock to view inventory. | ||||||
Upload another STOCK_BALANCE_V2 Excel (same format as the Upload Excel tab) to compare it against what's
currently loaded. This is a standalone, one-off comparison — it does not
overwrite Current Stock, does not read the file used in the Upload Excel tab, and is not saved anywhere;
it's cleared if you leave this tab or reload the page.
Drop a STOCK_BALANCE_V2 Excel here or click to browse
.xlsx only · Compares against Current Stock only · Nothing is saved or overwritten
Packaging Reference
No packaging reference loaded
Upload your Product List Excel so the app knows exactly how much each packaging type holds per item
(e.g. 1 CTN of Cheese - Halloumi = 2160g). Without this, scanned DOs fall back to a single generic pack
size per item, which can be wrong when a code has multiple packaging options of different sizes.
Drop your Product List Excel here or click to browse
.xlsx only · Columns: Product code, Packaging · Overwrites packaging reference
Scan Delivery Order
PDF → Extract → Confirm → Deduct
Upload a Delivery Order PDF
DO-XXXXXX-XXXX-DOC format · Items deducted from stock on confirm
Take a photo of the Delivery Order
Opens your camera on mobile · Hold steady, good lighting, fill the frame
Upload a SALES_ANALYSIS report Excel to queue up stock deductions. Extracts Product Name, Product Code,
Do Date, Customer, Qty, UOM and SO Number, grouped below by SO Number — review and approve each one
independently. An approved SO Number never reappears, even if the report is downloaded and
re-uploaded again later the same day; that history resets when Current Stock is re-uploaded.
Upload a Sales Analysis Excel
.xlsx only · Already-approved SO Numbers are skipped automatically
No pending SOs
No pending Sales Analysis SOs — upload a report above.
Processed DOs / Processed SOs
None this session
No DOs processed yet.
🥩 Meat Stock Production
Not connected
Meat Handover Templates
No templates generated yet — sync from Google Sheets first.
🫙 Sauce Stock Production
Not connected
Sauce Handover Templates
No templates generated yet — sync from Google Sheets first.
📥 Receiving
Not synced yet
Pulls today-and-onward rows from the Meat Control V5 → Receiving sheet (Receive ID, Batch Received Date,
SKU Name, SKU Code, Invoiced (KG)) — uses the same script URL configured on the Meat Production page.
Approving a row adds its amount straight to that item's stock (converted through its Pack UOM for
manually-added rows, or straight KG for rows synced from the sheet). Once approved, a row is gone for
good and won't reappear even though it stays in the Google Sheet.
| Receive ID | Date | SKU Code | SKU Name | Amount | |
|---|---|---|---|---|---|
| No pending receiving rows — sync from Google Sheets first. | |||||
Every row approved into stock, most recent first. Cleared automatically on Current Stock re-upload, same as other history.
| Receive ID | Date | SKU Code | SKU Name | Amount | Approved By | Approved At |
|---|---|---|---|---|---|---|
| Loading… | ||||||
⚙ Admin
Manage user access
Add, edit, or remove users allowed to access this app, and manage their role. Changes take effect immediately — users will be able to log in (or be blocked) on their next login attempt.
Current Access List
Loading…