Silver Articles · Part A · Interactive

Web Admin Panel

Send OTP to sign in, then use the sidebar to move between all 12 sections. The Live Pricing rate is live — change X and every price across the dashboard, catalogue impact table, per-piece inventory and product editor reprices instantly (Y = X + ₹3).

Silver rate last updated yesterday at ₹248/gram. Prices may be outdated.
Update Now →
LIVE SILVER RATE
250.00 /g
Billing Rate Y: ₹ 253.00 /g
Updated today 9:14 AM
Catalog
247 Products
18 categories · 312 pieces
Clients
47 Active
2 pending · 3 suspended
This Month
₹ 18.4L
34 orders · 28 invoiced
Recent Orders
Order RefClientValueStatus
PO-0848Sharma Jewellers₹91,367New
MR-0031Mehta Works₹65,075In Production
PO-0847Sharma Jewellers₹58,944Ready
PO-0839Gupta Traders₹37,695Dispatched
Quick Actions
30-Day Silver Rate
Top Active Clients
Sharma JewellersToday 9:42
Mehta Works3 days
Bajaj Trading5 days
DK Traders2 weeks
Live Pricing Control
One rate change reprices your entire catalogue for every client instantly.
LIVE
· Last updated: Today 9:14 AM ·Auto-API: OFF
Silver Market Rate X (₹ per gram)
Source: XE.com · MCX India · your broker
BILLING RATE Y = X + ₹3/gram (₹3,000/kg)
253.00 / gram
Used in ALL product prices, cart totals and invoices.
Instantly reprices all 247 products and pushes to all client apps
🌐 XE.com API📈 MCX India✏️ Manual
API Fallback
If the live API is offline, the system holds the last confirmed rate. No product will ever display ₹0 or an error price.
Pricing Formula
X Market ₹/g+₹3/g OH=Y Billing
↓ Grams × Y = Silver Cost
↓ + Making Costs (fixed) = Total
↓ × 1.06 loading × Markup 1.20–1.30×
= SELLING PRICE
All 247 Products — Impact Preview
Showing 6 of 247
CodeDescriptionCategoryGramsCurrentNewChange
SC-001 Arch Series Clock Silver Clocks 49g ₹22,555 ₹22,555 ▲ +₹0 (+0.0%)
PF-003 Photo Frame — Oval Photo Frames 96g ₹40,397 ₹40,397 ▲ +₹0 (+0.0%)
PK-014 Peacock Figurine Peacock Figurines 72g ₹32,543 ₹32,543 ▲ +₹0 (+0.0%)
EL-007 Elephant Pair Elephants 120g ₹51,887 ₹51,887 ▲ +₹0 (+0.0%)
CS-021 Candle Stand Candle Stands 63g ₹25,490 ₹25,490 ▲ +₹0 (+0.0%)
MN-009 Temple Mandir Mandir 210g ₹92,781 ₹92,781 ▲ +₹0 (+0.0%)
Products
247 products · 312 pieces
Search products…
Category ▾Status ▾Sort ▾
PhotoCodeNameCategoryGramsPcsPriceStatus
SC-001Arch Series ClockSilver Clocks49g5₹22,555ReadyPieces · Edit
PF-003Photo Frame — OvalPhoto Frames96g5₹40,397On OrderPieces · Edit
PK-014Peacock FigurinePeacock Figurines72g5₹32,543ReadyPieces · Edit
EL-007Elephant PairElephants120g5₹51,887ReadyPieces · Edit
CS-021Candle StandCandle Stands63g5₹25,490ReadyPieces · Edit
MN-009Temple MandirMandir210g5₹92,781ReadyPieces · Edit
Showing 6 of 247Bulk: Change Category · Change Markup · Delete Selected    « 1 2 3 … »
Add Product
Basic Info
Item Code
Name
Category
Silver Clocks ▾
Sub-category
Wall Clock ▾
● Ready StockOn OrderDraft
Silver Weight
Benchmark weight. Exact weights added per-piece separately.
Manufacturing Costs (₹)
Raw Material
Carving
Metal Fitting
PU
Velvet / Glass
Packing / Transport
TOTAL MAKING COST₹4,626
Photos
Drop photo
Drop photo
Photos watermarked server-side before client delivery
WebP · Min 800×600 · CDN with lazy loading
LIVE PRICE PREVIEW · Y = 253.00/g
Silver Cost (49g × Y)₹12,397
Making Cost₹4,626
Total Cost₹17,023
× 1.06 loading₹18,044
× Markup 1.25×
SELLING PRICE
₹22,555
Pieces — SC-001 · Arch Series Clock
Benchmark: 49g · Markup: 1.25× · Y = 253.00/gram
Total: 8Available: 5Sold: 2Reserved: 1
Piece CodeExact WeightSelling PriceStatusAddedOrderActions
SC001-00149.2g₹22,452Available01 JulEdit · Delete
SC001-00248.8g₹22,270Sold01 JulPO-0831View Order
SC001-00350.1g₹22,861Available05 JulEdit · Delete
SC001-00451.4g₹23,454Reserved05 JulPO-0847View Order
Range: 47.9g – 51.4g · Avg: 49.5g · Price range: ₹21,861 – ₹23,454 at Y=₹253 · Prices auto-update when Y changes; weights are permanently fixed.
Piece Code (auto)
Exact Weight (g)
Selling Price (auto)
weight × ₹253 + making × 1.06 × 1.25
Categories
🕐 Silver Clocks34
🖼 Photo Frames52
🦚 Peacock Figurines41
🐘 Elephants12
Silver Clocks
Category Name
Default Markup
1.25× ▾
Icon
🕐 + upload
Invoice Label
SILVER CLOCK ▾
Sub-categories (multi-tier)
Wall Clocks (12)Edit · Delete
Table Clocks (8)Edit · Delete
Mantel Clocks (14)Edit · Delete
Clients
47 active · 3 suspended · 2 pending
Name / FirmCityLast LoginSessionOrdersDiscStatusActions
RSSharma JewellersDelhiToday 9:4224 min188%● ONEdit · ⋮
AMMehta WorksJaipur3 days8 min65%● ONEdit · ⋮
PGPriya GuptaMumbai— Pending05%PendingResend
VBVikram BajajSurat2 weeks2 min35%○ Susp.Activate
Toggling status OFF revokes app access immediately and terminates the active session (PRD 2.2).
OverviewOrdersCredit LedgerActivity Log
Credit Account — Sharma Jewellers
Credit Limit₹25,00,000
Credit Used₹18,40,000
DateTransactionDebitBalance
08 JulInvoice INV-0847₹91,367₹91,367 DR
10 JulPayment received–₹50,000₹41,367 DR
12 JulInvoice INV-0851₹39,679₹81,046 DR
Outstanding Balance₹81,046
Orders
34 this month · 8 pending dispatch · 4 in production
AllNewConfirmedIn ProductionReadyDispatchedDelivered
RefDateClientTypeGross / NetStatusActions
PO-084813 JulSharma JewellersPurchase Order₹91,367NewInvoice
MR-003112 JulMehta WorksMake RequestEst.₹65,075In ProductionUpdate
PO-084710 JulSharma JewellersPurchase Order₹58,944ReadyDispatch
PO-083908 JulGupta TradersPurchase Order₹37,695DispatchedTrack
Order PO-2025-0848
Sharma Jewellers · 13 Jul 2025
ItemsBillingDispatchNotes
Tax Sequence (PRD 3.5)
Gross Amount₹95,827
Less Discount (8%)–₹7,666
Subtotal₹88,161
CGST @ 1.5%+₹1,322
SGST @ 1.5%+₹1,322
GRAND TOTAL₹90,805
Discount applied first, GST after discount (PRD 3.5).
Dispatch & Tracking
Pending Pack: 8 · Ready: 3 · In Transit: 12 · Delivered Today: 5
KanbanTable
Pending Packing · 8
PO-0848
Sharma Jewellers
3 items · ₹91,367
Ordered 2 days ago
Ready to Dispatch · 3
PO-0847
Sharma Jewellers
2 items · ₹58,944
Packed 12 Jul
In Transit · 12
PO-0839
Gupta Traders
DTDC · 9823456712
Disp 08 Jul · Exp 11 Jul
Delivered · 5
PO-0831 ✓
Bajaj Trading
Delivered 05 Jul
Quick Dispatch — PO-0847
Courier
DTDC ▾
Docket No (required)
Dispatch Date
13 Jul 📅
Expected
15 Jul 📅
← INV-2025-0847PO-2025-0847
Tax InvoiceBreakup SheetDownload PDFSend WhatsApp
Craftsmen Silver Works Pvt. Ltd.
14 Naiwara, Karol Bagh, New Delhi 110005
GSTIN: 07AABCC1234D1Z5 · +91 98100 12345
TAX INVOICE
INV-2025-0847
13 July 2025
Bill To
Sharma Jewellers & Co.
Chandni Chowk, Delhi · GSTIN 07AAB…
Ship To
Same as billing
SrDescriptionHSNWeightRate YAmountDiscNet
1SILVER CLOCK711449.2g₹253₹22,452-8%₹20,656
2SILVER ARTICLE711496.0g₹253₹34,287-8%₹31,544
3SILVER ARTICLE711495.0g₹253₹39,679-8%₹36,505
Subtotal post-discount₹88,705
CGST @ 1.5%+₹1,331
SGST @ 1.5%+₹1,331
GRAND TOTAL₹91,367
Amount in words: Rupees Ninety One Thousand Three Hundred Sixty Seven only
Bank: HDFC · A/C 50200 4471 8823
IFSC HDFC0001234 · Karol Bagh
PIECE-WISE BREAKUP SHEET
Supplementary to Invoice INV-2025-0847
Ref: INV-2025-0847
13 July 2025
SrPhotoPiece CodeDescriptionDimensionsWeightRate YNet
1
SC001-005SILVER CLOCKH:38 W:24 D:6cm47.9g₹253₹20,112
2
PF003-002SILVER ARTICLEH:51 W:41cm96.0g₹253₹31,544
Dispatch Details
Courier / Carrier: DTDC
Docket / AWB: 9823456712
Dispatch Date: 13 July 2025
Expected Delivery: 15 July 2025
Notes
Handle with care · insured shipment · signature required on delivery.
Clocks → "SILVER CLOCK" · all others → "SILVER ARTICLE" (PRD 3.5). Breakup Sheet has inline piece photos, dimensions & courier/docket.
Client Analytics
Check-in logs · session duration · behavioral signals
Last 30 Days ▾
Total Sessions
312
Avg Session
18 min
Active Clients
38/47
Dormant (30d+)
9
Client Check-In & Session Logs
ClientLast LoginSessionsAvg Dur.B2C ModeOrdersEngagement
Rajesh Sharma · Sharma JwlsToday 9:422422 min18🔥 HIGH
Amit Mehta · Mehta Works3 days ago812 min6MEDIUM
Dinesh Kumar · DK Traders2 weeks ago23 min01LOW
Priya Gupta · Gupta Traders31 days ago000DORMANT
Sessions per Day
Top Products Browsed
Silver Clocks
Peacock Figurines
Photo Frames
Elephants
Dormant Alerts (30d+)
Priya GuptaWhatsApp
Kiran ShahWhatsApp
Rakesh JainWhatsApp
High-intent signal
3 clients viewed 5+ products but haven't ordered in 14 days.
Notifications & Broadcasts
Send To
All Clients (47)SelectedBy City
Channel
Both channels sent simultaneously for maximum reach.
Type
New CatalogRate UpdateOrder UpdateCustom
Message
Previews
SilverDesk · now
New Silver Designs — Diwali 2025
48 new pieces added — tap to browse
WhatsApp
SilverDesk — New Catalog Alert 🔔
48 new designs added to your catalog.
Tap to browse: [catalog link]
Auto Rate Alert
Silver rate updated to ₹260/gram. Notify clients that catalog prices have been updated?
SkipSend Notification
Notification History
DateTypeSent ToChannelStatusOpens
13 JulNew CatalogAll 47 clientsFCM + WhatsAppSent ✓38 (81%)
10 JulRate UpdateAll 47FCM + WhatsAppSent ✓41 (87%)
08 JulOrder UpdateSharma JwlsWhatsAppSent ✓Delivered ✓
Settings
Owner Profile
Name
Registered Mobile
Pricing Defaults
Overhead per gram₹3.00
Loading factor1.06×
Default markup1.25×
Integrations
XE.com Rate APINot connected
Firebase FCMConnected
WhatsApp Business APIConnected
Security
Server-side centre watermark · Android FLAG_SECURE · iOS capture detection · long-press & context-menu disabled · B2C mode enforced server-side.