Ophir Ventures — Product Catalogue v4641

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 ✓

Supplier name

Seller / contact person

Shipment date

Local forwarder

Forex rate (USD→PHP)

Shipping fees for this shipment

Origin delivery fee

Import / intl freight

Local shipping fee

Custom declaration fee

Misc / other fees

Total fees (PHP)

₱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

SI-0001

Invoice # (editable)

Status

Customer details

Customer / Contact name

Company name

Address

Phone / Mobile

Email address

Salesperson

Sale date

Items to sell

Discount (optional)

Type

Value

Apply to

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

Customer / Contact name

Company name

Address

Phone / Mobile

Email address

Salesperson

Quote date

Valid until

Notes

Show warehouse & location in print Include location

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 product

Select a product to see current location

New warehouse (+ new)

New location (+ new)

Notes (optional)

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

Filter by category

Filter by brand

Filter by warehouse

QR size

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.

User accounts & roles

Add users and assign roles. Each user gets a 6-digit PIN to log in.

Role permissions

${[ ['Dashboard & reports','✓','✓','✓'], ['View inventory','✓','✓','✓'], ['See WUC & profit','✓','✗','✗'], ['Sell items / Invoices','✓','✓','✗'], ['Quotations','✓','✓','✗'], ['Sales log','✓','✓ (own)','✗'], ['Receive shipments','✓','✗','✓'], ['Transfer stock','✓','✗','✓'], ['QR Codes','✓','✓','✓'], ['Import / Export','✓','✗','✗'], ['User management','✓','✗','✗'], ['Edit products & prices','✓','✗','✗'], ].map(([f,a,s,w])=>``).join('')}

Feature	Admin	Sales	Warehouse
${f}	${a}	${s}	${w}

In stock only

How to share this app

Runs entirely in your browser — no server needed. Choose a sharing method:

Export your data