Stock reconciliation — received vs sold vs on-hand
Low stock alerts
Recent sales
Stock by brand
Product
Category
Brand
USD
WUC (₱)
Sell (₱)
Stock
UOM
Warehouse
Location
Date
Shipment details & fees
✓ Formula validated (from image):
Multiplier = Total Fees (PHP) ÷ Total Order Value (PHP)
Landed Cost = PHP unit cost × (1 + Multiplier) Example: ₱846.08 × (1 + 0.035939) = ₱876.48 ✓
Shipping fees for this shipment
₱0.00
Items in this shipment
Shipment summary
Total fees (PHP)₱0.00
Total order value (PHP)₱0.00
Multiplier0.000000 (0.00%)
Recent shipments
Sales Invoice
Sales Invoice
SI-0001
Customer details
Items to sell
Discount (optional)
Subtotal₱0.00
Total discount-₱0.00
Cost of goods₱0.00
Grand total₱0.00
Total profit₱0.00
Summary
Today's invoices
All saved invoices
Create quotation
Customer details
Show warehouse & location in print
Items
Total₱0.00
History
Transfer / assign stock location
Update the warehouse and location for any existing stock item. Use this to assign items that have no location yet, or move stock between locations.
Select a product to see current location
Transfer log
Items without location
Date
Invoice #
Customer
Items
Subtotal
Discount
Total
Profit
Shared database file (ophir_data.json)
Store ophir_data.json in Google Drive, a shared folder, or a USB drive.
Every person opens this HTML file, then loads the shared JSON — all working from the same data.
After changes, save it back to the same location.
1. Open database
Load ophir_data.json from Google Drive or shared folder
2. Save database
Save updated ophir_data.json — replace the file in your shared folder
No database file loaded yet. Open ophir_data.json from your shared location.
How to set up shared access
1
First time: Click "Save ophir_data.json" → save the file to your Google Drive folder or shared network folder
2
Share the HTML file (this file) with your team via WhatsApp, email, or put it in the same shared folder
3
Each user: Opens the HTML file → goes to Import/Export → Database file → clicks "Open ophir_data.json" → picks the file from Google Drive (desktop app) or shared folder
4
After making changes: Click "Save ophir_data.json" → save over the same file in Google Drive. Other users open the updated file to get latest data.
Tip: Use Google Drive Desktop app (not the browser) so the shared folder appears as a real folder on your computer — making it easy to open and save files directly.
Import products from CSV
Upload a CSV. New products added; existing IDs updated.
Drag & drop CSV or JSON here
.csv for products · .json for full backup
Receipts
Products
Sales
Quotations
Full backup
🗃 Shared database file
Download ophir_data.json and put it in Google Drive or a shared folder. All team members open the same file. See the Database file tab for full instructions.
Browser backup (this device only)
Data is also auto-saved to this browser. Works offline but only on this device/browser.
Products
Sales
Quotations
Full backup
Download import template
CSV with correct headers + 3 example rows. Uses the shipping multiplier formula.
Generate product QR labels
Shipment receipt QR codes
Stick on boxes or packaging. Scanning shows the full shipment details.
Quotation QR codes
Attach to printed quotes. Scanning shows the quote summary and contact details.
Sales invoice QR codes
Attach to printed invoices. Customers scan to see invoice summary and payment info.
How to share this app
Runs entirely in your browser — no server needed. Choose a sharing method:
