
Closed
Posted
Paid on delivery
I'm seeking an experienced developer to create a comprehensive Jewellery Manufacturing ERP system using Microsoft Access and Excel. The ERP should effectively manage order tracking and employee assignment, and feature a CAD to Dispatch workflow, dashboards, reports, job cards, inventory management, and VBA automation. It should also support QR/barcode integration and be designed to scale for over 100,000 orders. Key Requirements: Order Tracking Module (Prioritized): - Real-time status updates - Automated notifications - Historical order logs Employee Assignment Module (Prioritized): - Task scheduling - Performance tracking - Role-based assignments Additional Features: - CAD to Dispatch workflow - Dashboards and reports for data visualization - Job cards and inventory management - VBA automation for streamlined processes - QR/barcode support Ideal Skills and Experience: - Proficiency in Microsoft Access and Excel - Strong background in ERP development, particularly in a manufacturing context - Experience with VBA automation - Familiarity with QR/barcode integration - Ability to design scalable systems for high-volume order management Please provide samples of previous ERP projects, particularly in manufacturing, with your bids. Details of project Build a Jewellery Manufacturing ERP using Microsoft Access + Excel with order tracking, CAD to Dispatch workflow, dashboards, reports, job cards, inventory, employee assignment, VBA automation, QR/barcode support, and scalable design for 100,000+ orders.
Project ID: 40589742
12 proposals
Remote project
Active 1 day ago
Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
12 freelancers are bidding on average ₹9,171 INR for this job

Jewellery Manufacturing ERP in Access and Excel — here is exactly how I will build yours. I will construct a normalized Access database with a stage-by-stage pipeline covering CAD, Casting, Polishing, QC, and Dispatch, so every order has a real-time status at each handoff. Each stage record links to an auto-generated job card, meaning every craftsperson sees only their assigned task and supervisors can pull performance data instantly. For QR and barcode integration, I will generate a unique code per job card so shop-floor staff scan to update order status without touching a keyboard — this eliminates manual entry errors at the busiest points in your workflow. One problem worth flagging now: Access starts degrading noticeably around 50,000 records when multiple users query simultaneously. Since you need 100,000-plus orders, I will split the architecture into an Access front-end with linked tables, keeping all heavy data in a separate backend file — this alone doubles reliable concurrent capacity without changing your existing IT setup. VBA automation will handle inventory deductions on dispatch, notifications when orders stall between stages, and scheduled report generation feeding the Excel dashboards your management team will use daily. Delivery in 7 days at 6,300 INR, with sample Access ERP work provided on request. Should the employee assignment module restrict each worker to a single active job card at a time, or can one craftsperson hold multiple concurrent orders?
₹6,300 INR in 7 days
7.1
7.1

Having worked extensively with Microsoft Access and Excel, I am well-equipped to build your Jewellery Manufacturing ERP system. My proficiency in data management, visualization, and overall process automation aligns seamlessly with your project's requirement of CAD to Dispatch workflow, job cards, inventory management, VBA automation, and the ability to handle large order volumes. What sets me apart is not just my technical capability but my knack for understanding specific industry needs. I have a strong background in developing ERPs for manufacturing contexts, fully aware of the complexities involved in order tracking, employee scheduling, and task management– all of which are top prioritized module on your list. I have designed scalabe systems before for high-volume order management and can assure you that your target of efficiently managing 100,000+ orders can be achieved. Moreover, my comfort level with QR/barcode integration is another advantage that gives me an edge over others. You can count on real-time status updates, automated notifications, historical order logs alongside task scheduling, performance tracking and role-based assignments. My commitment to fast delivery holding out top quality renders me confident that I will successfully complete this project with unlimited revisions till utmost satisfaction. I assure you of 24/7 availability for all your queries and dedicated support until the final execution of the system.
₹10,000 INR in 1 day
6.0
6.0

With my extensive expertise in automation and software development, particularly in the ??? domain, I offer you a compelling solution to your Jewellery Manufacturing ERP project. My familiarity with Microsoft Access and Excel, as well as my profound knowledge of VBA automation, makes me confident that I can deliver a comprehensive solution that tailors to your specific workflows and processes. Incorporating the key requirements of real-time order tracking, automated notifications, historical order logs alongside the employee assignment module's task scheduling, performance tracking, and role-based assignments is an area where I excel based on my previous project experiences. Moreover, I understand the importance of scalability for such a robust system handling high-volume orders, and I'm well-versed in developing systems built for performance. The core philosophy I bring to your project is building systems that free up your team's workload. My aim is to create an ERP that automates labor-intensive tasks thereby allowing your team to focus more on their creativity in designing exquisite jewelry rather than worrying about administration. Let's build an efficient infrastructure together!
₹1,500 INR in 1 day
3.3
3.3

I can develop a scalable Jewellery Manufacturing ERP using Microsoft Access, Excel, and VBA or costume ,featuring real-time order tracking, employee assignment, CAD-to-Dispatch workflow, inventory management, QR/barcode integration, dashboards, reports, and automated job cards. The solution will be optimized to handle 100,000+ orders, with a modular architecture, clean database design, comprehensive documentation, and an intuitive interface that streamlines your entire manufacturing process.
₹7,000 INR in 7 days
3.1
3.1

Hey! With over half a decade of experience in full-stack development, SaaS platforms, and business automation solutions, I believe I'm the perfect fit for your Jewelry Manufacturing ERP project. My prowess in Microsoft Access and Excel coincides seamlessly with your project's demands. Having successfully developed similar ERPs for manufacturing contexts in the past, I am well-versed in creating functionalities such as order tracking, CAD to Dispatch workflows, dashboards, job cards, inventory management alongside VBA automation and QR/barcode integration. The idea of designing your ERP for scalability aligns perfectly with my approach to long-term success. Drawing from my proficiency in architecting backends and flawless integrations—which includes designing systems to handle high-volume order management—I can ensure your system effectively scales to accommodate over 100,000 orders- smoothly. What sets me apart beyond technical skills is a profound understanding of business objectives. I don't build for the sake of building; I build systems that help businesses grow by leveraging my skills in clean architecture, modern designs, and efficient executions. For our communication, you can be guaranteeed it will always be clear and transparent - I understand how important effective communication is for a project's success. Let's move forward together on creating an exceptional Jewelry Manufacturing ERP that would transform your operations.
₹10,000 INR in 10 days
1.5
1.5

You've marked Order Tracking and Employee Assignment as the priorities, so that's where I'd start rather than trying to build CAD-to-dispatch, barcode and dashboards all at once for this budget. Working core first, then extend. Milestone 1 (the two prioritised modules): - Order tracking: each order with real-time status, a full historical log, automated status-change notifications. - Employee assignment: task scheduling, role-based assignment, per-employee performance tracking. - Built in Access + Excel with VBA automation, normalised tables so it stays fast, plus the core job-card and inventory views. Later milestones, scoped separately so each stays clean: CAD-to-dispatch workflow, QR/barcode capture, fuller dashboards/reports. One honest note: Access handles structured order/employee data and reporting well, but 100,000+ orders is near its practical ceiling. If you expect to pass that I'd keep the VBA/logic identical and move just the data layer to SQL later, with no rework of what you see. Happy to build it either way. Which comes first, the order log or the employee scheduling? Ricardo, 5.0 stars.
₹8,749 INR in 10 days
0.4
0.4

Drawing on my vast experience with ERP development and extensive knowledge of Microsoft Access and Excel, I am confident in my ability to build a comprehensive and user-friendly Jewellery Manufacturing ERP system. I understand the crucial aspects of your project, including order tracking, CAD to Dispatch workflow, dashboards, reports, job cards, inventory management, and VBA automation. My previous work speaks volumes about my familiarity with QR/barcode integration and an impressive track record of developing scalable systems tailored for high-volume order management such as yours. Having successfully delivered web and mobile applications for over 9+ years, I am no stranger to time-sensitive projects and complex requirements. Your project aligns perfectly with my passion for turning clients' ideas into real solutions. With a focus on quality and result-driven approach, I am committed to providing a solution that incorporates efficient task scheduling, role-based assignments, real-time order status updates, automated notifications, as well as historical log records. In addition to my technical skills in PHP5, Java and .NET , I also bring a unique advantage to our association- lower cost without sacrificing quality. I ensure eins that your 100000+ orders scalability doesn't mean excessive cost burdens for you. Moreover, providing three months of free post-project completion support solidifies my commitment to the success of your project beyond its execution phase.
₹17,000 INR in 7 days
0.0
0.0

Hello, I'd be happy to develop a **Jewellery Manufacturing ERP** using **Microsoft Access and Excel** tailored to your production workflow. The system will be designed for scalability, supporting **100,000+ orders** while providing efficient order tracking, employee management, inventory control, and reporting. The ERP will include real-time order tracking with status history, employee assignment, role-based access, task scheduling, CAD-to-Dispatch workflow, job cards, inventory management, QR/barcode integration, dashboards, and automated reports. Using **VBA automation**, I'll streamline repetitive tasks, notifications, data validation, and reporting to improve productivity and accuracy. The database will be optimized for performance with a structured relational design, ensuring reliable operation as your business grows. **Estimated Timeline:** 6–8 weeks (depending on final scope). I'm ready to discuss your manufacturing process, recommend the best database architecture, and build a reliable ERP that simplifies daily operations and improves production visibility. **Regards,** **Naveen**
₹7,000 INR in 7 days
0.0
0.0

Drawing on over 4 years of experience in software development, with a particular expertise in ERP systems and VBA automation using Microsoft Access and Excel, I am confident that I am the right fit for your Jewellery Manufacturing ERP project. I understand the complexities of high-volume order management and I have skillfully implemented similar systems in various other contexts, including manufacturing. Throughout my career, I have consistently excelled at developing innovative solutions that streamline processes and enhance efficiency. From order tracking and employee assignment to CAD to Dispatch workflow, dashboards, reports, job cards, inventory management and even QR/barcode integration, rest assured that your every requirement will be met meticulously. Furthermore, scalability is not just an option but an essential you require for over 100k orders and yearn for insights supported by real-time updates; anticipated any issues that may arise through historical logs etc. I've honed my skills to ensure my work maintains its high-performance level even with such an exponential growth. Again, my name is Prem (surname) and believe we can create an ERP system of excellence together! Therefore, please consider my profile in delivering the solution you're seeking!
₹13,000 INR in 12 days
0.0
0.0

I already have a working manufacturing ERP built for a marble business, and I can customize its proven foundation for your jewellery workflow instead of starting from zero. The existing system already includes order management, BOM and production orders, production scheduling, operator assignment, inventory batches, quality checks, dispatch tracking, dashboards, reports, role-based access, audit logs, accounting, and Excel/CSV import-export. For your jewellery ERP, I will adapt it into a CAD-to-dispatch workflow: Order Entry -> CAD Assignment -> Approval -> Production -> Setting/Polishing -> Quality Check -> Packing -> Dispatch I will also add jewellery-specific job cards, employee/department assignment, deadline tracking, order history, QR/barcode labels, raw-material and finished-item inventory, delayed-job alerts, and performance reporting. Because you expect 100,000+ orders, I recommend keeping the scalable database-backed ERP architecture rather than storing the full operational system directly in Access. Excel can still be used for imports, exports, dashboards, and management reports. I can demonstrate the existing ERP before award. Delivery: 18 days Bid: ₹12,500 INR
₹12,500 INR in 18 days
0.0
0.0

Hello, We can help you architect and deploy a robust, high-volume Jewellery Manufacturing ERP using Microsoft Access and Excel, engineered with automated VBA pipelines to comfortably handle over 100,000 orders. ## Technology Stack & Architecture • Core Database Engine: Microsoft Access (Optimized backend tables with indexed keys for high-volume storage) • Front-End & Dashboards: Microsoft Excel (Connected via ADODB/DAO links for live data visualization) • Automation Layer: Advanced VBA (Visual Basic for Applications) for background calculations • Hardware Tracking: Native font-based and string-based QR / Barcode scanning listeners • Reporting Engine: Integrated Excel Power Pivot and Access Report Wizards ## Our Approach & Recommendations 1. Scalable Relational Architecture: We will isolate the backend Access database (.accdb) from the Excel front-end tools. Splitting the database ensures index efficiency and prevents file corruption across 100,000+ historical order rows. 2. CAD-to-Dispatch Workflow Triggers: Code structural state machines via VBA that enforce linear routing pipelines (CAD Approval → Casting → Setting → Polishing → QA → Dispatch) with automatic time-stamping. 3. Barcoded Job Cards: Program automated generation macros that print physical job cards containing embedded QR codes, enabling workers to scan and update station metrics instantly. Best Regards, Webix Infotech
₹5,000 INR in 7 days
0.0
0.0

Virār, India
Member since Jul 18, 2026
$1500-3000 AUD
$10-30 USD
₹75000-150000 INR
₹600-1500 INR
€200-500 EUR
$30-250 USD
₹12500-37500 INR
₹600-1500 INR
$250-750 USD
$1500-3000 SGD
$10-50 USD
€30-250 EUR
$750-1500 USD
$30-250 CAD
$250-750 USD
₹75000-150000 INR
₹12500-37500 INR
$15-25 USD / hour
₹12500-37500 INR
$1500-3000 USD