{{adminTitle}}
24K ${{fineRate}}/g · 14K ${{g14}}/g☼
{{notifUnread}}
NOTIFICATIONS
Mark all read
Nothing new.
{{n.title}}
{{n.body}} · {{n.when}}
DJ
MASTER RATES — EVERY PRODUCT REPRICES INSTANTLY
Gold 24K fine · USD / g
Silver 925 · USD / g
Platinum · USD / g
{{k.k}}
${{k.v}}/g
{{s.n}}
{{s.l}}
CATALOG VIEWS — LAST 12 DAYS
RECENT ACTIVITY
{{a.who}} {{a.what}} · {{a.when}}
{{prodCount}}
{{c.company}} · {{c.country}} · applied {{c.when}}
{{c.contact}} · {{c.email}} · {{c.type}}
No pending applications — all caught up.
{{c.company}} · {{c.country}} · applied {{c.when}}
{{c.contact}} · {{c.email}}
{{c.type}}
No rejected applications.
Posts are published to /blog with structured data, sitemap and RSS generated automatically.
POST & SEO FIELDS
POST TITLE (H1)
URL SLUG
FOCUS KEYWORD
META TITLE · 40–60 CHARACTERS
META DESCRIPTION · 120–158 CHARACTERS
COVER IMAGE ALT TEXT
GOOGLE RESULT PREVIEW
{{serpUrl}}
{{serpTitle}}
{{serpDesc}}
SEO CHECKLIST
{{seoScore}}
{{ck.ic}}{{ck.l}}
CAD requests
{{cadNewCount}} new · customers expect a CAD preview within 24–48 hours
No requests yet. They arrive from the “Request custom quote / CAD preview” button on any design. If this stays empty, run patch_cad_v2_7.sql in Supabase.
{{cr.who}}
{{cr.status}}
{{cr.when}} · {{cr.design}}
{{cr.target}}
{{cr.brief}}
{{cr.email}} {{cr.phone}}
Ready stock
{{stockReadyTotal}} pieces across {{stockSkuCount}} SKUs · everything else shows “made to order · 8–12 days”
No SKUs yet — add designs first, or press Refresh. If this stays empty, run patch_stock_v2_2.sql in Supabase.
Tap the number to type an exact quantity. Buyers see a green “Ready to ship” badge and can filter the catalog to ready stock only.
{{g.title}}{{g.note}}
⬆
{{sl.name}}
{{sl.note}}
Click a status to advance it: NEW → QUOTED → CONFIRMED → SHIPPED. Each step emails the client automatically.
{{f.title}}
DESIGN
DESIGN NO. *
PRODUCT NAME
CATEGORY
SUB-CATEGORY
DIAMONDS
{{d.pos}}
TOTAL CARAT
PRICE / CARAT $
COLOUR
CLARITY
SIZE MM
SHAPE
LAB
Leave carat empty for a position this design does not use.
METAL & WEIGHT
METAL
GROSS WEIGHT g
COLOURS OFFERED — same weight for each
MAKING & MEDIA
MAKING CHARGE $ / GRAM
PHOTO FOLDER LINK (optional)
Bulk upload
STEP {{uStep}} / 3
{{uFileLabel}}
click to choose your stock sheet (.xlsx / .csv)
COLUMNS READ: NO. | Solitaire / Accent / Side diamond carat + details + price per carat | Making charge per gram | Gold karat | Gross weight | Folder link — blank cells carry down, totals are recomputed_usd | moq | cert | metals_available
Choose photos (optional) — named by design number
R-1_1.jpg · R-1_2.jpg · R-1_loop.gif · R-1_cert_solitaire_LG123.pdf — they attach themselves
📁 {{m.folder}}
{{m.files}}
{{m.status}}
{{uValid}} rows valid · {{uFlag}} rows with errors — error rows are skipped, warnings still import. {{uProgress}}
{{t.label}}{{t.n}}
No price requests here yet
Every time a buyer presses Request price on a design, it lands here with the design, the metal, the quantity and their contact details — instead of an email you have to dig out of your inbox.
{{r.ref_no}}
{{r.stLabel}}
· {{r.assigned_name}}
{{r.when}}
{{r.company_name}}
{{r.contact_name}} · {{r.contact_email}} · {{r.contact_phone}}
{{r.style_code}}
{{r.design_name}}
{{r.specLine}}
QUANTITY
{{r.quantity}} pcs
THEIR TARGET
{{r.targetLabel}}
WE QUOTED
{{r.quotedLabel}}
NOTES
{{r.note_count}}
{{r.spec_note}}
{{n.body}} — {{n.author}}, {{n.when}}
{{t.label}}
Nothing on the list
Follow-ups you create from a price request, a quote or a client land here with a due date, so a warm lead does not go quiet for three weeks.
{{t.tick}}
{{t.title}}
{{t.dueLabel}}
{{t.priLabel}}
← All clients
{{c3Company}}
{{c3Sub}}
{{c3Status}}
Last seen {{c3LastSeen}}
{{k.v}}
{{k.l}}
{{t.label}}{{t.n}}
Nothing recorded for this client yet.
The timeline starts from the day activity tracking was switched on — there is no earlier history to show.
The timeline starts from the day activity tracking was switched on — there is no earlier history to show.
{{f.when}}
{{f.text}}
{{f.meta}}
Nothing here for this client.
{{r.a}}
{{r.b}}
{{r.c}}
{{r.d}}
← Back to products
{{paCode}}
{{paName}}
{{k.v}}
{{k.l}}
WHO IS INTERESTED?
No recorded interest in this design yet.
Views and favourites start counting from the day tracking was switched on.
Views and favourites start counting from the day tracking was switched on.
{{c.company}}
{{c.country}} · last seen {{c.when}}
INTEREST BY COUNTRY
{{r.label}}
{{t.label}}
Working it out…
{{k.v}}
{{k.l}}
{{k.sub}}
{{tb.title}}
Export CSV
{{tb.emptyMsg}}
{{r.a}}
{{r.b}}
{{r.c}}
← All CAD requests
{{cdRef}}
{{cdSub}}
{{cdStage}}
{{cdDue}}
STAGE
{{o.label}}
DESIGNER
{{o.label}}
PRIORITY
{{o.label}}
DUE
THE BRIEF
{{cdBrief}}
CAD VERSIONS
Every upload is kept. Nothing is ever replaced.
No CAD uploaded yet.
The first file you add becomes version 1.
The first file you add becomes version 1.
V{{v.no}}
{{v.decision}}
{{v.when}} · {{v.by}}
Open file
Approved
Revision
Rejected
{{v.note}}
{{v.decisionNote}}
{{f.label}}{{f.n}}
Nothing here.
CAD requests arrive from the Custom design form on the website.
CAD requests arrive from the Custom design form on the website.
{{r.ref}}
{{r.when}}
{{r.company}}
{{r.designer}}
{{r.due}}
{{r.versions}}
CAD
{{r.stage}}
← Back to stock
{{smSku}}
{{smName}}
{{b.n}}
{{b.label}}
BUCKET
{{o.label}}
CHANGE BY
REASON
MOVEMENT HISTORY
Nothing recorded yet.
History starts from the day this was switched on — earlier changes were never written down.
History starts from the day this was switched on — earlier changes were never written down.
{{h.when}}
{{h.bucket}}
{{h.change}}
{{h.reason}}
{{h.actor}}
CERTIFICATE NUMBER
LAB
DESIGN
CARAT
COLOUR
CLARITY
{{t.label}}{{t.n}}
Every live design has a certificate on file.
{{m.code}}
{{m.sub}}
{{m.carat}}
No certificates yet.
Add the number above, attach the PDF, and it is filed against the design.
Add the number above, attach the PDF, and it is filed against the design.
{{c.no}}
{{c.lab}} · {{c.issued}}
{{c.grading}}
{{c.status}}
Your letterhead
Everything here prints on the quotation PDF
Preview builds a sample quotation from these details so you can see the document before a client does.
Only an administrator can change the letterhead.
You can still preview the document.
You can still preview the document.
WHO YOU ARE
{{f.label}}
WHERE YOU ARE
{{f.label}}
STREET ADDRESS
One line per line, exactly as it should print.
BANK DETAILS
Printed at the foot of the quotation. Leave it empty to print nothing.
TERMS
One per line. These are your standing terms, not the note you write for a particular client.
A QUOTE STAYS VALID FOR (DAYS)
CLOSING LINE
← All orders
{{odRef}}
{{odSub}}
{{odStatus}}
{{odTotal}}
{{odDue}}
MOVE IT ALONG
{{o.label}}
EXPECTED TO SHIP
WHAT IS ON IT
{{i.line}}
{{i.code}}
{{i.name}}
{{i.spec}}
{{i.qty}}
{{i.unit}}
{{i.total}}
WHAT HAS HAPPENED
{{e.when}}
{{e.text}}
{{e.body}}
INTERNAL
{{e.actor}}
Orders
{{obLateCount}}
{{f.label}}{{f.n}}
No orders yet.
Raise one from a quote: open Quotes and press → Order on a quote the client has accepted.
Raise one from a quote: open Quotes and press → Order on a quote the client has accepted.
{{r.ref}}
{{r.when}}
{{r.company}}
{{r.line}}
{{r.due}}
{{r.courier}}
{{r.total}}
{{r.status}}
What needs finishing
{{qlHeadline}}
Designs with stock on the shelf come first — those are the ones you could sell today if the page were finished.
{{k.v}}
{{k.l}}
{{f.label}}{{f.n}}
Nothing to finish here.
Every design in this view has its photos, video, certificate, weights and description.
Every design in this view has its photos, video, certificate, weights and description.
{{r.code}}
{{r.stock}}
{{r.sub}}
Who is here now
{{lvHeadline}}
{{w.label}}
{{lvRefreshNote}}
{{k.v}}
{{k.l}}
Nobody on the site in the last few minutes.
This counts anyone who loaded a page, signed in or not.
This counts anyone who loaded a page, signed in or not.
{{v.device}}
{{v.doing}}
{{v.last}}
WHICH ALERTS YOU GET
This is your own setting. Turning one off stops the bell for you, and changes nothing for anybody else.
{{k.tick}} {{k.label}}