Home / Case Studies / From Spreadsheets to Manufacturing ERP
Customer story

From Spreadsheets to Manufacturing ERP: Al Marge's Digital Transformation

How a granite manufacturing company built a complete ERP system integrating production, inventory, sales, HR, and finance on Zoho Creator & Books.

From Spreadsheets to Manufacturing ERP

How a granite manufacturing company built a complete ERP system integrating production, inventory, sales, HR, and finance on Zoho Creator & Books.

100%
Digital Production
Real-time
Job Costing

When Craftsmanship Outgrew Spreadsheets

Al Marge Granite & Marbles had built its reputation on precision, quality, and reliability.

But behind the factory floor, operations were struggling to keep pace with growth:

  • Job cards were handled manually
  • Cutting orders moved verbally between teams
  • Stock was tracked across sheets
  • Costing was calculated after the fact
  • Sales and production worked in silos
  • Finance reconciled numbers at month-end

Leadership recognized a hard truth: Great manufacturing needs a system as strong as the stone itself.

So Al Marge embarked on a full ERP transformation — powered by Zoho Creator as the operational engine and Zoho Books as the financial backbone.

Building the Manufacturing Core in Zoho Creator

The journey began where everything starts: production.

A custom Manufacturing ERP was built on Zoho Creator to reflect how Al Marge actually works — not how generic software expects it to.

Inside the Manufacturing ERP

  • Customer-linked job orders
  • Cutting and production workflows
  • Workstation allocation
  • Raw material and slab tracking
  • Job status visibility across departments
  • Rework and wastage capture

Every job moved digitally from request → cutting → finishing → completion.

For the first time, production stopped relying on memory and verbal handovers.

Inventory, Stock & Workstations Under Full Control

Stock management had always been complex — slabs, offcuts, finished goods, consumables. Zoho Creator brought structure.

Inventory & Workstations

  • Raw material intake recorded digitally
  • Slab dimensions, grades, and locations tracked
  • Finished goods tied directly to job orders
  • Workstations assigned per job
  • Live stock availability visibility
  • Barcode-ready inventory structure

No more surprises on the shop floor. Production knew exactly what was available — before the job even started.

Manpower, Work Hours & True Costing

One of the biggest challenges in manufacturing was understanding true job cost. Zoho Creator solved this by connecting people to production.

Manpower & Cost Tracking

  • Staff assigned to job orders
  • Work hours logged per job and per station
  • Overtime captured accurately
  • Labor costs rolled into job costing automatically
  • Material + labor + overhead = real profitability

Costing stopped being an estimate. It became a fact.

Sales, Customers & Orders That Flow Into Production

Sales used to end at order confirmation. Now, sales became the starting point of operations.

Sales & CRM Integration

  • Leads managed in Zoho CRM
  • Customers synced into the ERP
  • Sales orders pushed directly into manufacturing
  • Commercial customers handled separately
  • Forecasting and potential tracking enabled

Every confirmed sale triggered production — automatically and accurately.

Sales and factory finally worked as one team.

Vendors, Products & Procurement Aligned With Manufacturing

Raw materials don’t appear by magic — and procurement needed structure.

Vendor & Product Management

  • Vendor master with pricing and history
  • Product catalogs standardized
  • Purchase requests tied to production demand
  • Vendor payments tracked cleanly
  • Stock replenishment aligned with job pipeline

Procurement shifted from reactive buying to planned sourcing.

Finance Takes Its Rightful Place (Zoho Books & Inventory)

This is where everything came together.

Zoho Books and Zoho Inventory were configured as the financial core, fully integrated with the manufacturing ERP.

Finance Capabilities

  • Sales and purchase accounting
  • Customer and vendor payments
  • VAT-compliant invoicing
  • Chart of accounts tailored to manufacturing
  • Bank feeds and reconciliation
  • Barcode-enabled inventory valuation

Every production activity now had a financial reflection. Numbers finally matched reality.

HR, Attendance & Biometrics Integrated Into ERP

People are the backbone of manufacturing. Zoho People was introduced to manage:

  • Employee records
  • Attendance and shifts
  • Leave management
  • Biometric integrations
  • Payroll-ready data

This HR data flowed seamlessly into work hours, job costing, and productivity analysis.

HR stopped being isolated — it became part of operations.

Integration Across Every Department

The real power of the solution was not in individual modules — but in integration.

Zoho Creator acted as the orchestration layer, connecting:

  • Manufacturing ERP
  • Sales & CRM
  • Inventory & Procurement
  • Finance & Accounting
  • HR & Attendance

Data flowed once — and was reused everywhere. Duplication disappeared. Errors dropped. Efficiency soared.

From Data Migration to Go-Live Confidence

The final phase focused on adoption and stability:

  • Structured data migration
  • User Acceptance Testing (UAT)
  • Role-based training sessions
  • Live environment deployment
  • Hyper-care support post go-live

The system didn’t just launch — it stuck. Teams adopted it because it mirrored how they actually worked.

The Transformation — Al Marge’s Digital Backbone

After implementation:

  • Manufacturing became traceable
  • Job costing became accurate
  • Inventory became reliable
  • Sales and production aligned
  • Finance gained full control
  • Management gained real-time visibility
  • Growth became manageable

Al Marge Granite & Marbles didn’t just implement software. They built a manufacturing ERP tailored to stone, scale, and precision.

Powered by Zoho Creator. Anchored by Zoho Books. Designed for real manufacturing — not spreadsheets.

Have a similar challenge?

Tell us what isn’t working today. We’ll tell you which platform fits, and if it isn’t ours, we’ll say so.