Cobra · Multi-source analysis + Google Sheets
Dynaudio Emit II sales analysis: Shopify + Odoo cross-referenced
Context
Sales analysis of Dynaudio Emit II over 6 months (Dec 2025 – May 2026) with SKUs, purchase prices, and quantities. The brief evolved: Shopify only → Odoo check for an all-channels view → add an Odoo tab to the existing Google Sheet.
What was built
- ShopifyQL (
FROM sales WHERE product_vendor = 'DYNAUDIO'): gross/net revenue over 6 months - Purchase prices via Shopify GraphQL (
inventoryItem.unitCost) - Odoo XML-RPC:
sale.order.line+product.productacross all channels - Contractual LMC purchase prices via
product.supplierinfo(more reliable thanstandard_priceAVCO) - Local 2-tab formatted
.xlsx→ Drive
What was tricky
- Drive MCP can't edit an existing file — only creation is possible
- The uploaded
.xlsxshows blank in Drive (valid file, but Drive doesn't render xlsx without converting to Google Sheets)
Stack
Python 3, openpyxl, Shopify MCP (run-analytics-query, graphql_query), Odoo XML-RPC, Google Drive MCP, macOS base64 CLI.
What this shows
Multi-source cross-referencing: Shopify = web only (104 orders), Odoo = all channels (186 units, +79%). Shows the Drive MCP limitation and the distinction between standard_price (AVCO) and LMC contractual pricing.