Sogetronic seed + Knowledge Hub Claude restructure

Context

Two parallel needs. Operational: prepare the Sogetronic drop stock import by loading supplier codes (Sage Codes) onto product records. Structural: the Claude context files (.md) were scattered, duplicated, and not suited to dual Claude chat + Claude Code usage.

What was built — Sogetronic

Script sogetronic_odoo_check.py: reads the Excel catalog (2,326 products), matches EAN-13 against barcode, writes the Sage Code to product.supplierinfo.product_code (partner_id=496)
175 products updated (150 modified + 25 created), in batches of 200 to work around the XML-RPC limit

What was built — Claude file architecture

~/Cobra/CLAUDE.md updated with May Odoo 18 gotchas
claude-cobra-odoo.md — lighter version for Claude chat
3-project Claude chat architecture: Odoo / Shopify / General
Claude Code memory initialized (reference_odoo_credentials.md) with the correct API key and the correct username (hlahutte@cobra.fr)

What was tricky

The API key wasn't saved — found it in an existing script. Wrong username (hugo@cobra.fr instead of hlahutte@cobra.fr)
Duplication of generic principles → two versions of the file (lighter for chat, self-contained for Code)

Stack

Python 3, pandas, openpyxl, xmlrpc.client, Odoo 18 XML-RPC, Markdown.

What this illustrates

Hybrid chat + Code usage in a single day: chat for file architecture, Code for execution. Without well-maintained .md files, every session starts from scratch.