From Broken Compliance and Data Chaos to a Stable, GST-Ready Odoo Operation — Across 70+ Users.
A major Indian manufacturer of high-precision SMT stencils for the electronics industry inherited a broken Odoo v11 installation — freelancer-built GST compliance, an unmanaged server, multi-company data conflicts, and 200+ unresolved issues. Here's how we rescued, rebuilt, and stabilised it.
Zero Data Chaos
Clean, conflict-free records across all companies and modules
Full GST Compliance
Audit-ready Indian government compliance rebuilt from scratch
70+ Users Live
Role-based access rights configured across all positions
200+ Tasks Delivered
Delivered in continuous retainer engagement with internal team coordination
A critical link in India's electronics manufacturing chain — running on a system that was failing them.
Our client is a major Indian manufacturer specialising in high-precision SMT (Surface Mount Technology) stencils for the Electronics Manufacturing Services (EMS) and PCB Assembly industries. Their products are a critical input in the production of circuit boards — the kind found in smartphones, automobiles, medical devices, and industrial equipment.
When a factory assembles a circuit board, they need a precisely manufactured stencil to apply solder paste to the board before components are placed. Our client makes those stencils — with the dimensional accuracy and material consistency that electronics manufacturing demands.
Their operation spans multiple companies under a Pan-India setup — manufacturing, sales, and distribution entities operating across different states, each with their own GST registrations, compliance requirements, and operational workflows.
At the time Rootlevel came in, they had 70+ users across different positions and access levels — production staff, sales teams, accounts, management — all depending on an Odoo v11 installation that was actively failing them.
The system had been built by a freelancer. The freelancer had disappeared.
Operational Snapshot
Location
Pan-India Operation
Complexity Stack
70+ Users, SMT Stencil Manufacturing (MRP), Multi-Company Ledgers, Multi-State GST, Inventory Valuation
System Status
Odoo v11 Community Edition
Freelancer-built, unmanaged Linux server, broken GST compliance, cross-company data conflicts, 200+ backlogged tasks.
A production business running on a system nobody trusted — and nobody could fix.
The Odoo v11 installation had been live long enough to accumulate serious problems. What had started as a workable if imperfect system had deteriorated into something the business was working around rather than through.
Broken Indian GST Compliance
GST calculations were incorrect, and report formats didn't match government filing requirements. The business was filing returns based on unverified manual spreadsheets — a significant legal and financial risk for a Pan-India operation.
Unmanaged Server & Data Growth
A large database running on infrastructure that had never been properly tuned or secured. Slow queries crippled daily SMT work orders, and inadequate backups exposed the entire business to severe data-loss risks.
Multi-Company Ledger Conflicts
Sales records, invoice data, and inventory movements were conflicting across company boundaries due to incorrect multi-company rules — leading to discrepancies that required accounting teams days of manual auditing to reconcile.
200+ Unresolved Development Tasks
A massive, unprioritized backlog of bug reports, custom calculations, and operational requests had accumulated. With no technical partner to call, the business felt completely locked in a failing system.
The Legacy Freelancer Codebase was a Fragile Web
Because customizations were completely undocumented, any small change threatened to break standard Odoo accounting and MRP workflows. Re-engineering these layers required painstaking research, deep knowledge of PostgreSQL transactions, and close coordination with internal teams.
Six compounding problems.
Each one making the others worse.
When compliance layers breakdown under unmanaged local database lag and ledger collisions, the organization's legal liability, SMT manufacturing output, and operational speed all suffer.
Broken GST Compliance
The GST implementation was wrong at a fundamental level — incorrect tax calculations, wrong HSN code assignments, report formats that didn't match government filing requirements, and GSTIN validation that wasn't functioning correctly. Every filing period was a source of extreme anxiety.
Unmanaged Server with Large DB
The server hosting Odoo had never been configured for production. No postgres memory tuning, no SSL Nginx optimization, and inadequate backup strategies. Database growth led to severe query lags on SMT routing and high data loss risk.
Multi-Company Data Conflicts
Sales records, invoice data, and inventory movements conflicted across company boundaries due to incorrect multi-company record rules. The accounting team spent days auditing and manually adjusting ledger values every single month.
Messy, Undocumented Codebase
Freelancer customizations were undocumented, brittle, and actively interfered with standard Odoo accounting workflows. The codebase had become a severe liability — untestable and impossible to extend safely.
Insecure 70+ User Permissions
With 70+ users across sales, production, accounting, and management, role-based access was a necessity. Instead, permissions were structured organically — locking users from critical data or granting insecure visibility.
200+ Pending Retainer Tasks
Critical compliance updates, SMT production schedule improvements, and user enhancements had piled up. The business was left with a massive backlog and no execution partner capable of addressing it.
Six solutions. Clean, stable databases.
Continuous Agile retainer. In production.
By combining deep PostgreSQL transactional expertise with structured Agile retainer sprints, we stabilized an unmanaged server, resolved complex multi-company conflicts, and rebuilt full Indian GST compliance.
GST Compliance Rebuild from Scratch
The Requirement
Correct, audit-ready, government-compliant GST implementation for a multi-company Pan-India operation on Odoo v11.
What We Built
Complete rebuild of the GST compliance layer — from tax configuration to report generation. Re-configured every tax rate with appropriate HSN/SAC codes, rebuilt GSTIN validation, and designed inter-company transaction handling. Rebuilt report templates to output GSTR-1 and GSTR-3B directly from Odoo data.
Engineering Context
Odoo v11 had limitations with India's evolving e-invoicing standards and filing formats. We engineered custom data extraction queries to bridge this gap, formatting reports to match government portals perfectly, resolving legal return risks at the source.
Server Hardening & Database Optimisation
The Requirement
A production-grade Linux server configuration capable of handling a 70+ user manufacturing operation reliably, securely, and efficiently.
What We Built
Conducted a complete server audit, tuned PostgreSQL parameters (memory allocation, query plans, connection pools), optimized Nginx, and hardened SSL. Implemented Fail2ban brute-force blockers, closed SSH vulnerabilities, and configured automated backups with off-site replication.
Engineering Context
Addressed table bloat and query bottlenecks inside a massive, unmanaged database. We designed a clean database archiving roadmap, rebuilding indexes and aging old logs, resulting in measurably faster page loads for all 70+ floor users.
Multi-Company Data Conflict Resolution
The Requirement
Clean, conflict-free record structures across all sales, invoicing, and inventory tables with strict company ledger boundaries.
What We Built
Audited multi-company context settings and resolved conflicting record rules. Separated incorrectly shared product templates, sales ledgers, and inventory moves, merging duplicate database entries, and reconciling historic cross-company transactions.
Engineering Context
Correcting multi-company data anomalies in Odoo v11 requires direct PostgreSQL transactional intervention. Every database change was run using safe, tested SQL transactions and backed by instant rollbacks, protecting historical record integrity.
Access Rights & Role Configuration for 70+ Users
The Requirement
Proper role-based access control for 70+ users across sales, production, accounting, and management — with strict multi-company separation.
What We Built
Mapped a comprehensive user-group permissions matrix matching the organization structure. Re-configured Odoo groups and custom access rules to enforce state-level ledger visibility and lock unauthorized users from financial databases.
Engineering Context
Designed and documented a clean, scale-ready access matrix. New staff members can be placed directly into predefined security groups, eliminating the previous practice of custom organic credential creation.
Production & Inventory Management Stabilisation
The Requirement
Stable SMT manufacturing workflows, Bill of Materials accuracy, work order routing, and reliable stock valuations connected to sales.
What We Built
Corrected MRP routing configurations, validated Bill of Materials (BOM) formulas, and verified work order sequences. Audited and corrected stock move histories, setting automated reorder boundaries for critical production materials.
Engineering Context
Re-engineered inventory valuation workflows to align with accounting ledger positions. Built clean manufacturing throughput boards, giving management real-time visibility into active SMT stencil fabrication speeds.
200+ Retainer Tasks Delivered in Agile Sprints
The Requirement
Systematic execution of the accumulated freelancer backlog of 200+ bug reports, custom scripts, and module updates.
What We Built
Established a structured monthly Agile retainer routine. Backlog tasks were prioritized by business urgency and executed in two-week sprint cycles. Coordinated closely with the client's internal product managers for requirement gathering and UAT.
Engineering Context
Delivered automations ranging from payment alerts and automated invoicing to custom ledger templates and UX enhancements. All completed changes were fully documented and tested prior to deployment.
A business that couldn't trust its own system now runs its entire operation through it.
By rescuing their legacy v11 database, stabilizing local server hardware, and enforcing strict ledger boundaries, we turned a fragile installation into a powerful, reliable engine of growth.
Zero Data Chaos
Clean, conflict-free records across all companies and all modules. Sales, inventory, and accounting ledger balances match perfectly. Accounting reconciliation that previously consumed days per month is now straightforward, allowing management to make decisions on data they trust.
Full Indian GST Compliance
GST filing is now done with complete confidence in the underlying data. Custom templates output GSTR-1 and GSTR-3B directly from Odoo without manual spreadsheets. Audit preparation has been simplified into a regular, automated report generation process.
Server Performance Transformed
System performance measurably improved for all 70+ users. Query lags on SMT stencils are eliminated due to tuned PostgreSQL parameters and Nginx configurations. Automated daily off-site backups provide strong data-loss protection.
Proper Access Permissions Matrix
Every user has exactly the access their role requires across sales, manufacturing, and accounting. Predefined, documented group structures enable easy onboarding of new staff without custom security allocation.
Production & Inventory Running
Manufacturing schedules, BOM structures, work orders, and stock flows are fully operational and aligned with accounting. Real-time stock counts support accurate purchasing decisions, avoiding production floor stalls.
200+ Sprints Backlog Resolved
The entire accumulated freelancer backlog of 200+ bug reports, script fixes, and operational updates was delivered systematically in structured Agile retainer cycles. The client's internal managers were fully coordinated in UAT.
Technical Snapshot
The architectural configurations, custom reports engineering, database layers, and server stack defining this deployment.
Odoo Version
v11 Community Edition
Hosting Environment
Self-hosted (Linux Ubuntu Server)
Active Users
70+ across multiple manufacturing & sales entities
Modules Deployed
Manufacturing (MRP), Inventory, Sales, Purchase, Accounting, HR, Project
Compliance Focus
Indian GST — GSTR-1, GSTR-3B, e-invoicing preparation
Custom Extensions
GST custom reports templates, database access rights matrix, ledger automations
Server Stack
Linux OS, PostgreSQL DB, Nginx Reverse Proxy, Fail2ban Firewall, Automated S3 backups
Delivery Model
Agile monthly retainer sprints — 200+ tasks completed
Organization Structure
Multi-company Pan-India setup (multi-state GSTINs)
Three things every Indian manufacturing business should know about Odoo.
GST compliance is not a configuration — it's a specialisation
India's GST framework is one of the most complex tax systems in the world to implement correctly in an ERP. The number of Odoo installations in India with incorrect GST implementations — built by vendors who treated it as a simple configuration task — is significant. Correct GST implementation requires deep understanding of India's tax rules, Odoo's tax engine, and the gap between them. It is not a task to assign to a generalist.
Server management is not optional for production Odoo
An Odoo installation on an unmanaged server is not a production system — it's a production system waiting to fail. Security vulnerabilities, data loss risk, and performance degradation are not hypothetical risks. They are the predictable outcome of running a database-backed application on infrastructure that has never been configured for production workloads. Every business running self-hosted Odoo should have a server management plan — or a vendor who maintains one for them.
A retainer engagement with internal team integration is more valuable than a project
The 200+ tasks delivered in this engagement were possible because we built a working rhythm with the client's internal team — not despite it. Their team understood the business requirements in detail. Our team understood Odoo deeply. The combination, structured as a continuous retainer with regular coordination, delivered more value faster than any project-based engagement could have. For complex, multi-company manufacturing operations, the retainer model is not a support cost — it's a delivery accelerator.
If you recognised your business in this case study:
Here are the specialised services, industry configurations, and regions related to this rescue operation.
Services That Delivered This Project
Related Industries
- Odoo for Manufacturing
- Odoo for Import & Export
- Odoo for Logistics & Supply Chain
Similar Geographies
- Odoo ERP for Indian Businesses
- Odoo ERP for UAE Businesses
Running a manufacturing or multi-company operation on Odoo in India — and recognise any of this?
Whether your GST compliance is broken, your server is unmanaged, your data has conflicts, or you have a backlog nobody is addressing — we've fixed all of it. Book a free discovery call.