Skip to content
TakoAPI
Back to skills

odoo-reporting

by ashrf-in

Marketing & Sales
455Downloads reported by clawskills.sh
0Views
0 likesSign in to like this skill
—Not yet rated
Your rating

Brief

Query Odoo data including salesperson performance, customer analytics, orders, invoices, CRM, accounting, VAT.

Description

What This Skill Does

Connects to an Odoo instance via XML-RPC or JSON-RPC to query sales orders, invoices, journal entries, CRM records, and accounting data. Reports are generated locally as WhatsApp cards (PNG), PDFs, or Excel files. All operations are strictly read-only.

Reports pull directly from account.move.line and the chart of accounts rather than Odoo's summary views, so balance sheets balance correctly including proper treatment of Odoo's current-year earnings suspense account.

When to Use It

  • Check a salesperson's order count and invoiced revenue for a given quarter
  • Run AR aging to identify which customer invoices are overdue by bucket
  • Generate a one-page CFO executive summary for a monthly finance review
  • Compare revenue vs expenses across two custom date ranges
  • Find top customers by revenue for a specific period or salesperson

Example Workflow

INPUT

User asks: How is Ahmed's sales performance this quarter?

AGENT
  1. 1

    Search res.users for a user matching 'Ahmed' to retrieve their user_id

  2. 2

    Query sale.order filtered by user_id for the quarter date range, aggregate order count and total amount

  3. 3

    Query account.move for posted invoices linked to that salesperson and check payment_state

  4. 4

    Generate a KPI WhatsApp card with orders, revenue, and invoice collection rate

OUTPUT

1080x1080 PNG card showing Ahmed's order count, total revenue, and invoice payment status for the quarter

Requirements

  • Odoo instance URL, database name, and user account (ODOO_URL, ODOO_DB, ODOO_USER)
  • Odoo API key or account password (ODOO_PASSWORD) — API key generated from Odoo Settings > Account Security > API Keys

Installation

clawhub install ashrf-in/odoo-reporting

Run the CLI command, or paste the prompt into Claude Code, Cursor, Codex or whichever coding agent you use.

Links