All projects / Business software

Steel-trading ERP (employer work, details withheld)

PROJECT: Steel-trading ERP (employer work, details withheld) DRAWN BY: G. GELLA SHEET 4/14 SCALE 1:1 REV A
Focus
Software and automation
Main tools
Odoo Online (Studio, automated actions), Google Sheets and Apps Script, Netlify Functions, Claude API
Headline result
Accounts in the chart: 357

A three-layer move from spreadsheets to one connected system for a UAE steel trader: controlled stock data, a staff assistant, then an Odoo ERP configured without custom code.

Problem

Stock lived in spreadsheets edited by several people, so one formatting slip could corrupt totals. Staff quoted prices and weights from memory or a calculator. Sales, purchasing and accounts shared no common record, and a new VAT regime needed a clean audit trail.

What I built

Tools and standards

Result

The masterfile and assistant are live. The ERP is largely configured; cost prices and opening balances are still to load before cutover. Business figures, customer names and stock levels are deliberately left out of this page.

Measured results
MetricValueSource
Accounts in the chart357Author's private project documentation (a configuration count, not a business figure)
Products coded403 activeAuthor's private project documentation (a configuration count, not a business figure)
Automation rules20 rules and 8 server actionsAuthor's private project documentation (a configuration count, not a business figure)

Visuals

Diagram of stock masterfile, staff assistant and ERP layers
Illustration: the three layers, built in sequence (no real data shown).

Sources