- 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
- Data first: a stock masterfile with written rules (no zero rows, every outflow logged, physical recount is truth) so the later tools could trust it.
- Contributed to a staff assistant web app that calculates theoretical weight from yard shorthand, applies the price list by category, reads live stock and suggests alternatives. The AI key stays on the server, and when the data feed is down it says so instead of showing old numbers.
- An Odoo ERP configured with Studio fields and automated actions only: chart of accounts, coded products with computed weights, three valuation methods, customers, automations, auto-filed documents and branded print layouts.
- A three-week staff training plan with competency gates and role cheat sheets, using a test database for practice.
- A decisions log: when lot tracking blocked receipts it was removed, and go-live was staged so quotes ran first and real invoices only after cutover.
Tools and standards
- Odoo Online (Studio, automated actions)
- Google Sheets and Apps Script
- Netlify Functions
- Claude API
- JavaScript
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.
| Metric | Value | Source |
|---|---|---|
| Accounts in the chart | 357 | Author's private project documentation (a configuration count, not a business figure) |
| Products coded | 403 active | Author's private project documentation (a configuration count, not a business figure) |
| Automation rules | 20 rules and 8 server actions | Author's private project documentation (a configuration count, not a business figure) |
Visuals
Sources
- Author's private project documentation (not published)