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
- 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
- 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
- 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
- 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.