Skip to Content
Mattison Stone & Tile | Case Study

From Spreadsheets to
Full Operational Control

How Setu Consulting transformed Mattison Stone & Tile's decentralised operations with a custom Odoo ERP implementation.


Client

Mattison Stone & Tile

Location

Trinidad & Tobago

Platform

Odoo ERP (Custom)

Industry

Stone & Tile Distribution

About the Client

25 Years. Premium Stone.
One Region. Zero ERP.

Since 1999, Mattison Stone & Tile has been the Caribbean's go-to supplier for premium porcelain, ceramic, marble, granite, and limestone, sourced from top European manufacturers and delivered to architects, contractors, designers, and homeowners across Trinidad & Tobago and beyond.

But as the business grew, so did its operational complexity. A catalog spanning hundreds of SKUs with overlapping attributes — brand, size, style, color, finish — combined with multi-warehouse logistics and a layered commission structure meant the team was fighting their own processes every day.





Founded

1999

Location​

Trinidad & Tobago

Products

Porcelain, Ceramic, Marble, Granite, Limestone

Customers

Architects, Contractors, Homeowners

The Problem​

Six Operational Breakdowns That Were Costing the Business


Commission Tracking Done in Spreadsheets

Multi-level commissions across agents, product categories, and customer tiers, all calculated manually every month-end. The finance team spent days on it, produced disputes, and gave the sales team zero visibility into earnings until payday.

Finance team lost 3+ days every month to commission reconciliation

Inventory Blind Spots Across Warehouses

Without lot-level traceability, the team couldn't answer where specific stock was, which batch a return belonged to, or whether a fast-moving SKU was about to run out. Purchasing decisions were based on gut feel

Overstock and stockouts happening simultaneously with no early warning

Unit of Measure Chaos Across the Transaction Chain

Tiles are ordered by pallet, sold by box, invoiced by piece, measured by square meter. Without a conversion engine, UoM mismatches crept into delivery records, billing, and landed cost calculations — errors that took hours to trace.

Billing and delivery quantities frequently didn't match, eroding client trust

Product Catalog Too Complex to Manage Manually

With hundreds of SKUs differentiated by brand, size, style, color, and finish, even experienced staff made quoting errors. Wrong variants got added to orders, leading to returns, redeliveries, and frustrated customers.

Order errors from mis-identified variants triggered unnecessary returns

No Live Reporting – Decisions Always Made Late

Inventory turnover, sales margin, and stock movement data existed only as periodic manual exports. By the time leadership had the numbers, the situation had already changed. No FSN classification, no overstock alerts, no margin visibility at order level.​

Leadership was always a week behind the actual state of the business

Returns Impossible to Reconcile Accurately

When a customer returned a batch of tiles, tracing that stock to the original lot, re-valuing it, and updating inventory was a manual, error-prone process. Returns created accounting discrepancies that took days to resolve.

Return processing tied up finance and warehouse staff for extended periods

Our Approach

Discovery First. Build What the Business Actually Needs.


Setu Consulting began with a structured discovery phase. Process mapping sessions across warehouse, finance, and sales teams gave us a complete picture of  how Mattison actually operated and exactly where the breakdowns happened.


Phase 1

Discovery & Process Mapping

Workshops with every department. Current-state workflows documented. Pain points ranked by business impact.



Phase 2

Core: Inventory & Catalog

Multi-warehouse inventory, lot traceability, UoM engine, and product wizard built and tested.



Phase 3

Sales, Commission & Finance

Commission automation, margin reporting, invoice sequencing, and cheque handling deployed.



Phase 4

Reporting, Templates & Go-Live

FSN/XYZ analytics, dynamic document templates, user training, parallel run, full cutover.

What We Built​

9 Custom Modules. Every One Solving a Real Problem.

01
Sales Commission Automation
The Problem

Multi-level commissions across agents, products, and customer tiers tracked manually in spreadsheets. Month-end reconciliation took days and generated disputes.

The Solution

A configurable commission engine with rules at partner, product, and category levels. Commission lines trigger automatically at sale, invoice, or payment — with full multi-agent distribution and audit trail.

The Outcome

Commission calculation is now fully automatic. Finance has an auditable record. Sales agents see commissions in real time. Month-end disputes have been eliminated.

02
Multi-Warehouse Inventory & Lot Traceability
The Problem

No lot-level tracking meant returns were hard to reconcile, stock movements were opaque, and purchasing was entirely reactive.

The Solution

Lot selection captured at the sale order level, automatically reflected through to the delivery order. Stock quant views cleaned up to reduce clutter while preserving full backend traceability.

The Outcome

Every tile batch is traceable from receipt to delivery. Returns reconcile against the original lot automatically. Inventory records are clean, accurate, and auditable.

03
UoM Conversion Engine (End-to-End)
The Problem

UoM changes between purchase, delivery, and invoice were handled manually — causing billing discrepancies and landed cost errors across every order.

The Solution

A unified conversion engine integrated across the full transaction chain: RFQ > Quotation > Delivery > Invoice. Landed costs update automatically post-conversion. Package-level pricing rules enforced without manual override.

The Outcome

Billing and delivery quantities match perfectly across every order. Margin leakage from UoM pricing errors has been eliminated entirely.

04
Inter-Warehouse Transfer Management
The Problem

Warehouse-to-warehouse stock movements were untracked and unrecorded, causing inventory counts to fall out of sync across locations.

The Solution

A structured internal transfer workflow with UoM conversion applied at the point of transfer. All movements are logged with a full audit trail and automatic stock synchronization.

The Outcome

Stock counts across all locations stay synchronized automatically. Every transfer is traceable, with UoM accuracy preserved throughout.

05
Product Variant Management & Catalog Wizard
The Problem

Hundreds of overlapping SKUs with no structured entry process. Sales staff regularly quoted incorrect variants, leading to returns and redeliveries.

The Solution

A guided product creation wizard assigning brand, size, style, and color as structured attributes. Enhanced SO line display makes variant identification fast and foolproof.

The Outcome

Product management is consistent and fast. Sales staff identify and quote the correct variant in seconds. Order errors from variant mix-ups have dropped sharply.

06
Finance, Margin Analysis & Payment Handling
The Problem

Inconsistent invoice numbering, no real-time margin visibility at order level, and no structured process for cheque-based payments.

The Solution

Custom journal entry sequences per invoice type with role-based access control. Automated margin calculation displayed live on every order and invoice. Cheque number and image capture in the payment workflow.

The Outcome

Finance records are clean, auditable, and consistent. Leadership sees margin on any order instantly — no manual extraction required.

07
Lot-Wise Return Management
The Problem

Product returns could not be traced back to original lots, making return valuation manual and frequently inaccurate.

The Solution

Structured lot-wise return handling with auto-generated return slips linked to the original delivery lot. Return valuations traced back through original purchase cost automatically.

The Outcome

Returns are processed the same day. Inventory valuations remain accurate even after complex return scenarios. No manual reconciliation required.

08
Dynamic Document Template Management
The Problem

Quotes, delivery notes, purchase orders, and invoices were inconsistently formatted with no central control over business documents.

The Solution

Custom dynamic templates for all key document types, managed at the company level. Data populates automatically from the transaction record — no manual entry in the document itself.

The Outcome

Every client-facing document is professionally formatted and brand-consistent. Document preparation time reduced to near-zero.

09
Advanced Inventory Reporting Suite
The Problem

No FSN classification, no turnover analysis, no overstock or stockout alerts. Leadership was always reacting — never anticipating.

The Solution

Full suite: FSN analysis, XYZ demand classification, FSN-XYZ combined reports, inventory turnover, age breakdown, out-of-stock and overstock alerts, and full stock movement history.

The Outcome

Every inventory decision is backed by real-time data. Dead stock gets flagged early. Fast-moving lines get replenished before they run out. Capital deployed where it actually turns.

Transformation Summary​

The Business Before and After Odoo ERP

Area
Before
After
Commission Tracking
Manual spreadsheets, days to calculate, frequent disputes
Fully automatic, real-time, auditable — zero manual work
Inventory Visibility
No lot tracking, no real-time stock view, reactive purchasing
Lot-level traceability, live multi-warehouse visibility, proactive replenishment
UoM Handling
Manual conversion at every stage, billing errors common
Engine-driven from RFQ to invoice — quantities always match
Warehouse Transfers
Untracked, no audit trail, stock counts unreliable
Structured workflow, UoM-adjusted, logged and synchronized
Product Catalog
No structured entry, variant errors on orders
Attribute wizard, clean SO display, near-zero quoting errors
Return Management
Manual, days to reconcile, valuation inaccurate
Same-day processing, lot-linked, automated valuation
Reporting
Periodic manual exports, always lagged
Live FSN, XYZ, turnover, margin — always current
Finance Accuracy
Inconsistent invoice sequences, no margin visibility
Controlled sequences, role-secured, live margin per order
Business Documents
Inconsistent formatting, manual preparation
Dynamic templates, auto-populated, brand-consistent

Business Impact

What Changed When Operations Run on Data


The real outcome isn't a list of features — it's a business that now makes better decisions, faster, with confidence.

01

Sales commissions are now a non-event

What consumed days of finance effort every month now happens automatically on every sale, invoice, or payment — with a full audit trail and zero disputes.

02

Every tile batch has a traceable identity

From the moment stock arrives to the day it leaves the warehouse, every lot is tracked. Returns reconcile in minutes, not days.

03

Margin is visible on every single order

Leadership no longer waits for a monthly report to know profitability. Margin is calculated and displayed automatically on every sale and invoice.

04

UoM errors have been eliminated

The conversion engine ensures that regardless of how a product is purchased, sold, or invoiced, quantities and valuations are always accurate.

05

Inventory decisions are now proactive

FSN and XYZ analytics tell the purchasing team what is fast-moving, what is slow, and what is tying up capital — before it becomes a problem.

06

The platform scales with the business

Adding new warehouses, new product lines, or new markets doesn't require rebuilding the system. The ERP architecture was designed to grow without friction.

Ready to Transform Your Tile & Stone Operations?​

Discover how Setu Consulting Services can build a tailored Stone & Tile Solution for your business. Whether you are in granite processing, marble wholesaling, ceramic tile distribution, or any other stone-commodity segment, we have the expertise to digitise and streamline your entire value chain.


www.setuconsulting.com  sales@setuconsulting.com

 +91 91572 07037


WhatsApp