Openclaw Skill for Odoo

Full-featured Odoo 19 ERP connector for OpenClaw - Sales, CRM, Purchase, Inventory, Projects, HR, Fleet, Manufacturing (80+ operations, complete Python code...

Security Scan

The skill appears to implement a full Odoo connector, but the package metadata and runtime declarations do not match what the code actually requires (missing declared credentials and config expectations), so review and caution are warranted before use.

Purpose & Capability

The skill's stated purpose (Odoo ERP connector) matches the code: it includes an XML-RPC client, model operation classes, smart actions, webhook server and poller. However the registry metadata declares no required environment variables or primary credential, while the code (odoo_skill/config.py and other modules) requires ODOO_URL, ODOO_DB, ODOO_USERNAME and ODOO_API_KEY (and optionally ODOO_WEBHOOK_SECRET, ports, timeouts). This mismatch between claimed requirements and actual code is an inconsistency that could confuse users or lead to credential misconfiguration.

Instruction Scope

SKILL.md instructs users to install the skill and put Odoo credentials in a config.json (or set environment variables). The runtime instructions and code operate only on the Odoo server (XML-RPC) and local config; there is no evidence in the provided excerpts of the skill instructing the agent to read unrelated system paths or exfiltrate data to external endpoints other than the configured Odoo URL. Note: the skill also includes a webhook server and a background poller (real-time sync) which will open/listen on a port and accept inbound requests if enabled — that increases its runtime surface and should be considered when deploying.

Install Mechanism

There is no formal install spec in the registry (no brew/npm/download), and the skill bundle includes full Python source files. That is lower-risk than arbitrary remote code download, but the metadata labeling this as 'instruction-only' while including a 25-file Python package is misleading. The bundle appears self-contained (no external install URL), and requirements.txt lists only optional/dev dependencies; no suspicious external installers or remote-extract URLs were found in the provided material.

Credentials

The registry claims no required env vars/credentials, but the code requires ODOO_URL, ODOO_DB, ODOO_USERNAME and ODOO_API_KEY (and supports ODOO_WEBHOOK_SECRET, ODOO_TIMEOUT, etc.). Requesting Odoo API credentials is proportionate for an ERP connector, but the failure to declare them in the skill metadata is a significant packaging inconsistency. Also note the config loader will accept credentials from a config.json stored in the skill directory, which means secrets could be persisted on disk in the skill folder if the user follows the README example.

Persistence & Privilege

The skill does not request 'always: true' or other elevated platform privileges. It is user-invocable and may be invoked autonomously (platform default). The included webhook server and poller add runtime persistence (binding to a port, background polling), but they operate within the skill itself and do not modify other skills or global agent configurations. Consider network and port exposure implications when enabling webhooks or the poller.

What to consider before installing

This skill contains a full Python Odoo connector and legitimately needs Odoo credentials (URL, DB, username, API key). However the skill metadata incorrectly declares no required environment variables/primary credential — treat that as a packaging inconsistency. Before installing: (1) review the linked GitHub repo and confirm it matches the packaged code; (2) don't provide high-privilege Odoo admin credentials—create a limited API user with minimal permissions for the actions you need; (3) be aware the skill can run a webhook server (bind to a port) and a background poller — run it in a controlled environment or sandbox if you have network/port concerns; (4) if you store credentials in config.json, ensure the file is secured and not world-readable; (5) if anything about the source or provenance looks unfamiliar, inspect the full code (especially sync/webhook.py and any networking bits) or run it in an isolated test Odoo instance first.

Odoo ERP Connector

Full-featured Odoo 19 ERP integration for OpenClaw. Control your entire business via natural language chat commands.

📦 Full Source Code: https://github.com/NullNaveen/openclaw-odoo-skill

Quick Install

\ash npx clawhub install odoo-erp-connector \

Overview

The Odoo ERP Connector bridges OpenClaw and Odoo 19, enabling autonomous, chat-driven control over 153+ business modules including:

• Sales & CRM
• Purchasing & Inventory
• Invoicing & Accounting
• Projects & Task Management
• Human Resources
• Fleet Management
• Manufacturing (MRP)
• Calendar & Events
• eCommerce

All operations use smart actions that handle fuzzy matching and auto-creation workflows.

Capabilities

Sales & CRM

• Create quotations with dynamic line items
• Manage sales orders (draft → confirmed → done)
• Search and filter orders by status, customer, date range
• Create and qualify leads and opportunities
• Move leads through CRM pipeline stages
• View full sales pipeline with revenue forecasting

Purchasing

• Create purchase orders from vendors
• Manage PO status (draft → purchase → received)
• Receive and validate goods
• Search and filter POs by vendor, status, date
• Track purchase history and vendor performance

Inventory & Products

• Create products (consumables, stockable, services)
• Query stock levels and availability
• Set reorder points and receive low-stock alerts
• Search products by name, code, or category
• Track stock movements and valuations

Invoicing & Accounting

• Create and post customer invoices
• Manage payment terms and schedules
• Query unpaid and overdue invoices
• Search by customer, date range, or amount
• Track invoice status (draft → posted → paid)

Projects & Tasks

• Create projects and organize by team/status
• Create tasks with priority, dates, and assignments
• Log timesheets and track project hours
• Search and filter tasks by project, status, assignee
• Manage project stages and closure

Human Resources

• Create employees and departments
• Manage job titles and work schedules
• Process expense reports and reimbursements
• Search employees by name, department, job
• Track leave requests and attendance

Fleet Management

• Create and track vehicles
• Log odometer readings and service records
• Track maintenance schedules and costs
• Search fleet by license plate, status, brand
• Generate fleet reports

Manufacturing (MRP)

• Create Bills of Materials (BOMs)
• Manage manufacturing orders (MOs)
• Track component requirements and production status
• Search MOs by product or status
• Link BOMs to product variants

Calendar & Events

• Create meetings and events with attendees
• Set reminders and locations
• Search events by date range or attendee
• Track calendar availability

eCommerce

• Publish products to website
• View website orders and customer activity
• Manage product visibility and pricing

Command Examples

Sales

• "Create a quotation for Acme Corp with 10 Widgets at $50 each"
• "Confirm sales order SO00042"
• "Show me all draft quotations from the past week"
• "What's the total revenue from completed orders this month?"
• "Create a quote for Rocky with product Rock"

CRM

• "Create a lead for Rocky, email [e-mail], potential $50k deal"
• "Move lead #47 to Qualified stage"
• "Show me the sales pipeline with all open opportunities"
• "What leads are at proposal stage?"
• "Create an opportunity for Acme with $100k expected value"

Purchasing

• "Create a PO for 500 widgets from Supplier ABC"
• "Confirm purchase order PO00123"
• "Show all pending purchase orders"
• "Get me the vendor history for ABC Supplies"
• "What's on order that's overdue?"

Inventory & Products

• "Create a new product: TestWidget, $25 price, min stock 10"
• "Show products with stock below 20 units"
• "What's the stock level for Widget X?"
• "Search for all consumable products"
• "Set reorder point for Product Y to 50 units"

Invoicing

• "Create an invoice for Acme Corp with 5 units at $50 each"
• "Show me unpaid invoices"
• "What invoices are overdue?"
• "Post invoice INV-001"
• "Send a reminder for invoice INV-002"

Projects & Tasks

• "Create a project called Website Redesign"
• "Create a task 'Fix login button' in Website Redesign project"
• "Show me all tasks assigned to me"
• "Log 3 hours of work on task #42"
• "What's the status of the Website Redesign project?"

HR

• "Create employee John Smith, job title Developer"
• "Create department Engineering"
• "Show me all employees in Engineering"
• "Submit expense report for $45.99"
• "What are the pending leave requests?"

Fleet

• "Create vehicle: Tesla Model 3, license plate TESLA-001"
• "Log odometer reading: 50,000 miles for vehicle #1"
• "Show all vehicles with service due"
• "What's the maintenance cost for this month?"
• "Search for blue vehicles"

Manufacturing

• "Create BOM: Widget contains 3 Components A and 2 Components B"
• "Create manufacturing order: produce 50 Widgets"
• "Confirm production order #1"
• "What's the status of MO-001?"
• "Show all in-progress manufacturing orders"

Calendar

• "Create meeting: Team Standup, tomorrow at 10am, 1 hour"
• "Show me my meetings for next week"
• "What events do I have on the 15th?"
• "Schedule a 2-hour planning session with the team"

eCommerce

• "Publish Widget X to the website"
• "Show me website orders from this week"
• "What's my website revenue?"

Smart Actions

The connector handles fuzzy/incomplete requests with intelligent find-or-create logic.

How Smart Actions Work

Example: "Create quotation for Rocky with product Rock"

The system:

1. Searches for a customer named "Rocky" (case-insensitive, ilike matching)
2. If not found: Creates a new customer "Rocky" (auto-company flag)
3. Searches for product "Rock"
4. If not found: Creates a basic product "Rock" (consumable type, default price $0)
5. Creates the quotation, linking both the found/created customer and product
6. Reports what was found vs. created:
   • "Created quotation QT-001 for new customer Rocky with 1 × Rock at $0.00"

This pattern applies across all smart actions:

• smart_create_quotation() — customer + products
• smart_create_purchase() — vendor + products
• smart_create_lead() — partner (optional)
• smart_create_task() — project + task
• smart_create_employee() — department
• smart_create_event() — event only (no dependencies)

Benefits

• Fuzzy matching: Searches are case-insensitive and forgiving
• Auto-creation: Missing dependencies are created automatically
• Transparency: Each response explains what was created vs. found
• No IDs needed: Use names instead of Odoo IDs
• Batch operations: Create multiple related records in one call

Architecture

Core Components

OdooClient — Low-level XML-RPC wrapper

• Connects to Odoo 19 instance
• Handles authentication via API key
• Provides search(), read(), create(), write(), unlink() methods
• Built-in retry logic and error handling

Model Ops Classes — Business logic for each module

• PartnerOps — Customers/suppliers
• SaleOrderOps — Quotations and sales orders
• InvoiceOps — Customer invoices
• InventoryOps — Products and stock
• CRMOps — Leads and opportunities
• PurchaseOrderOps — POs and vendors
• ProjectOps — Projects and tasks
• HROps — Employees, departments, expenses
• ManufacturingOps — BOMs and MOs
• CalendarOps — Events and meetings
• FleetOps — Vehicles and odometer
• EcommerceOps — Website orders and products

SmartActionHandler — High-level natural-language interface

• Wraps all Ops classes
• Implements find-or-create workflows
• Fuzzy name matching (case-insensitive)
• Multi-step transaction orchestration
• Detailed response summaries

Field Handling

The connector auto-detects required vs. optional fields in Odoo 19:

• Implicit defaults: Fields with Odoo defaults (e.g., state) are omitted
• Smart creation: Auto-fills reasonable defaults for optional fields
• Error reporting: Missing required fields raise clear OdooError with field name

Configuration

config.json Format

{
  "url": "http://localhost:8069",
  "db": "your_database",
  "username": "[e-mail]",
  "api_key": "your_api_key_from_odoo_preferences",
  "timeout": 60,
  "max_retries": 3,
  "poll_interval": 60,
  "log_level": "INFO",
  "webhook_port": 8070,
  "webhook_secret": ""
}

Getting Your API Key

1. Log in to your Odoo instance
2. Go to Settings → Users & Companies → Users
3. Open your user record
4. Scroll to Access Tokens
5. Click Generate Token
6. Copy the token and paste into config.json

Environment Variables

Alternatively, set in .env:

ODOO_URL=http://localhost:8069
ODOO_DB=your_database
ODOO_USERNAME=[e-mail]
ODOO_API_KEY=your_api_key

The client auto-loads from .env if config.json is missing.

Python API

Basic Usage

from odoo_skill import OdooClient, SmartActionHandler

# Load config from config.json
client = OdooClient.from_config("config.json")

# Test connection
status = client.test_connection()
print(f"Connected to Odoo {status['server_version']}")

# Use smart actions for natural workflows
smart = SmartActionHandler(client)

# Create a quotation with fuzzy partner and product matching
result = smart.smart_create_quotation(
    customer_name="Rocky",
    product_lines=[
        {"name": "Rock", "quantity": 5, "price_unit": 19.99}
    ],
    notes="Fuzzy match quotation"
)

print(result["summary"])
# Output: "Created quotation QT-001 for new customer Rocky with 1 × Rock at $19.99"

Smart Actions API

# Find-or-create a customer
result = smart.find_or_create_partner(
    name="Acme Corp",
    is_company=True,
    city="New York"
)
partner = result["partner"]
created = result["created"]

# Find-or-create a product
result = smart.find_or_create_product(
    name="Widget X",
    list_price=49.99,
    type="consu"
)
product = result["product"]

# Smart quotation (auto-creates customer & products)
result = smart.smart_create_quotation(
    customer_name="Rocky",
    product_lines=[
        {"name": "Product A", "quantity": 10},
        {"name": "Product B", "quantity": 5, "price_unit": 25.0}
    ],
    notes="Created via smart action"
)
order = result["order"]
print(f"Order {order['name']} created with {len(result['products'])} product(s)")

# Smart lead creation
result = smart.smart_create_lead(
    name="New Prospect",
    contact_name="John Doe",
    email="[e-mail]",
    expected_revenue=50000.0
)
lead = result["lead"]

# Smart task creation (auto-creates project if needed)
result = smart.smart_create_task(
    project_name="Website Redesign",
    task_name="Fix homepage",
    description="Update hero section"
)
task = result["task"]

# Smart employee creation (auto-creates department if needed)
result = smart.smart_create_employee(
    name="Jane Smith",
    job_title="Developer",
    department_name="Engineering"
)
employee = result["employee"]

Low-Level Ops API

from odoo_skill.models.sale_order import SaleOrderOps
from odoo_skill.models.partner import PartnerOps

partners = PartnerOps(client)
sales = SaleOrderOps(client)

# Get all customers
customers = partners.search_customers(limit=10)
for cust in customers:
    print(f"{cust['name']} — {cust.get('email')}")

# Create a quotation with specific IDs
order = sales.create_quotation(
    partner_id=42,
    lines=[
        {"product_id": 7, "quantity": 10, "price_unit": 49.99},
        {"product_id": 8, "quantity": 5}
    ],
    notes="Manual order"
)
print(f"Created {order['name']}")

# Confirm the order
confirmed = sales.confirm_order(order['id'])
print(f"Order {confirmed['name']} is now {confirmed['state']}")

Response Format

All API methods return structured dictionaries:

Smart Action Response

{
  "summary": "Created quotation QT-001 for new customer Rocky with 1 × Rock",
  "order": {
    "id": 1,
    "name": "QT-001",
    "state": "draft",
    "partner_id": [42, "Rocky"],
    "amount_total": 19.99
  },
  "customer": {
    "created": True,
    "partner": {"id": 42, "name": "Rocky"}
  },
  "products": [
    {
      "created": True,
      "product": {"id": 7, "name": "Rock"}
    }
  ]
}

Standard Response

{
  "id": 1,
  "name": "QT-001",
  "state": "draft",
  "partner_id": [42, "Rocky"],
  "amount_total": 19.99,
  "order_line": [
    {
      "id": 1,
      "product_id": [7, "Rock"],
      "quantity": 1,
      "price_unit": 19.99,
      "price_subtotal": 19.99
    }
  ]
}

Error Handling

The connector uses custom exceptions:

from odoo_skill.errors import OdooError, OdooAuthError, OdooNotFoundError

try:
    result = smart.smart_create_quotation(
        customer_name="Acme",
        product_lines=[{"name": "Widget"}]
    )
except OdooAuthError as e:
    print(f"Authentication failed: {e}")
except OdooNotFoundError as e:
    print(f"Record not found: {e}")
except OdooError as e:
    print(f"Odoo error: {e}")

Supported Odoo Modules

The connector supports 153+ installed modules in Odoo 19:

Core

• base, web, website

Sales & CRM

• sale, crm, sale_management, website_sale, event, survey

Purchasing

• purchase, purchase_stock, purchase_requisition

Inventory

• stock, stock_intrastat, stock_dropshipping

Accounting

• account, account_accountant, account_analytic, account_payment

HR

• hr, hr_attendance, hr_expense, hr_contract, hr_holidays, hr_org_chart

Projects

• project, project_enterprise, task_base, project_timesheet_forecast

Manufacturing

• mrp, mrp_byproduct, quality, batch, shelf_life

Fleet

• fleet, maintenance

Marketing

• marketing_automation, email_marketing, mass_mailing, sms, website_form

eCommerce

• website_sale, website_sale_analytics, website_sale_comparison, website_form_project

Tools

• calendar, documents, spreadsheet, discuss, mail, knowledge

Plus 50+ more specialized modules

Limits & Constraints

• Search limit: 100 records by default (configurable)
• Timeout: 60 seconds per request (configurable)
• Retries: 3 automatic retries on network failure
• Concurrency: Single-threaded; queue requests if needed
• Rate limiting: Follow your Odoo instance's API limits

Troubleshooting

Connection Issues

• Verify url, db, username, api_key in config.json
• Check Odoo server is running: http://your-odoo-url/web
• Ensure API key is generated in Odoo user settings
• Check network connectivity and firewall rules

Authentication Errors

• Regenerate API key in Odoo
• Verify username (email format)
• Check that the user has API access enabled
• Ensure database name matches exactly

Missing Field Errors

• Field names must match Odoo 19 exactly (e.g., product_tmpl_id, not product_id)
• Some fields are read-only in Odoo (state, computed fields)
• Check Odoo model definition: Settings → Technical → Database Structure → Models

Smart Action Issues

• Fuzzy matching is case-insensitive but searches only the name field
• For exact matching, use the low-level Ops API with id directly
• If a name exists in multiple records, the first match is used

Performance

• Large searches (limit > 100) may timeout
• Use date range filters: date_from, date_to
• Consider batch operations for bulk data

Examples in OpenClaw

Natural Language Sales Order

User: "Create a quote for Acme Corp with 10 Widgets at $50 each"

OpenClaw → OdooClient (smart action):
  1. Search for customer "Acme Corp"
  2. Search for product "Widgets"
  3. Create quotation with both
  4. Return summary

Result: "✅ Created quotation QT-001 for Acme Corp with 10 × Widgets at $50"

Pipeline Status Check

User: "Show me the sales pipeline"

OpenClaw → CRMOps.get_pipeline():
  - Query all leads/opportunities
  - Group by stage
  - Calculate total revenue by stage
  - Return formatted summary

Result: "Qualified: $50k | Proposal: $100k | Negotiation: $75k | Total: $225k"

Inventory Alert

User: "What products are low on stock?"

OpenClaw → InventoryOps.get_low_stock_products():
  - Query products with stock < reorder point
  - List each product, stock level, reorder point
  - Suggest PO quantities

Result: "Widget X: 5 on hand (min 20) | Component Y: 0 on hand (min 10)"

Development

Project Structure

OdooConnector/
├── odoo_skill/
│   ├── client.py              # Core OdooClient
│   ├── config.py              # Configuration loader
│   ├── errors.py              # Custom exceptions
│   ├── retry.py               # Retry logic
│   ├── smart_actions.py       # Smart action handler
│   ├── models/
│   │   ├── partner.py
│   │   ├── sale_order.py
│   │   ├── invoice.py
│   │   ├── inventory.py
│   │   ├── crm.py
│   │   ├── purchase.py
│   │   ├── project.py
│   │   ├── hr.py
│   │   ├── manufacturing.py
│   │   ├── calendar_ops.py
│   │   ├── fleet.py
│   │   ├── ecommerce.py
│   ├── utils/
│   │   ├── formatting.py      # Response formatting
│   │   ├── validators.py      # Input validation
│   ├── sync/
│   │   ├── poller.py          # Webhook poller
│   │   ├── webhook.py         # Webhook handler
├── run_full_test.py           # Integration test suite
├── config.json                # Configuration (create from template)
├── config.template.json       # Configuration template
├── requirements.txt           # Python dependencies
├── README.md                  # User setup guide
├── SKILL.md                   # This file
└── setup.ps1                  # PowerShell installer

Running Tests

# Run full integration test suite
python run_full_test.py

# Run single test module
python -m pytest tests/test_partners.py -v

# Run with coverage
python -m pytest --cov=odoo_skill tests/

Adding a New Smart Action

1. Implement the method in SmartActionHandler class
2. Use find_or_create_* primitives for dependencies
3. Return a dict with summary, the main record, and creation details
4. Add docstring with example usage
5. Test with run_full_test.py

Example:

def smart_create_invoice(self, customer_name: str, product_lines: list[dict], **kwargs) -> dict:
    """Create invoice with fuzzy customer and product matching."""
    # Find or create customer
    customer_result = self.find_or_create_partner(customer_name)
    customer = customer_result["partner"]
    
    # Find or create products
    products = []
    for line in product_lines:
        prod_result = self.find_or_create_product(line["name"], **line)
        products.append(prod_result)
    
    # Create invoice with resolved IDs
    invoice = self.invoices.create_invoice(
        partner_id=customer["id"],
        lines=[...],
        **kwargs
    )
    
    return {
        "summary": f"Created invoice INV-001 for {customer['name']}",
        "invoice": invoice,
        "customer": customer_result,
        "products": products
    }

License & Support

This connector is part of the OpenClaw project. For issues, questions, or contributions, contact the development team.

---

Last Updated: 2026-02-09
Odoo Version: 19.0
Python: 3.10+
Status: Production Ready