Jewelry Production & Quotation Management System

Project Overview: DVLINK

DVLINK is a Django-based, production-ready jewelry manufacturing and inventory management system, purpose-built to streamline operations in a jewelry business. It facilitates end-to-end tracking of jewelry production jobs, purchase orders, and quotations—specifically tailored for workflows involving stones, casting, and other essential materials.

Technology Stack

• Backend: Django 4.2.18 (Python web framework)

• Database: MySQL (using mysqlclient 2.2.7)

• Frontend: Django Admin with custom styling and JavaScript

• Key Libraries & Tools:

  • django-autocomplete-light – enhanced autocomplete form fields

  • django-import-export – seamless data import/export

  • Pillow – image processing

  • tablib – dataset management for Excel, CSV, and more

Core Features

1. Job Management System

• Job Model: Central entity managing each jewelry manufacturing job

• Auto-Numbering: Sequential job numbers (e.g., starting from 20167)

• Financial Tracking:

  • Quoted price, selling price, and final cost calculation

  • Automatic profit and margin computation

  • Detailed breakdown: stones, casting, other materials

• Status Management: Tracks job stages (Pending, Completed)

• Image Handling: Uploads with automated file naming and cleanup

2. Purchase Order (PO) System

Manages three distinct types of purchase orders:

• Stones PO:

  • Fields include stone type, shape, size, carat, price per carat

  • Auto-calculated line totals and invoice tracking

• Casting PO:

  • Tracks metal cost, specifications, and casting vendor details

  • Links directly to jobs for cost allocation

• Others PO:

  • Handles miscellaneous purchases (e.g., findings, packaging)

  • Flexible fields for diverse material tracking

3. Quotation System

• Quotation Management: Auto-numbered quotations (starting from 20456)

• Cost Estimation: Automatic approximation of manufacturing costs

• Customer Info: Includes full contact details

• Image Support: Optional product images with cleanup automation

4. Attribute Management System

• ProductAttribute & ProductAttributeValue: Define and store custom attributes (e.g., stone types, vendors, shapes)

• Flexible Structure: Easily extended to new attribute types

• Validation: Regex-based name validation to ensure data quality

5. Admin Interface Enhancements

• Custom UI: Modified Django Admin with better UX

• DataTables Integration: Rich table features—sorting, filtering, search

• Inline Editing: Direct editing of related records

• Import/Export: Excel and CSV support for bulk data operations

• Image Preview: Thumbnail views for quick visual reference

• Responsive Design: CSS adjustments for modern devices

Database Architecture

• Jobs: Core entity connecting all business operations

• Purchase Orders: Each PO type (Stones, Casting, Others) links to jobs

• Quotations: May include multiple related POs

• Attributes: Drive dynamic data categorization

• User Audit: Tracks who created or updated each record

Key Business Logic

• Cost Calculation: Automatically computes real-time cost, selling price, and profit margin

• Auto-Numbering Logic:

  • Jobs: Increment by 3 from the last job ID

  • Quotations: Increment by 3 for each new record

  • Invoices: Sequential numeric pattern

Deployment Configuration

• Domains: Hosted at dvlink.net and app.dvlink.net

• Database: MySQL hosted on localhost:3307

• Static Files: Organized and versioned for deployment

• Media Files: Managed uploads with automatic cleanup routines

Custom Features

• Image Management: Intelligent file naming, cache busting, and cleanup

• Financial Engine: Robust profit, cost, and price tracking in real-time

• Form & Data Validation: Strong business rule enforcement

• User Tracking: Full audit trail of changes

• Soft Delete: Logical delete mechanism preserving historical data

Project Structure

• Modular Design: Models and logic organized per Django best practices

• Custom Admin: Tailored admin views with advanced interactivity

• Template System: Extendable and clean front-end logic

• Static File Handling: Fully managed and scalable

• Migration History: 47+ migrations reflecting ongoing, active development

Conclusion

DVLINK is a complete, domain-specific jewelry manufacturing platform that offers robust job tracking, quotation management, purchase order processing, and cost analytics—all in a cohesive Django-based ecosystem. Its flexible architecture, financial precision, and integration-ready design make it ideal for scaling jewelry production operations with digital precision.