JEWELRY STORE MANAGEMENT - Dolibarr

1. Overview

Jewelry Store Management (Gestion Bijouterie) turns Dolibarr into a complete, production-grade business system for jewelers, fine-jewelry houses and watch retailers. It covers the entire value chain of a jewelry business — from precious-metal and gemstone sourcing, through catalog management, retail sales and bespoke creation, to repairs, gold buyback, appraisals, certificates and decisional reporting — without requiring any additional software.

 

The module ships 21 business objects, 23 granular permissions, a dedicated jewelry-themed dashboard, an 8-report decisional reporting suite, a one-click demonstration dataset, and full integration with Dolibarr native modules (Third parties, Products, Stock, Quotations, Orders, Invoices, Shipments, Projects, Agenda).

Key figures

·       21 business objects with full create / read / update / delete screens

·       23 granular permission entries across 8 functional groups

·       24 left-menu entries plus an in-page quick-navigation tab bar

·       5 languages: French, English, Spanish, Italian, German (331 translation keys each)

·       8 decisional reports with CSV, Excel and print export

·       Built-in demonstration dataset generator and one-click purge

2. Functional scope

2.1 Jewelry catalog

The heart of the module: a jewelry-specific product catalog with all the attributes a jeweler actually needs.

·       Jewelry type: ring, wedding band, necklace, bracelet, earrings, pendant, watch, brooch

·       Metal and purity: 18k / 14k / 9k gold, sterling silver 925, platinum, palladium

·       Metal weight in grams, main stone and carat weight

·       Gender, ring size, hallmark, barcode

·       Sale price, cost price, automatically derived margin, VAT rate

·       Stock quantity and physical location (display case or vault)

·       Photo URL, full description, link to the native Dolibarr product

2.2 Collections

Group pieces into commercial or thematic collections.

·       Collection type, theme, season and designer

·       Launch date and number of pieces

·       Every catalog item can be attached to a collection

2.3 Variants

Decline a single design into multiple sellable versions.

·       Variants by ring size, metal or carat weight

·       Price delta, dedicated stock level and dedicated barcode

2.4 Precious metals

Raw-material stock management with market valuation.

·       Metal type and legal purity (750, 585, 375, 925, 950)

·       Weight held in grams and spot rate per gram

·       Unit value and total value automatically valued at the current rate

·       Supplier, vault location and last rate-update date

·       The default gold spot rate is configurable in the module setup

2.5 Gemstones

A full gemmological inventory of loose stones.

·       Stone type: diamond, ruby, sapphire, emerald, pearl, topaz, amethyst

·       Shape / cut, carat weight, colour grade, clarity and cut grade

·       Certification laboratory and certificate number (GIA, IGI, HRD)

·       Origin, cost price, quantity in stock and secured location

2.6 Suppliers and procurement

The jewelry sourcing network and its purchase orders.

·       Supplier types: metal wholesaler, gemstone dealer, manufacturer, watch supplier

·       Specialty, country, lead time in days and rating

·       Purchase orders with type, totals excl./incl. tax, status and expected date

·       Linked to the native Dolibarr supplier third party

2.7 Sales and point of sale

Record and track every sale of the store.

·       Sale type: in-store, online, telephone

·       Sale status: completed, reserved (layaway), cancelled

·       Totals excl./incl. tax, commercial margin, item count and salesperson

·       Payment method and payment status, deposit amount for layaway

·       Sale lines with item, quantity, unit price, discount and line total

·       Link to the native Dolibarr invoice

2.8 Customers 360°

A complete view of every jewelry customer.

·       Segment: VIP, loyal, new, dormant, prospect — and loyalty tier

·       Ring size and preferred metal, invaluable for in-store advice

·       Birthday and wedding anniversary dates to drive commercial follow-up

·       Number of purchases, total spent, average basket, last purchase date

·       Loyalty points and wish list

·       Linked to the native Dolibarr third party

2.9 Repairs and after-sales service

Full workshop tracking, from intake to hand-back.

·       Repair types: resizing, polishing and rhodium plating, battery change, pearl restringing, claw re-soldering, clasp replacement

·       Diagnosis, assigned jeweler and pipeline status

·       Seven-stage pipeline: received, diagnosed, quoted, in workshop, ready, delivered, cancelled

·       Intake date, promised date and hand-back date, with automatic overdue detection

·       Quoted amount, final amount and warranty coverage flag

2.10 Bespoke creation

Manage custom jewelry commissions end to end.

·       Six-stage pipeline: request, design, quote, production, finishing, delivered

·       Jewelry type, metal and stone specification

·       Assigned jeweler, estimated amount and deposit received

·       Order date and planned delivery date

2.11 Engraving

Track personalisation work.

·       Text to engrave, engraving type (text, date, initials, motif) and font style

·       Request and completion dates, price and status

2.12 Gold buyback

A complete register of metal buyback operations from private customers.

·       Metal type and declared purity, weighed mass in grams

·       Applied spot rate, tested purity, estimated value and amount actually paid out

·       Identity-document reference for regulatory traceability

·       Buyback date and operation status

2.13 Appraisals and valuations

Produce and archive expert valuations.

·       Appraisal purpose: insurance, estate/succession, resale

·       Item description, metal and gemstones

·       Appraiser, appraisal date and validity date

·       Market value and replacement value

2.14 Certificates and warranties

Issue and follow authenticity certificates and warranty vouchers.

·       Certificate type, related jewelry item and customer

·       Issue date, expiry date and warranty duration in months

·       Issuer and certificate status

2.15 Consignment

Handle pieces entrusted by third parties for deposit-sale.

·       Consignor, item description and estimated value

·       Sale price, commission percentage and amount paid back

·       Reception and sale dates, consignment status

2.16 Jewelers and workshop

Reference the craftsmen of your workshop.

·       Specialty: stone setting, polishing, engraving, watchmaking, casting and resizing

·       Skill level, hourly rate and number of jobs completed

·       Repairs and bespoke orders are assigned to a specific jeweler

2.17 Loyalty and promotions

Drive customer retention and commercial operations.

·       Loyalty rewards by tier (Bronze, Silver, Gold, Platinum) with required points

·       Configurable loyalty points earned per euro spent

·       Promotion codes: percentage or fixed amount, minimum purchase, target segment

·       Validity period, maximum uses and usage counter

2.18 Inventory sessions

Organise the physical counting of high-value goods.

·       Inventory type (display case, vault, full) and location

·       Start and end dates, number of items counted

·       Counted value and number of discrepancies found

 

3. Dashboard

The module ships a purpose-designed dashboard that deliberately departs from the classic Dolibarr layout. It uses a jewelry colour charter — gold, onyx black, deep bordeaux and champagne — with a dark gradient hero banner and relief KPI cards evoking a jewel case.

3.1 Commercial performance

·       Total revenue, revenue today, revenue this month

·       Number of sales, average basket, commercial margin

·       Items sold and conversion rate

3.2 Stock valuation

·       Metal stock value, valued at the current spot rate

·       Gemstone stock value and catalog stock value

·       Gold weight held in grams

·       Gold buyback for the current month

·       Low-stock item alerts

3.3 Workshop and repairs

·       Open repairs, overdue repairs, bespoke pieces in production

·       Visual repair pipeline showing volume and value per stage

3.4 Analytics

·       12-month revenue evolution (bar chart)

·       Sales split by jewelry type (pie chart)

·       Best-selling items (bar chart)

·       Catalog split by metal (pie chart)

3.5 Customers and loyalty

·       Active customers, new customers, VIP customers

·       Birthdays occurring in the current month

4. Decisional reporting

A dedicated Reporting menu provides eight cross-functional analyses. Every report can be exported to CSV and Excel, or printed directly.

·       Sales — 12 rolling months: number of sales, revenue, average basket, commercial margin

·       Sales by jewelry type — quantities and revenue per product family

·       Best-selling items — top 25 items by quantity and revenue

·       Stock valuation — weight held and value per metal type

·       Gold buyback — monthly weight bought back and amounts paid out

·       Repairs by status — workload and value per pipeline stage

·       Customer segmentation — customer count, total spent and average basket per segment

·       Financial — sales count and revenue per payment method

5. Configuration and demonstration data

The administration page centralises the module settings and the demonstration dataset controls.

5.1 Settings

·       Default currency

·       Gold spot rate per gram (18k), used for metal stock valuation

·       Low-stock alert threshold

·       Loyalty points earned per euro spent

·       Notification when a repair becomes ready

5.2 Demonstration dataset

Two buttons let an administrator populate and clear a complete demonstration dataset at any time — ideal for training, evaluation and pre-sales demonstrations.

·       Install demo data — generates a realistic, referentially coherent dataset: collections, jewelry catalog with variants, precious-metal and gemstone stock, craftsmen, suppliers and purchases, customers, sales with lines, repairs across the whole pipeline, bespoke orders, engravings, gold buybacks, appraisals, certificates, consignments, loyalty rewards, promotions and inventory sessions

·       Remove demo data — purges every demonstration record in one click, including the native third parties created by the generator

·       All demonstration records are tagged with a dedicated import key so the purge never touches real production data

6. Integration with native Dolibarr modules

The module is designed to extend Dolibarr rather than duplicate it. It links into the standard objects so existing workflows keep working.

·       Third parties (Societe) — customers, suppliers and consignors are native third parties

·       Products — each jewelry item can reference a native Dolibarr product

·       Invoices — a sale can be linked to its native invoice

·       Quotations and Orders — bespoke commissions and procurement follow the native commercial flow

·       Stock — jewelry stock levels and locations complement native warehouse management

·       Users — salespeople and jewelers are linked to Dolibarr users

·       Projects and Agenda — available for bespoke creation follow-up

7. Technical characteristics

·       Module number 512300, technical name bijouteriemanagement, prefix bij

·       21 database tables (llx_bij_*), all multi-entity aware

·       Automatic schema self-healing on upgrade (missing columns are added)

·       23 permissions across 8 groups: catalog, stock, purchasing, sales, customers, workshop, buyback, reporting

·       All translation keys are module-prefixed to eliminate cross-module collisions

·       Dedicated stylesheet with the jewelry colour charter

·       Dashboard widget (box) available for the Dolibarr home page

·       Requires Dolibarr 16.0+ and PHP 7.1+; depends on the Third parties and Products modules

 

Gestion Bijouterie — Jewelry Store Management for Dolibarr
© 2026 DoliResources — www.doliresources.com