Gemstone Details
Add Gemstone
Collection
Inventory List
0 items visible
Advanced Search
| Image | SKU | Gem Type | Weight | Shape | Size | Color | Clarity | Origin | Treatment | Certificate | Location | Cost | Selling | Profit | Status | Notes | Actions |
|---|
Marketplace Copy
eBay / Etsy Listing
Review the generated copy before posting it online.
Import Stock
Excel Import Preview
Upload and Validate Stock Sheet
Excel import is enabled for the clean Gem Tracker sheet. PDF import is disabled for now.
Gem Tracker Excel Format
Use a sheet named Gem Tracker. The importer reads this sheet first and does not treat Sheet0 or Header Mapping as stock data.
Expected columns: SKU, Gem Type, Weight, Shape, Size, Color, Clarity, Origin, Treatment, Certificate, Cost Price, Selling Price, Status, Notes.
| Row Number | SKU | Gem Type | Weight | Shape | Size | Color | Clarity | Origin | Treatment | Certificate | Selling Price | Status | Import Status | Issue Details |
|---|
History
Import History
| Date / Time | File Name | Total Rows | Added | Updated | Skipped | Failed |
|---|
On Approval
Create Approval Note
Approval Items
Add Stones
Gem Type-
Weight-
Shape-
Size-
Color-
Selling Price-
Current Stock Status-
| SKU | Gem Type | Weight | Shape | Color | Qty | Price | Status | Action |
|---|
Reports
On Approval Records
Purchase Source / Supplier Report
Track supplier, GRN, buying date, cost, selling value, and expected profit by supplier.
| Supplier | GRN | Buying Date | Stones | Total Cost | Total Selling | Expected Profit | Sold Stones | Sold Profit |
|---|
Duplicate SKU Protection Report
This scan checks for repeated SKUs and suspicious SKU formatting before it causes stock confusion.
| SKU | Issue | Count | Matching Stones |
|---|
Overdue Approval Alerts
| SKU | Seller | Approval No. | Date Out | Due Date | Days Out | Value |
|---|
| Approval No. | Date | Due Date | Seller | Location | Status | Total | Remarks | Actions |
|---|
Stone History
Stone History Timeline
Select one SKU, then choose whether to see inventory changes or On Approval history for that stone.
Changes Made To This Stone
On Approval History Of This Stone
Seller Statements
Seller Statements
| Seller | Currently OUT | Stones Sold | Total Sold Value | Pending Value | Return Rate |
|---|
Finance
Invoices, Payments & Seller Ledger
Controlled Sale
Finalize Stone Sale
Finalize an approval sale or a direct stock sale. This updates inventory, profit, payment balance, approval history, and the audit trail together.
Finalized Sales Register
Every finalized sale keeps the original cost and selling figures for accurate profit and payment tracking.
| Invoice | Date | SKU | Buyer / Seller | Sale Price | Profit | Paid | Balance | Action |
|---|
Quick WhatsApp Message
Choose an approval note and generate a clean message with stones OUT, total value, and due date.
Payment Tracking
Record money received from sellers. Sold stones become debit entries, payments become credit entries.
Sales Invoice / Receipt
Sold stones are listed here. Print an invoice for one stone or all sold stones for a seller.
| Seller | Approval No. | Date | SKU | Gem Type | Price | Payment Balance | Action |
|---|
Seller Account Ledger
| Date | Type | Reference | Description | Debit | Credit | Balance |
|---|
Saved Payments
| Date | Seller | SKU | Due | Paid | Balance | Method | Notes | Actions |
|---|
Customers
Add Customer / Buyer
Buyer List
Saved Customers
| Name | Phone | Location | Wishlist | Notes | Actions |
|---|
Labels
Stone Labels / Barcode Print
Select stones and print 6 cm wide packet labels with SKU, gem details, and a QR code. In print preview, use Scale 100% and turn off Fit to page.
| Select | SKU | Gem Type | Weight | Certificate | Price |
|---|
Settings
Import Settings
Import is currently simplified for the clean Gem Tracker Excel sheet. PDF and raw ERP import can be added back after this Excel flow is stable.
Full Cloud Database
Push all operational records to Supabase or restore this browser from the latest cloud copy. Staff passwords stay local until secure Supabase Auth is enabled.
Backup & Restore
Download one JSON backup containing inventory, sellers, approvals, histories, customers, payments, sales, staff access, and settings. Restoring replaces the current local database only after confirmation.
Staff Access
| Username | Role | Permissions | Actions |
|---|
Audit Trail
| Date | User | Action | Record | Details |
|---|
Sellers
Add Seller / Sales Rep
Seller List
Saved Sellers
| Name | Phone | Location | Notes | Actions |
|---|