PIM — Product Information Management

ВХОДЫ:          ЯДРО:              ВЫХОДЫ:
1С (OData) →                    → OZON API
Прайсы xlsx → pim_products →  → OpenCart
              (PostgreSQL)      → Отчёты

cd /opt/claude-workspace/projects/org/pirotehnika/app/pim

# Запуск API
uvicorn pim.main:app --reload --port 8000

# Синхронизация с 1С
python -m pim.sync_1c

# Импорт прайса
python -m pim.import_price /path/to/price.xlsx --supplier maxsem

pirotehnika/pim/
├── api/                          # API endpoints
│   ├── __init__.py              # Router aggregation
│   ├── products.py              # Product endpoints
│   └── pricing.py               # Pricing endpoints
│
├── core/                         # Business logic
│   ├── __init__.py
│   ├── products.py              # Product service
│   └── pricing.py               # Pricing service
│
├── models/                       # SQLAlchemy ORM models
│   ├── __init__.py
│   ├── product.py               # Product models (Product, PimProduct)
│   ├── pricing.py               # Pricing models (PriceCostRule)
│   └── supplier.py              # Supplier models (SupplierCost, SupplierStock)
│
├── schemas/                      # Pydantic validation schemas
│   ├── __init__.py
│   ├── product.py               # Product response/request schemas
│   └── pricing.py               # Pricing response/request schemas
│
├── tests/                        # Test cases
│   ├── __init__.py
│   └── test_api.py              # API tests
│
├── database.py                   # Database connection & session management
├── config.py                     # Application settings
├── main.py                       # FastAPI application entry point
├── requirements.txt              # Python dependencies
│
├── README.md                     # This file
├── API_DOCUMENTATION.md          # API endpoints documentation
├── USAGE_EXAMPLES.md             # Usage examples and integration guides
└── DEPLOYMENT.md                 # Deployment instructions

cd /opt/claude-workspace/L1-SERVICE/pirotehnika/pim
python -m venv venv
source venv/bin/activate
pip install -r requirements.txt

DATABASE_HOST=91.218.142.168
DATABASE_PORT=5432
DATABASE_USER=noco
DATABASE_PASSWORD=your_password
DATABASE_NAME=nocodb_data
DATABASE_SCHEMA=pt7k98pv0fwi1el

python -m uvicorn main:app --reload --host 0.0.0.0 --port 8000

curl -X GET "http://localhost:8000/api/v1/products/НФ-00001234"

curl -X POST "http://localhost:8000/api/v1/pricing/calculate" \
  -H "Content-Type: application/json" \
  -d '{
    "article": "НФ-00001234",
    "markup_percent": 30
  }'

import httpx

async with httpx.AsyncClient() as client:
    # Get product
    response = await client.get("http://localhost:8000/api/v1/products/НФ-00001234")
    product = response.json()

    # Calculate price
    response = await client.post(
        "http://localhost:8000/api/v1/pricing/calculate",
        json={
            "article": "НФ-00001234",
            "markup_percent": 30
        }
    )
    prices = response.json()

article: str              # Product SKU (primary key)
name: str                 # Product name
brand: str                # Brand (e.g., "JF-Pyro", "Maxsem")
category: str             # Product category
base_price: Decimal       # Manufacturer base price (прайс бренда)
fixed_price: Decimal      # Supplier final price (цена поставщика)
tier: str                 # Price tier: эконом, стандарт, премиум
product_type: str         # "simple" or "bundle"
code_1c: str              # Code in 1C system
barcode: str              # Product barcode
created_at: datetime      # Creation timestamp
updated_at: datetime      # Last update timestamp

id: int                   # Primary key
brand: str                # Brand name (unique)
discount_percent: Decimal # Discount percentage (0-100)
description: str          # Rule description
is_active: bool           # Is rule active
created_at: datetime      # Creation timestamp
updated_at: datetime      # Last update timestamp

Base Price: 100 RUB
Brand Discount: 30%
Cost Price: 100 × (1 - 0.30) = 70 RUB
Markup: 30%
Retail Price: 70 × (1 + 0.30) = 91 RUB

API Layer (Endpoints)
    ↓
Business Logic Layer (Services)
    ↓
Data Access Layer (Models)
    ↓
Database Layer (PostgreSQL)

pytest tests/ -v
pytest tests/test_api.py::test_get_product -v

# Formatting
black .

# Linting
flake8 .

# Type checking
mypy .

# Database
DATABASE_HOST=91.218.142.168
DATABASE_PORT=5432
DATABASE_USER=noco
DATABASE_PASSWORD=password
DATABASE_NAME=nocodb_data
DATABASE_SCHEMA=pt7k98pv0fwi1el

# API
API_V1_PREFIX=/api/v1
API_TITLE=PIM Service API
API_VERSION=1.0.0
API_DESCRIPTION=Product Information Management for pirotehnika

# CORS
CORS_ORIGINS=["*"]

# Logging
LOG_LEVEL=INFO