Managing Products

Products are the core of Aurelia Hub. The system supports three distinct product types, each with specialized fields for the jewelry industry.

Product Types

Aurelia Hub defines three product types via the ProductType enum:

Creating a Product

Navigate to Catalog > Products and click "New Product".

Basic Information

• Name — Product name (e.g., "18K Gold Diamond Solitaire Ring")
• SKU — Stock Keeping Unit (auto-generated if left blank, format: SKU-XXXX)
• Article Number — Unique 8-digit identifier (auto-generated)
• Individual Number — Optional internal reference number
• Description — Detailed product description
• Product Type — Select Finished Product, Component, or Loose Stone

Pricing

• Price — Selling price (decimal, 2 places)
• Cost — Purchase/cost price (decimal, 2 places)
• Quantity — Current stock quantity

Classification

• Category — Link to a Product Category
• Brand — Link to a Brand
• Collection — Link to a Product Collection
• Warehouse — Assign to a warehouse location
• Status — Active, Inactive, Discontinued
• Tags — Flexible tagging via Spatie Tags

Jewelry-Specific Fields

Metal Details

• Metal — Type of metal (Gold, Silver, Platinum, etc.)
• Metal Color — Color variant (White Gold, Rose Gold, Yellow Gold)
• Metal Purity — Karat or fineness (e.g., 750, 585, 925)

Stone Details

• Stones — JSON array of stone information
• Number of Stones — Total stone count
• Stone Cut — Cut style (Brilliant, Emerald, Princess, Cushion, etc. — 15 cut types available)
• Stone Weight — Total carat weight
• Stone Color — Color grade
• Stone Clarity — Clarity grade

Diamond-Specific (4Cs)

• Diamond Color — D through Z color grades
• Diamond Cut — Excellent, Very Good, Good, Fair, Poor
• Diamond Clarity — FL, IF, VVS1, VVS2, VS1, VS2, SI1, SI2, I1, I2, I3
• Diamond Carat — Carat weight

Watch-Specific Fields

• Case Type — Watch case material/style
• Bezel — Bezel type
• Movement — Watch movement (Automatic, Quartz, Manual)
• Water Resistance — Water resistance rating
• Caliber — Movement caliber reference
• Bracelet Type — Watch bracelet/strap type
• Dial — Dial color/style

Sizing

• Ring Size — Ring size
• Necklace Length — Chain length
• Bracelet Length — Bracelet length

Certificates

• Certificate Number — Certificate reference
• Certificate Issuer — Issuing lab (GIA, AGS, SSEF, Gübelin, IGI, HRD, GGTL, AGL, Lotus, GIC, NGTC, CGL, Other)

Media

Products support multiple media collections:

• Main Image — Primary product photo (single file, JPEG/PNG/WebP)
• Gallery — Additional product images
• Technical — Technical/detail shots
• Documents — PDFs, Word, Excel files
• Certificates — Certificate scans (PDF, JPEG, PNG)

All images are automatically processed into:

• Thumbnail — 300×300px
• Preview — 800×600px

QR Code

Each product can have a QR code generated automatically. The QR code links to the product's admin page and can be included on printed labels.

Editing Products

Click any product in the list to edit. All fields are editable. Changes are automatically logged in the activity log.

Stock Management

• Quantity is the primary stock field
• Use Stock Movements to formally track quantity changes
• The system flags products as Low Stock (≤10) and Out of Stock (≤0)
• Stock levels are maintained per product and synced to the stock_levels table

Searching and Filtering

The product list supports:

• Text search — by name, SKU, description
• Category filter — filter by product category
• Brand filter — filter by brand
• Status filter — Active, Inactive, Discontinued
• Product Type filter — Finished Product, Component, Loose Stone
• Warehouse filter — by location