Skip to main content
iVentureTeam
Home › Case Studies › Indep Consulting SPRL
Odoo · ERP Implementation

One Odoo ERP and 8 SQL Reports for a Cleaning-Chemicals Firm

A Belgian cleaning-chemicals company consolidated sales, inventory, accounting, eCommerce, and contract servicing into one Odoo system with management reporting written directly in SQL.

8
Custom SQL reports, from product margin to stock rotation
10+
Business areas covered, from CRM to claim management
1
System spanning webshop, warehouse, and accounting
2x
Faster management reporting cycle
Region
Belgium
Duration
12 weeks · delivery
Industry
Chemicals & Cleaning Services
Tech Stack
OdooOdoo SalesOdoo CRMOdoo Inventory & StockOdoo AccountingOdoo eCommerce & Website ThemeEDICustom SQL Reports

The challenge

Indep Consulting runs a demanding mix of businesses: daily and professional cleaning chemicals, cleaning equipment and machines, and ongoing maintenance contracts with service-quality commitments. Each line generated its own data, and management visibility suffered for it.

  • Sales, stock, and accounting information sat in disconnected tools, making questions like product margin or vendor spend slow to answer.
  • Customer-specific pricing and intercompany goods movements were handled manually, inviting errors.
  • Maintenance contracts and customer claims had no systematic tracking tied to the commercial records.
  • Trading partners expected EDI, which the existing setup could not provide.

Our approach

iVentureTeam implemented Odoo as the company's single operating system, configured the commercial specifics, and then went a layer deeper — writing SQL-based reports tuned to the exact questions management asks.

Core ERP and eCommerce implementation

  • Rolled out Sales, CRM, Inventory, Stock, and Accounting as the operational core.
  • Designed the website theme and customized the Odoo eCommerce experience for the product catalog.
  • Set up claim management so complaints and service issues attach to the relevant orders and contracts.

Commercial rules built for a chemicals distributor

  • Configured custom pricelists reflecting the company's segment- and customer-specific pricing.
  • Implemented intercompany transfer rules so stock moving between entities posts correctly without rekeying.
  • Enabled EDI for structured document exchange with trading partners.

Eight SQL-powered management reports

  • Built invoice, order, and sales-activity reports directly on SQL queries for speed and precision.
  • Delivered product margin, vendor summary, stock, and stock rotation reports to expose profitability and slow movers.
  • Added a contract report giving management a live view of maintenance commitments.

Outcomes

Indep Consulting now steers its chemicals, equipment, and contract businesses from one Odoo system — and its managers read the business from reports built on their own definitions, not generic dashboards.

  • Margins, stock rotation, and vendor performance are visible on demand through the 8 custom SQL reports.
  • Pricing and intercompany transfers follow configured rules instead of manual judgment.
  • Claims and maintenance contracts are tracked against the same records as sales and invoicing.
  • The webshop, warehouse, and accounting reconcile automatically in a single database.

“The reports we could never get out of Odoo are now one click away. Decisions that used to wait for month-end happen the same day.”

Managing Partner · Indep Consulting SPRL

Ready to write your own case study?

A free 30-minute consultation with a senior consultant — diagnostic, fixed-price quote, written roadmap.

We use cookies to improve your experience

Essential cookies make the site work, and we use analytics to improve it. Choose “Only necessary” to turn analytics off. See our cookie policy.