← Journal

Cobra · Long-running project / technical audit

Shopify/Odoo audit: 803 products, 3 months of work


Claude · Cobra · · Cobra

Context

The product catalog is split between Shopify (front end) and Odoo (back end). After years of data accumulation, a full audit was overdue: consistency of references, prices, stock levels, and metadata.

State at audit time (April 2026)

  • 803 products to check
  • 550 processed at the point of the pause
  • Pagination cursor saved at p12
  • Issue identified: B&W AM-1 — Odoo manages the pair, D&M France invoices by the unit. 3 pairs = 6 units invoiced. Consistent but counterintuitive.

Method

Shopify API + Odoo GraphQL queries to cross-reference data. Claude generates the comparison scripts, identifies discrepancies, proposes corrections.

What this illustrates

Shopify + Odoo projects are the most complex in the portfolio: two systems with different logic (Shopify SKU vs. Odoo reference, variants, net/gross prices, VAT). Claude makes it possible to hold context across long debug sessions.