Gemstone Details
Add Gemstone
Collection
Inventory List
0 items visible
Advanced Search
| Image | SKU / Edit | 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
All completed changes save automatically to Supabase. Manual push and restore remain available for recovery and device setup.
Backup & Restore
Download one JSON backup containing inventory, sellers, approvals, histories, customers, payments, sales, and settings. Supabase Auth accounts are managed separately and passwords are never included.
Staff Access
Create each staff login here, choose its role, and click the access boxes that account should receive. Leave Password empty when editing if the password should stay unchanged.
| Username | Role | Permissions | Access | Actions |
|---|
Audit Trail
| Date | User | Action | Record | Details |
|---|
Sellers
Add Seller / Sales Rep
Seller List
Saved Sellers
| Name | Phone | Location | Notes | Actions |
|---|