# Inventory Analysis MCP Server

An MCP (Model Context Protocol) server that connects to Odoo ERP to provide comprehensive inventory analysis, forecasting, and reporting capabilities.

## Features

### 1. Stock Levels & Reorder Points
- Current stock levels with status classification (out of stock, critical, low, normal, overstock)
- Reorder alerts based on stock levels and reorder rules
- Days of stock calculations
- Stock summary statistics

### 2. Demand Forecasting
- Multiple forecasting methods:
  - Moving Average
  - Exponential Smoothing
  - Linear Regression
  - Holt-Winters (for seasonal data)
  - Auto-selection (best method based on data)
- Trend detection (increasing, decreasing, stable)
- Seasonality detection
- Confidence intervals for predictions
- Accuracy metrics (MAE, RMSE, MAPE)

### 3. ABC/XYZ Analysis
- **ABC Classification** (by annual consumption value):
  - A: High value items (~20% of items, ~80% of value)
  - B: Medium value items (~30% of items, ~15% of value)
  - C: Low value items (~50% of items, ~5% of value)
- **XYZ Classification** (by demand variability):
  - X: Stable demand (CV < 0.5)
  - Y: Variable demand (0.5 <= CV < 1.0)
  - Z: Highly unpredictable demand (CV >= 1.0)
- Combined matrix with management recommendations

### 4. Turnover & Aging Reports
- **Turnover Analysis**:
  - Turnover ratio calculation
  - Days of inventory
  - Classification: fast-moving, normal, slow-moving, dead stock
- **Aging Analysis**:
  - Inventory age buckets (0-30, 31-60, 61-90, 91-180, 181-365, >365 days)
  - Obsolescence risk assessment
  - Slow-moving and high-risk item identification

## Installation

### Prerequisites
- Python 3.10 or higher
- Access to an Odoo instance (v14+)

### Setup

1. Clone or download this repository

2. Install dependencies:
   ```bash
   cd inventory_mcp_server
   pip install -e .
   ```

   Or using requirements.txt:
   ```bash
   pip install -r requirements.txt
   ```

3. Configure Odoo connection:
   ```bash
   cp .env.example .env
   # Edit .env with your Odoo credentials
   ```

## Configuration

### Environment Variables

| Variable | Description | Default |
|----------|-------------|---------|
| `ODOO_URL` | Odoo server URL | `https://duracubeonline.com.au` |
| `ODOO_DB` | Database name | `live` |
| `ODOO_USERNAME` | Username/email | `accounting@qagroup.com.au` |
| `ODOO_API_KEY` | API key for authentication | (required) |

### Claude Desktop Configuration

Add to your `claude_desktop_config.json`:

```json
{
  "mcpServers": {
    "inventory-analysis": {
      "command": "python",
      "args": ["-m", "src.server"],
      "cwd": "C:/Users/jatin/ODOO/Claude/inventory_mcp_server",
      "env": {
        "ODOO_URL": "https://duracubeonline.com.au",
        "ODOO_DB": "live",
        "ODOO_USERNAME": "accounting@qagroup.com.au",
        "ODOO_API_KEY": "your_api_key_here"
      }
    }
  }
}
```

Or using `uv`:

```json
{
  "mcpServers": {
    "inventory-analysis": {
      "command": "uv",
      "args": ["run", "--directory", "C:/Users/jatin/ODOO/Claude/inventory_mcp_server", "python", "-m", "src.server"],
      "env": {
        "ODOO_URL": "https://duracubeonline.com.au",
        "ODOO_DB": "live",
        "ODOO_USERNAME": "accounting@qagroup.com.au",
        "ODOO_API_KEY": "your_api_key_here"
      }
    }
  }
}
```

## Available Tools

### Stock Level Tools
| Tool | Description |
|------|-------------|
| `get_stock_levels` | Get current stock levels with status classification |
| `get_reorder_alerts` | Get products needing reorder |
| `get_stock_summary` | Get summary statistics |

### Forecasting Tools
| Tool | Description |
|------|-------------|
| `forecast_demand` | Generate demand forecasts |
| `get_forecast_summary` | Get forecast summary statistics |

### ABC/XYZ Tools
| Tool | Description |
|------|-------------|
| `analyze_abc_xyz` | Perform ABC/XYZ classification |
| `get_abc_xyz_summary` | Get classification summary |

### Turnover & Aging Tools
| Tool | Description |
|------|-------------|
| `analyze_turnover` | Analyze inventory turnover |
| `analyze_aging` | Analyze inventory aging |
| `get_turnover_summary` | Get turnover summary |
| `get_aging_summary` | Get aging summary |
| `get_slow_moving_items` | Get slow-moving/dead stock |
| `get_high_risk_aging_items` | Get high obsolescence risk items |

## Usage Examples

### Get Stock Alerts
```
"Show me products that need reordering"
```

### Forecast Demand
```
"Forecast demand for the next 30 days for product ID 42"
```

### ABC/XYZ Analysis
```
"Perform ABC/XYZ analysis on my inventory"
```

### Identify Problem Stock
```
"Show me slow-moving inventory worth more than $1000"
```

## Odoo Requirements

The server requires the following Odoo modules:
- `stock` (Inventory)
- `product` (Products)

Optional for full functionality:
- `purchase` (for reorder rules)
- `sale` (for sales history)

### Required Odoo User Permissions
- Read access to:
  - `product.product`
  - `product.category`
  - `stock.quant`
  - `stock.move`
  - `stock.location`
  - `stock.warehouse.orderpoint`

## Development

### Running Tests
```bash
pytest tests/
```

### Code Formatting
```bash
black src/
ruff check src/
```

### Type Checking
```bash
mypy src/
```

## License

MIT License