[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8,"_9":10},"actionData","errors","root",{"_283":284,"_285":286},"routes/_app.x.$handle.$name",{"_100":99,"_32":45,"_109":90,"_27":110,"_13":14,"_111":-5,"_11":112,"_113":114,"_115":116,"_117":118,"_119":120,"_20":-5,"_121":-5,"_122":-5,"_123":25,"_124":125,"_126":59,"_127":-5,"_128":-5,"_129":130},"routes/_app.x.$handle.$name.branch.$branch.version.$version.diff",{"_11":12,"_13":14,"_15":16,"_17":-5,"_18":-5},"project",{"_43":44,"_32":45,"_38":46,"_47":-5,"_48":25,"_49":50,"_51":50,"_52":53,"_54":-5,"_18":55,"_56":57,"_58":59,"_60":-5,"_61":-5,"_62":63,"_64":65,"_66":67,"_68":69,"_70":71,"_72":-5,"_73":74,"_75":74,"_76":77,"_78":77,"_79":77,"_80":74,"_81":74,"_82":83,"_84":85,"_86":87,"_88":25},"version",152,"changes",[19],"aiChatInfo","userId",{"_20":21,"_22":23,"_24":25,"_26":25,"_27":28,"_29":28},"file",{"_30":31,"_32":33,"_34":20,"_35":37,"_38":39,"_40":14,"_41":42,"_24":25},"previous",{"_30":31,"_32":33,"_34":20,"_35":36},"deleted",false,"deletedHere","path","frontend/index.html","latestPath","fileId","9bce22c8-8992-11f1-8345-1607ee4eb77e","name","index.html","fileType","content","\n\n\n \n \n D2C France — E-commerce Dashboard\n \n \n \n\n\n

\n \n\n\n","\n\n\n \n \n D2C France — E-commerce Dashboard\n \n \n \n\n\n

\n \n\n\n","createdAt",["D",1785231021798],"branchVersion","branchId","36a2c3f0-828a-4176-bacb-c93668eda600","id","cf2b2da1-d8e7-495b-9b80-5e85202b2429","d2c-dashboard",["D",1785139688485],"deletedAt","legacyEnvVars","privacy","public","httpPrivacy","description","D2C France e-commerce catalogue dashboard (Haier/Candy/Hoover)","imageUrl","9dc0f674-f4af-4f43-82f0-60e027cb7685","pinnedFileId","4da8d688-8992-11f1-bb40-1607ee4eb77e","pinPreview",true,"pinMigrated","screenshotVersion","likeCount",0,"orgId","019f70ba-a157-71ef-a091-fba3f4e32aa1","tursoName","cf2b2da1d8e7495b9b805e85202b2429","tursoHostname","cf2b2da1d8e7495b9b805e85202b2429-val-town.aws-us-east-2.turso.io","tursoMeasuredAt",["D",1789561879908],"pinned","userPerm","r","valPerm","blobPerm","rw","emailPerm","sqlitePerm","projectPerm","telemetryPerm","user",{"_100":99,"_108":104},"org",{"_100":99,"_101":102,"_103":104,"_18":55,"_105":106,"_107":25},"branch",{"_13":89,"_32":90,"_43":42,"_91":44,"_92":-5,"_93":-5,"_94":-5,"_95":-5,"_96":-5,"_97":45,"_98":99},"isOwned",809,"main","projectId","forkedBranchId","forkedBranchVersion","forkedProjectPrivacy","forkedProjectId","forkedProjectOrgId","projectName","userHandle","nicolasduchene","handle","displayName","Nicolas Duchene","avatar","https://lh3.googleusercontent.com/a/ACg8ocIezwTGgRq3xwm4fhgneTl1bk1gYVw-Hs87-EJKQoj3b5WO_2hc=s96-c","tier","free","canRestrictVals","profileImageUrl","branchName","","adoptOrgId",{"_43":44,"_32":45,"_38":278,"_47":-5,"_48":25,"_49":50,"_51":50,"_52":53,"_54":-5,"_18":55,"_56":57,"_58":59,"_60":-5,"_61":-5,"_62":63,"_64":65,"_66":67,"_68":69,"_70":279,"_72":-5,"_73":74,"_75":74,"_76":77,"_78":77,"_79":77,"_80":74,"_81":74,"_82":280,"_84":281,"_86":282,"_88":25},"tree",[206,212,213,214,215,216,217],"files",[206,207,208,209,210,211,212,213,214,215,216,217],"counts",{"_196":63,"_197":187,"_198":63,"_199":200,"_201":202},"contents",[131,132,133,134,135,136,137],"upstreamProject","upstreamBranch","emptyEnvVars","flags",[],"hasHttpFiles","grants","orgs","customDomains",{},{"_43":190,"_32":191,"_30":192,"_141":-5,"_41":42,"_40":179,"_143":59,"_38":193,"_13":63,"_34":194,"_35":-5,"_24":25,"_148":-5,"_27":195},{"_43":182,"_32":183,"_30":184,"_141":-5,"_41":42,"_40":185,"_143":25,"_38":186,"_13":187,"_34":146,"_35":188,"_24":25,"_148":-5,"_27":189},{"_43":174,"_32":175,"_30":176,"_141":-5,"_41":42,"_40":177,"_143":25,"_38":178,"_13":179,"_34":146,"_35":180,"_24":25,"_148":-5,"_27":181},{"_43":165,"_32":166,"_30":167,"_141":-5,"_41":42,"_40":168,"_143":25,"_38":169,"_13":170,"_34":171,"_35":172,"_24":25,"_148":-5,"_27":173},{"_43":158,"_32":159,"_30":160,"_141":-5,"_41":42,"_40":161,"_143":59,"_38":162,"_13":63,"_34":146,"_35":163,"_24":25,"_148":-5,"_27":164},{"_43":150,"_32":151,"_30":57,"_141":-5,"_41":42,"_40":152,"_143":25,"_38":153,"_13":145,"_34":154,"_35":155,"_24":25,"_148":156,"_27":157},{"_43":138,"_32":139,"_30":140,"_141":-5,"_41":42,"_40":142,"_143":25,"_38":144,"_13":145,"_34":146,"_35":147,"_24":25,"_148":-5,"_27":149},"51209e29-ea22-4353-8de9-9d78a845884d","orders_sync.ts","2dc351d0-89cf-11f1-9a0d-1607ee4eb77e","parentId",93,"latest",["D",1785173783552],10,"script","// Fetches the daily Matrixify ORDERS exports (stable URLs) and stores compact\n// order lines in blob \"orders_lines\" — powering the Business tab and the\n// shipping stats in the Logistic tab.\n//\n// Matrixify order exports repeat the order columns on every row, while the\n// line-item / fulfilment / refund blocks live on DIFFERENT rows of the same order:\n// • ORDERED line → \"Line: SKU\" + POSITIVE \"Line: Quantity\", no fulfilment column\n// • FULFILLED line → same SKU with NEGATIVE quantity + \"Fulfillment: Status\" = success\n// (Matrixify represents shipped items as stock movements)\n// • refunds → rows carrying only \"Refund: Created At\"\n// We therefore group rows by order ID, then emit one record per line with\n// k = \"ord\" (ordered) or \"ful\" (shipped), quantities always positive.\nimport { blob } from \"https://esm.town/v/std/blob/main.ts\";\n\nconst ORDERS_FEEDS: { brand: string; url: string }[] = [\n { brand: \"HOOVER\", url: \"https://app.matrixify.app/files/hoover-france-dtc/b9e5621ffea0694a3cbe9fcd96de81fb/Export_Hoover_Orders.csv\" },\n { brand: \"HAIER\", url: \"https://app.matrixify.app/files/haier-france-dtc/3af6b56e49b18159bfe1e88f5dbce652/Export_Haier_Orders.csv\" },\n { brand: \"CANDY\", url: \"https://app.matrixify.app/files/candy-france-dtc/f3f2c113ebc507d06e13cd19cc2b44c8/Export_Candy_Orders.csv\" },\n];\n\nconst RETENTION_DAYS = 400;\n\nfunction parseCSV(text: string): string[][] {\n const rows: string[][] = [];\n let row: string[] = [], field = \"\", inQ = false;\n for (let i = 0; i < text.length; i++) {\n const c = text[i];\n if (inQ) {\n if (c === '\"') {\n if (text[i + 1] === '\"') { field += '\"'; i++; }\n else inQ = false;\n } else field += c;\n } else if (c === '\"') inQ = true;\n else if (c === \",\") { row.push(field); field = \"\"; }\n else if (c === \"\\n\" || c === \"\\r\") {\n if (c === \"\\r\" && text[i + 1] === \"\\n\") i++;\n row.push(field); field = \"\";\n if (row.length > 1 || row[0] !== \"\") rows.push(row);\n row = [];\n } else field += c;\n }\n if (field !== \"\" || row.length) { row.push(field); rows.push(row); }\n return rows;\n}\n\n/** Compact order line.\n * k=\"ord\" (ordered) | \"ful\" (shipped) · o=order name · b=brand · d=order date\n * f=fulfilment date · t=tags (marketplace) · rf=refund date · sku · q=qty (>0) · p=unit price */\nexport interface OrderLine {\n k: \"ord\" | \"ful\";\n o: string; b: string; d: string; f?: string | null;\n t?: string | null; rf?: string | null;\n sku?: string | null; q: number; p: number;\n}\n\nexport async function syncOrders(): Promise<\n { ok: boolean; feeds: Record; lines: number; fulfilled: number }\n> {\n const feedResults: Record = {};\n const all: OrderLine[] = [];\n let anyOk = false, nReturns = 0;\n\n for (const { brand, url } of ORDERS_FEEDS) {\n try {\n const res = await fetch(url, { redirect: \"follow\" });\n if (!res.ok) { feedResults[brand] = `HTTP ${res.status}`; continue; }\n const rows = parseCSV(await res.text());\n if (rows.length < 2) { feedResults[brand] = \"empty\"; anyOk = true; continue; }\n\n const header = rows[0].map((h) => h.trim().toLowerCase());\n const idx = (...names: string[]) => {\n for (const n of names) { const i = header.indexOf(n); if (i !== -1) return i; }\n return -1;\n };\n const iId = idx(\"id\");\n const iName = idx(\"name\");\n const iCreated = idx(\"created at\", \"processed at\");\n const iFulDate = idx(\"fulfillment: created at\", \"fulfilled at\");\n const iFulSt = idx(\"fulfillment: status\", \"fulfillment status\");\n const iSrc = idx(\"source name\", \"source\");\n const iTags = idx(\"tags\");\n const iRefund = idx(\"refund: created at\");\n const iSku = idx(\"line: sku\", \"lineitem sku\", \"line: variant sku\");\n const iQty = idx(\"line: quantity\", \"lineitem quantity\");\n const iPrice = idx(\"line: price\", \"lineitem price\");\n if (iName === -1 || iCreated === -1) { feedResults[brand] = \"missing Name/Created At columns\"; continue; }\n\n // ── Pass 1: order-level attributes, merged across all rows of the order\n interface OrderMeta {\n name: string; d: string; src: string | null; t: string | null; rf: string | null;\n }\n const meta: Record = {};\n const keyOf = (row: string[]) =>\n (iId !== -1 ? (row[iId] ?? \"\").trim() : \"\") || (row[iName] ?? \"\").trim();\n\n for (let r = 1; r < rows.length; r++) {\n const row = rows[r];\n const key = keyOf(row);\n if (!key) continue;\n const m = meta[key] ?? {\n name: (row[iName] ?? \"\").trim(),\n d: (row[iCreated] ?? \"\").slice(0, 10),\n src: null, t: null, rf: null,\n };\n if (!m.name) m.name = (row[iName] ?? \"\").trim();\n if (!m.d) m.d = (row[iCreated] ?? \"\").slice(0, 10);\n if (iSrc !== -1 && !m.src && row[iSrc]?.trim()) m.src = row[iSrc].trim();\n if (iTags !== -1 && !m.t && row[iTags]?.trim()) m.t = row[iTags].trim();\n if (iRefund !== -1 && !m.rf && row[iRefund]?.trim()) m.rf = row[iRefund].slice(0, 10);\n meta[key] = m;\n }\n\n // ── Pass 2: line items — positive qty = ordered, negative qty + fulfilment = shipped\n let count = 0;\n for (let r = 1; r < rows.length; r++) {\n const row = rows[r];\n const key = keyOf(row);\n const m = meta[key];\n if (!m || !m.d) continue;\n const q = iQty !== -1 ? parseFloat(row[iQty]) : NaN;\n if (isNaN(q) || q === 0) continue; // not a line-item row\n const p = iPrice !== -1 ? parseFloat(row[iPrice]) : NaN;\n const fulSt = iFulSt !== -1 ? (row[iFulSt] ?? \"\").trim().toLowerCase() : \"\";\n const isFul = q < 0 || fulSt === \"success\" || fulSt === \"fulfilled\";\n if (isFul) nReturns++; // = shipped line counter\n all.push({\n k: isFul ? \"ful\" : \"ord\",\n o: m.name, b: brand, d: m.d,\n f: iFulDate !== -1 && row[iFulDate]?.trim() ? row[iFulDate].slice(0, 10) : null,\n t: m.t, rf: m.rf,\n sku: iSku !== -1 ? (row[iSku] ?? \"\").trim() || null : null,\n q: Math.abs(q), p: isNaN(p) ? 0 : p,\n });\n count++;\n }\n feedResults[brand] = count;\n anyOk = true;\n } catch (e) {\n feedResults[brand] = String(e);\n }\n }\n\n if (all.length > 0) {\n const cutoff = new Date(Date.now() - RETENTION_DAYS * 864e5).toISOString().slice(0, 10);\n const kept = all.filter((l) => l.d >= cutoff);\n await blob.setJSON(\"orders_lines\", {\n updated_at: new Date().toISOString(), feeds: feedResults, lines: kept,\n });\n }\n return { ok: anyOk, feeds: feedResults, lines: all.length, fulfilled: nReturns };\n}\n","label",[139],"7c362c89-73f9-4ba1-be2b-8f105f557b1f","main.tsx",123,["D",1785227719398],"http","// D2C France e-commerce dashboard — Haier / Candy / Hoover\n// Data pushed by local Python pipeline via POST /api/ingest (token-protected).\n// UI gated behind Val Town login + email allowlist.\nimport { Hono } from \"npm:hono\";\nimport { parseVal, serveFile } from \"https://esm.town/v/std/utils/index.ts\";\nimport { blob } from \"https://esm.town/v/std/blob/main.ts\";\nimport { getOAuthUserData, oauthMiddleware } from \"https://esm.town/v/std/oauth/middleware.ts\";\nimport { syncCms } from \"./cms_sync.ts\";\nimport { addChanges, buildFeed, cancelChange, listChanges } from \"./changes.ts\";\nimport { getSkuHistory, getTrends } from \"./history.ts\";\n\nconst VAT = 0.20;\n\nconst app = new Hono();\napp.onError((err) => Promise.reject(err));\n\n// ── Access control ────────────────────────────────────────────────────────────\n// ALLOWED_EMAILS: comma-separated list of authorised email addresses (env var).\n// The val owner (username below) is always allowed.\nconst OWNER_USERNAME = \"nicolasduchene\";\n\nfunction allowedEmails(): string[] {\n return (Deno.env.get(\"ALLOWED_EMAILS\") ?? \"\")\n .split(\",\").map((e) => e.trim().toLowerCase()).filter(Boolean);\n}\n\nasync function checkAccess(req: Request): Promise<{ ok: boolean; user?: any; reason?: string }> {\n const session = await getOAuthUserData(req);\n if (!session?.user) return { ok: false, reason: \"unauthenticated\" };\n const u = session.user;\n if (u.username === OWNER_USERNAME) return { ok: true, user: u };\n const email = (u.email ?? \"\").toLowerCase();\n if (email && allowedEmails().includes(email)) return { ok: true, user: u };\n return { ok: false, user: u, reason: \"not_allowed\" };\n}\n\n// ── Auth-gated pages ──────────────────────────────────────────────────────────\napp.get(\"/\", async (c) => {\n const access = await checkAccess(c.req.raw);\n if (!access.ok) {\n // Show a landing page rather than auto-redirecting: an immediate redirect to\n // /auth/login would silently re-authenticate right after a logout.\n if (access.reason === \"unauthenticated\") return c.html(loginPage());\n return c.html(deniedPage(access.user), 403);\n }\n return serveFile(\"/frontend/index.html\");\n});\n\napp.get(\"/api/data\", async (c) => {\n const access = await checkAccess(c.req.raw);\n if (!access.ok) return c.json({ error: \"unauthorized\" }, 401);\n const data = await blob.getJSON(\"catalog\");\n if (!data) return c.json({ error: \"no_data\", message: \"No catalogue data pushed yet.\" }, 404);\n\n // Merge the daily CMS overlay (Matrixify feeds): fresher price/stock/status/image\n const overlay = await blob.getJSON(\"cms_overlay\");\n if (overlay?.items && Array.isArray(data.products)) {\n for (const p of data.products) {\n const o = overlay.items[String(p.code)];\n if (!o) continue;\n if (o.img && !p.img) p.img = o.img;\n if (o.ss) p.ss = o.ss;\n if (o.sstock != null) p.sstock = o.sstock;\n if (o.price != null && o.price > 0) {\n p.price = o.price;\n // Recompute price-derived metrics with the fresh price\n if (p.cost) {\n const ht = o.price / (1 + VAT);\n p.mcur = Math.round(((ht - p.cost - (p.deee ?? 0)) / ht) * 10000) / 10000;\n }\n if (p.comp && p.comp > 0) {\n p.gap = Math.round(((o.price - p.comp) / p.comp) * 10000) / 10000;\n p.pos = o.price <= p.comp * 0.99 ? \"competitive\" : o.price <= p.comp * 1.05 ? \"average\" : \"above\";\n }\n }\n }\n data.cms_synced_at = overlay.updated_at;\n }\n return c.json({ ...data, viewer: { username: access.user.username, email: access.user.email } });\n});\n\n// ── Product changes (team editing with audit trail) ───────────────────────────\napp.post(\"/api/changes\", async (c) => {\n const access = await checkAccess(c.req.raw);\n if (!access.ok) return c.json({ error: \"unauthorized\" }, 401);\n const body = await c.req.json();\n if (!Array.isArray(body?.changes)) return c.json({ error: \"bad_payload\" }, 400);\n const user = access.user.email ?? access.user.username ?? \"?\";\n const result = await addChanges(user, body.changes);\n return c.json(result);\n});\n\napp.get(\"/api/changes\", async (c) => {\n const access = await checkAccess(c.req.raw);\n if (!access.ok) return c.json({ error: \"unauthorized\" }, 401);\n return c.json({ entries: await listChanges() });\n});\n\napp.post(\"/api/changes/cancel\", async (c) => {\n const access = await checkAccess(c.req.raw);\n if (!access.ok) return c.json({ error: \"unauthorized\" }, 401);\n const { id } = await c.req.json();\n const user = access.user.email ?? access.user.username ?? \"?\";\n return c.json({ ok: await cancelChange(String(id), user) });\n});\n\n// ── Trends (daily snapshots) ──────────────────────────────────────────────────\napp.get(\"/api/trends\", async (c) => {\n const access = await checkAccess(c.req.raw);\n if (!access.ok) return c.json({ error: \"unauthorized\" }, 401);\n const days = Math.min(parseInt(c.req.query(\"days\") ?? \"30\") || 30, 180);\n return c.json({ series: await getTrends(days) });\n});\n\napp.get(\"/api/history/:sku\", async (c) => {\n const access = await checkAccess(c.req.raw);\n if (!access.ok) return c.json({ error: \"unauthorized\" }, 401);\n const sku = parseInt(c.req.param(\"sku\"));\n if (!sku) return c.json({ error: \"bad_sku\" }, 400);\n return c.json({ history: await getSkuHistory(sku) });\n});\n\n// ── Business data (order lines from Matrixify orders exports) ─────────────────\napp.get(\"/api/business\", async (c) => {\n const access = await checkAccess(c.req.raw);\n if (!access.ok) return c.json({ error: \"unauthorized\" }, 401);\n const data = await blob.getJSON(\"orders_lines\");\n if (!data) return c.json({ error: \"no_orders\", message: \"Orders export not configured yet.\" }, 404);\n return c.json(data);\n});\n\napp.post(\"/api/sync-orders\", async (c) => {\n const token = c.req.header(\"x-ingest-token\");\n const expected = Deno.env.get(\"INGEST_TOKEN\");\n if (!expected || token !== expected) return c.json({ error: \"forbidden\" }, 403);\n const { syncOrders } = await import(\"./orders_sync.ts\");\n return c.json(await syncOrders());\n});\n\n// ── Matrixify import feeds (one per store, token in path) ─────────────────────\n// GET /feeds//.csv → pending changes as Matrixify import CSV\n// Fetching the feed marks the included changes as \"sent\".\n// Add ?peek=1 to preview without consuming.\napp.get(\"/feeds/:token/:file\", async (c) => {\n const expected = Deno.env.get(\"FEED_TOKEN\");\n if (!expected || c.req.param(\"token\") !== expected) return c.text(\"forbidden\", 403);\n const file = c.req.param(\"file\").toLowerCase();\n const brand = file.replace(\".csv\", \"\").toUpperCase();\n if (![\"HOOVER\", \"HAIER\", \"CANDY\"].includes(brand)) return c.text(\"unknown brand\", 404);\n const consume = c.req.query(\"peek\") !== \"1\";\n const csv = await buildFeed(brand, consume);\n return new Response(csv, {\n headers: { \"Content-Type\": \"text/csv; charset=utf-8\" },\n });\n});\n\n// Manual CMS sync trigger (same token as ingest)\napp.post(\"/api/sync-cms\", async (c) => {\n const token = c.req.header(\"x-ingest-token\");\n const expected = Deno.env.get(\"INGEST_TOKEN\");\n if (!expected || token !== expected) return c.json({ error: \"forbidden\" }, 403);\n const result = await syncCms();\n const { verifyChanges } = await import(\"./changes.ts\");\n const verified = await verifyChanges();\n return c.json({ ...result, verified });\n});\n\n// ── Data ingestion (called by the Python pipeline) ────────────────────────────\napp.post(\"/api/ingest\", async (c) => {\n const token = c.req.header(\"x-ingest-token\");\n const expected = Deno.env.get(\"INGEST_TOKEN\");\n if (!expected || token !== expected) return c.json({ error: \"forbidden\" }, 403);\n const body = await c.req.json();\n if (!Array.isArray(body?.products)) return c.json({ error: \"bad_payload\" }, 400);\n await blob.setJSON(\"catalog\", body);\n return c.json({ ok: true, products: body.products.length, generated_at: body.generated_at ?? null });\n});\n\n// ── Static frontend + source ──────────────────────────────────────────────────\napp.get(\"/frontend/**/*\", (c) => serveFile(c.req.path));\napp.get(\"/source\", (c) => c.redirect(parseVal().links.self.val));\n\nfunction loginPage(): string {\n return `\nD2C France — Dashboard\n\n\n

📊

D2C France — E-commerce Dashboard

Haier · Candy · Hoover — you are signed out.

\nLog in\n

`;\n}\n\nfunction deniedPage(user: any): string {\n return `Access denied\n\n\n

🔒

Access restricted

Signed in as ${user?.username ?? \"?\"}${user?.email ? ` (${user.email})` : \"\"}.

This account is not on the allowed list. Ask the dashboard owner to add your email.

\n\n

`;\n}\n\nexport default oauthMiddleware(app.fetch);\n","d2c-france-dashboard",[151],"154a5611-9efc-49df-9a59-9ee78fc528b0","history.ts","0471ca32-89ca-11f1-9992-1607ee4eb77e",23,["D",1785163617606],"// Daily per-SKU snapshots (price, cumulative sales, stock) in SQLite,\n// powering the trend charts. One row per (date, sku); re-runs overwrite.\nimport { sqlite } from \"https://esm.town/v/std/sqlite/main.ts\";\n\nconst T = \"snapshots\";\n\nexport async function ensureTable() {\n await sqlite.execute(`CREATE TABLE IF NOT EXISTS ${T} (\n date TEXT NOT NULL,\n sku INTEGER NOT NULL,\n brand TEXT,\n grp TEXT,\n price REAL,\n sales INTEGER,\n stock INTEGER,\n PRIMARY KEY (date, sku)\n )`);\n}\n\n/** Record today's snapshot from the catalog blob (+ overlay already merged upstream). */\nexport async function recordSnapshot(products: any[]) {\n await ensureTable();\n const date = new Date().toISOString().slice(0, 10);\n // Batch inserts (100 rows per statement)\n for (let i = 0; i < products.length; i += 100) {\n const chunk = products.slice(i, i + 100);\n const values = chunk.map(() => \"(?,?,?,?,?,?,?)\").join(\",\");\n const args: any[] = [];\n for (const p of chunk) {\n args.push(date, p.code, p.brand ?? null, p.grp ?? null,\n p.price ?? null, p.sales ?? null, p.s48 ?? null);\n }\n await sqlite.execute({\n sql: `INSERT OR REPLACE INTO ${T} (date, sku, brand, grp, price, sales, stock) VALUES ${values}`,\n args,\n });\n }\n // Retention: keep 180 days\n await sqlite.execute({\n sql: `DELETE FROM ${T} WHERE date < ?`,\n args: [new Date(Date.now() - 180 * 864e5).toISOString().slice(0, 10)],\n });\n}\n\n/** Aggregated daily series by category group (sales cumulative + revenue estimate). */\nexport async function getTrends(days = 30) {\n await ensureTable();\n const since = new Date(Date.now() - days * 864e5).toISOString().slice(0, 10);\n const res = await sqlite.execute({\n sql: `SELECT date, grp,\n SUM(sales) AS sales,\n SUM(CASE WHEN price IS NOT NULL THEN price * sales ELSE 0 END) AS revenue\n FROM ${T} WHERE date >= ? GROUP BY date, grp ORDER BY date`,\n args: [since],\n });\n return res.rows.map((r: any) => ({ date: r[0], grp: r[1], sales: r[2], revenue: r[3] }));\n}\n\n/** Per-SKU price/sales history (for future product detail view). */\nexport async function getSkuHistory(sku: number, days = 90) {\n await ensureTable();\n const since = new Date(Date.now() - days * 864e5).toISOString().slice(0, 10);\n const res = await sqlite.execute({\n sql: `SELECT date, price, sales, stock FROM ${T} WHERE sku = ? AND date >= ? ORDER BY date`,\n args: [sku, since],\n });\n return res.rows.map((r: any) => ({ date: r[0], price: r[1], sales: r[2], stock: r[3] }));\n}\n",[159],"bb809107-2184-435e-83a1-2bbcf0037809","cron.ts","c1378f1e-89a5-11f1-8159-1607ee4eb77e",116,["D",1785226656859],4,"interval","// Daily sync: Matrixify CSV feeds (products + orders) + daily snapshot for trends.\nimport { blob } from \"https://esm.town/v/std/blob/main.ts\";\nimport { syncCms } from \"./cms_sync.ts\";\nimport { syncOrders } from \"./orders_sync.ts\";\nimport { recordSnapshot } from \"./history.ts\";\nimport { verifyChanges } from \"./changes.ts\";\n\nexport default async function () {\n const cms = await syncCms();\n console.log(\"CMS sync:\", JSON.stringify(cms));\n\n // Confirm queued changes actually landed in Shopify\n const check = await verifyChanges();\n console.log(\"Change verification:\", JSON.stringify(check));\n\n const orders = await syncOrders();\n console.log(\"Orders sync:\", JSON.stringify(orders));\n\n // Daily snapshot (catalog with fresh overlay prices) → trends\n try {\n const catalog = await blob.getJSON(\"catalog\");\n const overlay = await blob.getJSON(\"cms_overlay\");\n const products = (catalog?.products ?? []).map((p: any) => {\n const o = overlay?.items?.[String(p.code)];\n return o?.price ? { ...p, price: o.price } : p;\n });\n if (products.length) {\n await recordSnapshot(products);\n console.log(`Snapshot: ${products.length} products recorded`);\n }\n } catch (e) {\n console.error(\"Snapshot failed:\", e);\n }\n}\n",[166],"d2da03a8-c824-4fa0-b2c2-cf0212c87615","cms_sync.ts","bcb1c6e4-89a5-11f1-a7ea-1607ee4eb77e",21,["D",1785163569352],3,"// Fetches the daily Matrixify CSV exports (stable URLs) and stores a per-SKU\n// overlay (price / site stock / status / image) in blob \"cms_overlay\".\n// The overlay is merged into the catalog by /api/data at read time.\nimport { blob } from \"https://esm.town/v/std/blob/main.ts\";\n\nconst FEEDS: { brand: string; url: string }[] = [\n { brand: \"HOOVER\", url: \"https://app.matrixify.app/files/hoover-france-dtc/b9e5621ffea0694a3cbe9fcd96de81fb/Export_Hoover_Dashboard.csv\" },\n { brand: \"HAIER\", url: \"https://app.matrixify.app/files/haier-france-dtc/3af6b56e49b18159bfe1e88f5dbce652/Export_Haier_Dashboard.csv\" },\n { brand: \"CANDY\", url: \"https://app.matrixify.app/files/candy-france-dtc/f3f2c113ebc507d06e13cd19cc2b44c8/Export_Candy_Dashboard.csv\" },\n];\n\n/** Minimal CSV parser handling quoted fields, commas and newlines in quotes. */\nfunction parseCSV(text: string): string[][] {\n const rows: string[][] = [];\n let row: string[] = [], field = \"\", inQ = false;\n for (let i = 0; i < text.length; i++) {\n const c = text[i];\n if (inQ) {\n if (c === '\"') {\n if (text[i + 1] === '\"') { field += '\"'; i++; }\n else inQ = false;\n } else field += c;\n } else if (c === '\"') inQ = true;\n else if (c === \",\") { row.push(field); field = \"\"; }\n else if (c === \"\\n\" || c === \"\\r\") {\n if (c === \"\\r\" && text[i + 1] === \"\\n\") i++;\n row.push(field); field = \"\";\n if (row.length > 1 || row[0] !== \"\") rows.push(row);\n row = [];\n } else field += c;\n }\n if (field !== \"\" || row.length) { row.push(field); rows.push(row); }\n return rows;\n}\n\nfunction statusMap(raw: string): string {\n const s = (raw ?? \"\").trim().toLowerCase();\n if (s === \"active\") return \"Active\";\n if ([\"draft\", \"archived\", \"inactive\"].includes(s)) return \"Inactive\";\n return \"Not listed\";\n}\n\nexport interface OverlayItem {\n brand: string; price?: number | null; sstock?: number | null;\n ss?: string; img?: string | null; title?: string | null; handle?: string | null;\n}\n\nexport async function syncCms(): Promise<{ ok: boolean; feeds: Record; total: number }> {\n const items: Record = {};\n const feedResults: Record = {};\n\n for (const { brand, url } of FEEDS) {\n try {\n const res = await fetch(url, { redirect: \"follow\" });\n if (!res.ok) { feedResults[brand] = `HTTP ${res.status}`; continue; }\n const text = await res.text();\n const rows = parseCSV(text);\n if (rows.length < 2) { feedResults[brand] = \"empty file\"; continue; }\n\n const header = rows[0].map((h) => h.trim().toLowerCase());\n const idx = (...names: string[]) => {\n for (const n of names) { const i = header.indexOf(n); if (i !== -1) return i; }\n return -1;\n };\n const iSku = idx(\"variant sku\");\n const iPrice = idx(\"variant price\");\n const iQty = idx(\"variant inventory qty\");\n const iStatus = idx(\"status\");\n const iImg = idx(\"image src\");\n const iTitle = idx(\"title\");\n const iHandle = idx(\"handle\");\n if (iSku === -1) { feedResults[brand] = \"no 'Variant SKU' column\"; continue; }\n\n let count = 0;\n for (let r = 1; r < rows.length; r++) {\n const row = rows[r];\n const sku = (row[iSku] ?? \"\").trim();\n if (!sku || !/^\\d+$/.test(sku)) continue;\n const existing = items[sku] ?? { brand } as OverlayItem;\n const price = iPrice !== -1 ? parseFloat(row[iPrice]) : NaN;\n if (!isNaN(price) && price > 0 && existing.price == null) existing.price = price;\n const qty = iQty !== -1 ? parseInt(row[iQty]) : NaN;\n if (!isNaN(qty) && existing.sstock == null) existing.sstock = qty;\n if (iStatus !== -1 && row[iStatus]?.trim() && !existing.ss) existing.ss = statusMap(row[iStatus]);\n const img = iImg !== -1 ? (row[iImg] ?? \"\").trim() : \"\";\n if (img.startsWith(\"http\") && !existing.img) existing.img = img;\n if (iTitle !== -1 && row[iTitle]?.trim() && !existing.title) existing.title = row[iTitle].trim();\n if (iHandle !== -1 && row[iHandle]?.trim() && !existing.handle) existing.handle = row[iHandle].trim();\n if (!items[sku]) { items[sku] = existing; count++; }\n }\n feedResults[brand] = count;\n } catch (e) {\n feedResults[brand] = String(e);\n }\n }\n\n const total = Object.keys(items).length;\n if (total > 0) {\n await blob.setJSON(\"cms_overlay\", { updated_at: new Date().toISOString(), feeds: feedResults, items });\n }\n return { ok: total > 0, feeds: feedResults, total };\n}\n",[175],"0a34fc72-4fa3-4d73-a302-3a4f37dd7221","changes.ts","f8773bc2-89c9-11f1-9752-1607ee4eb77e",124,["D",1785229867826],9,"// Pending product changes (price / status) with audit trail, and the\n// Matrixify import feeds that deliver them to Shopify.\n// Storage: blob \"changes_log\" = { entries: ChangeEntry[] } (newest first, capped).\nimport { blob } from \"https://esm.town/v/std/blob/main.ts\";\n\nexport interface ChangeEntry {\n id: string;\n at: string; // ISO timestamp (created)\n user: string; // email or username\n code: number; // SKU\n brand: string;\n handle?: string | null; // Shopify handle (needed for Matrixify import)\n name?: string | null;\n field: \"price\" | \"status\";\n oldValue: string | number | null;\n newValue: string | number;\n status: \"pending\" | \"sent\" | \"applied\" | \"cancelled\";\n sentAt?: string | null;\n appliedAt?: string | null; // confirmed live in Shopify by the CMS sync\n applyAt?: string | null; // ISO — do not deliver to Matrixify before this time\n}\n\n/** Sent changes keep being served this long, so a Matrixify retry or a\n * double-fetch still receives them. All operations are idempotent. */\nconst GRACE_HOURS = 12;\n\nconst MAX_ENTRIES = 2000;\n\nasync function load(): Promise {\n const data = await blob.getJSON(\"changes_log\");\n return data?.entries ?? [];\n}\n\nasync function save(entries: ChangeEntry[]) {\n await blob.setJSON(\"changes_log\", { entries: entries.slice(0, MAX_ENTRIES) });\n}\n\nexport async function addChanges(\n user: string,\n changes: { code: number; field: \"price\" | \"status\"; newValue: string | number; oldValue?: string | number | null; applyAt?: string | null }[],\n): Promise<{ ok: boolean; added: number; errors: string[] }> {\n const errors: string[] = [];\n const entries = await load();\n\n // Resolve brand/handle/name from overlay + catalog\n const overlay = await blob.getJSON(\"cms_overlay\");\n const catalog = await blob.getJSON(\"catalog\");\n const catByCode: Record = {};\n for (const p of catalog?.products ?? []) catByCode[String(p.code)] = p;\n\n let added = 0;\n for (const ch of changes) {\n const codeStr = String(ch.code);\n const o = overlay?.items?.[codeStr];\n const p = catByCode[codeStr];\n if (!o?.handle) {\n errors.push(`${codeStr}: Shopify handle unknown (add 'Handle' column to Matrixify exports)`);\n continue;\n }\n if (ch.field === \"price\") {\n const v = Number(ch.newValue);\n if (!isFinite(v) || v <= 0) { errors.push(`${codeStr}: invalid price`); continue; }\n }\n if (ch.field === \"status\" && ![\"Active\", \"Draft\"].includes(String(ch.newValue))) {\n errors.push(`${codeStr}: status must be Active or Draft`); continue;\n }\n // Supersede any pending change on the same SKU+field\n for (const e of entries) {\n if (e.code === ch.code && e.field === ch.field && e.status === \"pending\") e.status = \"cancelled\";\n }\n entries.unshift({\n id: crypto.randomUUID().slice(0, 8),\n at: new Date().toISOString(),\n user,\n code: ch.code,\n brand: o.brand ?? p?.brand ?? \"?\",\n handle: o.handle,\n name: p?.name ?? o.title ?? null,\n field: ch.field,\n oldValue: ch.oldValue ?? (ch.field === \"price\" ? (o.price ?? p?.price ?? null) : (o.ss ?? p?.ss ?? null)),\n newValue: ch.newValue,\n status: \"pending\",\n applyAt: ch.applyAt ?? null,\n });\n added++;\n }\n await save(entries);\n return { ok: errors.length === 0, added, errors };\n}\n\nexport async function listChanges(limit = 200): Promise {\n return (await load()).slice(0, limit);\n}\n\n/** Confirm against reality: compare sent changes with the live CMS overlay.\n * Called after each CMS sync. Marks entries \"applied\" once Shopify agrees. */\nexport async function verifyChanges(): Promise<{ checked: number; applied: number }> {\n const entries = await load();\n const overlay = await blob.getJSON(\"cms_overlay\");\n const items = overlay?.items ?? {};\n const syncedAt = overlay?.updated_at ?? \"\";\n let checked = 0, applied = 0;\n\n for (const e of entries) {\n if (e.status !== \"sent\" || !e.sentAt) continue;\n if (syncedAt <= e.sentAt) continue; // site data older than the change\n const o = items[String(e.code)];\n if (!o) continue;\n checked++;\n const ok = e.field === \"price\"\n ? (o.price != null && Math.abs(Number(o.price) - Number(e.newValue)) < 0.02)\n : (String(o.ss ?? \"\") === (String(e.newValue) === \"Draft\" ? \"Inactive\" : \"Active\"));\n if (ok) { e.status = \"applied\"; e.appliedAt = syncedAt; applied++; }\n }\n if (applied > 0) await save(entries);\n return { checked, applied };\n}\n\nexport async function cancelChange(id: string, user: string): Promise {\n const entries = await load();\n const e = entries.find((x) => x.id === id && x.status === \"pending\");\n if (!e) return false;\n e.status = \"cancelled\";\n e.user = `${e.user} (cancelled by ${user})`;\n await save(entries);\n return true;\n}\n\n/** Build the Matrixify import CSV for one brand and mark those changes as sent.\n * Grouped per product (handle): one row per product with the fields to update. */\nexport async function buildFeed(brand: string, consume = true): Promise {\n const entries = await load();\n const now = Date.now();\n const nowISO = new Date(now).toISOString();\n const graceISO = new Date(now - GRACE_HOURS * 3600_000).toISOString();\n const sameBrand = (e: ChangeEntry) => e.brand.toUpperCase() === brand.toUpperCase();\n const due = (e: ChangeEntry) => !e.applyAt || e.applyAt <= nowISO;\n\n // Serve pending changes AND recently-sent ones (idempotent replay window),\n // so a retry or a preview fetch by Matrixify cannot silently swallow them.\n const pending = entries.filter((e) => sameBrand(e) && due(e) && (\n e.status === \"pending\" ||\n (e.status === \"sent\" && (e.sentAt ?? \"\") >= graceISO)\n ));\n\n // Group by handle\n const byHandle: Record = {};\n for (const e of pending) {\n const g = byHandle[e.handle!] ?? { sku: String(e.code) };\n if (e.field === \"price\") g.price = Number(e.newValue);\n if (e.field === \"status\") g.status = String(e.newValue);\n byHandle[e.handle!] = g;\n }\n\n const esc = (v: string | number | undefined | null) => {\n const s = v == null ? \"\" : String(v);\n return /[\",\\n]/.test(s) ? `\"${s.replace(/\"/g, '\"\"')}\"` : s;\n };\n\n // Matrixify rule: identifying a variant (Variant SKU + Variant Command) forces a\n // price — \"Price can't be blank\". So the variant columns are only filled when a\n // price change is actually queued; a status-only row carries product columns alone.\n // An empty Status is simply ignored by Matrixify, so price-only rows are safe.\n const header = \"Handle,Command,Variant SKU,Variant Command,Variant Price,Status\";\n const lines = [header];\n for (const [handle, g] of Object.entries(byHandle)) {\n const hasPrice = g.price != null;\n lines.push([\n esc(handle), \"UPDATE\",\n hasPrice ? esc(g.sku) : \"\",\n hasPrice ? \"MERGE\" : \"\",\n hasPrice ? String(g.price) : \"\",\n g.status ?? \"\",\n ].join(\",\"));\n }\n\n if (consume && pending.length > 0) {\n for (const e of pending) {\n if (e.status === \"pending\") { e.status = \"sent\"; e.sentAt = nowISO; }\n }\n await save(entries);\n }\n return lines.join(\"\\n\") + \"\\n\";\n}\n",[183],"a265801d-8875-4fb7-8fce-a0c2039d4e96","frontend","546e96aa-4a92-41a1-ae78-4dafe4a52758",["D",1785139819731],"directory",[191],"pulls","branches","forks","envVars",{"_203":145,"_205":63},"connections",{"_203":63,"_204":63},"count","unfilledCount","emptyCount",{"_43":190,"_32":191,"_30":192,"_141":-5,"_41":42,"_40":179,"_143":59,"_38":275,"_13":63,"_34":194,"_35":-5,"_24":25,"_148":-5,"_219":276,"_27":277},{"_43":266,"_32":267,"_30":268,"_141":192,"_41":42,"_40":269,"_143":25,"_38":270,"_13":271,"_34":146,"_35":272,"_24":25,"_148":-5,"_219":273,"_27":274},{"_43":258,"_32":259,"_30":260,"_141":192,"_41":42,"_40":261,"_143":25,"_38":262,"_13":63,"_34":146,"_35":263,"_24":25,"_148":-5,"_219":264,"_27":265},{"_43":249,"_32":250,"_30":251,"_141":192,"_41":42,"_40":252,"_143":25,"_38":253,"_13":254,"_34":146,"_35":255,"_24":25,"_148":-5,"_219":256,"_27":257},{"_43":244,"_32":33,"_30":31,"_141":192,"_41":42,"_40":14,"_143":25,"_38":245,"_13":246,"_34":20,"_35":37,"_24":25,"_148":-5,"_219":247,"_27":248},{"_43":237,"_32":238,"_30":239,"_141":192,"_41":42,"_40":170,"_143":59,"_38":240,"_13":63,"_34":146,"_35":241,"_24":25,"_148":-5,"_219":242,"_27":243},{"_43":182,"_32":183,"_30":184,"_141":-5,"_41":42,"_40":185,"_143":25,"_38":234,"_13":187,"_34":146,"_35":188,"_24":25,"_148":-5,"_219":235,"_27":236},{"_43":174,"_32":175,"_30":176,"_141":-5,"_41":42,"_40":177,"_143":25,"_38":231,"_13":179,"_34":146,"_35":180,"_24":25,"_148":-5,"_219":232,"_27":233},{"_43":165,"_32":166,"_30":167,"_141":-5,"_41":42,"_40":168,"_143":25,"_38":228,"_13":170,"_34":171,"_35":172,"_24":25,"_148":-5,"_219":229,"_27":230},{"_43":158,"_32":159,"_30":160,"_141":-5,"_41":42,"_40":161,"_143":59,"_38":225,"_13":63,"_34":146,"_35":163,"_24":25,"_148":-5,"_219":226,"_27":227},{"_43":150,"_32":151,"_30":57,"_141":-5,"_41":42,"_40":152,"_143":25,"_38":222,"_13":145,"_34":154,"_35":155,"_24":25,"_148":156,"_219":223,"_27":224},{"_43":138,"_32":139,"_30":140,"_141":-5,"_41":42,"_40":142,"_143":25,"_38":218,"_13":145,"_34":146,"_35":147,"_24":25,"_148":-5,"_219":220,"_27":221},["D",1785173783552],"children",[],[139],["D",1785227719398],[],[151],["D",1785163617606],[],[159],["D",1785226656859],[],[166],["D",1785163569352],[],[175],["D",1785229867826],[],[183],"d793b23f-1910-405b-9e4c-5078204f6469","index.tsx","9ef593fa-8992-11f1-97f4-1607ee4eb77e",["D",1785139825002],"/** @jsxImportSource https://esm.sh/react@18.2.0 */\nimport { createRoot } from \"https://esm.sh/react-dom@18.2.0/client?deps=react@18.2.0\";\nimport App from \"/frontend/App.tsx\";\n\nconst root = createRoot(document.getElementById(\"root\")!);\nroot.render();\n",[],[191,238],"1c92b63a-3cdd-4fcb-8cb5-82a366da1b2a",["D",1785231021798],1,[],[191,33],"a4c2a384-dece-42f3-8c96-52d173e071b6","helpers.ts","b8853190-8992-11f1-8100-1607ee4eb77e",27,["D",1785163713432],2,"// Shared helpers: formatting, filtering, aggregation, CSV export.\n\nexport interface Product {\n brand: string; code: number; ean?: string | null; name: string;\n cat?: string | null; grp: string; wt?: number | null; carrier?: string | null;\n lc: string; ss: string; sstock?: number | null; s48: number; s47p: number; s47d: number;\n cost?: number | null; pvc?: number | null; deee?: number | null; logi?: number | null;\n be?: number | null; mip?: number | null; rsp?: number | null; mrsp?: number | null;\n price?: number | null; mcur?: number | null; comp?: number | null; compname?: string | null;\n gap?: number | null; pos?: string | null; fc: number; cov?: number | null;\n sales: number; spw?: number | null; st?: number | null; fneed?: string | null;\n cstat: string; cact: string; img?: string | null;\n}\n\nexport const GROUPS = [\n { key: \"Cooling\", label: \"❄️ Cooling\" },\n { key: \"Washing\", label: \"🌊 Washing\" },\n { key: \"Cooking\", label: \"🔥 Cooking\" },\n { key: \"Floorcare\", label: \"🧹 Floorcare\" },\n { key: \"KSDA\", label: \"⚡ KSDA\" },\n { key: \"TV\", label: \"📺 TV\" },\n { key: \"Consumable\", label: \"🛒 Consumable\" },\n { key: \"Other\", label: \"❓ Other\" },\n];\n\nexport const BRAND_COLORS: Record = {\n CANDY: \"bg-sky-600\", HOOVER: \"bg-red-600\", HAIER: \"bg-blue-900\",\n};\n\nexport const fmtInt = (n: number | null | undefined) =>\n n == null ? \"—\" : Math.round(n).toLocaleString(\"en-US\");\n\nexport const fmtEur = (n: number | null | undefined, dec = 2) =>\n n == null ? \"—\" : n.toLocaleString(\"en-US\", { minimumFractionDigits: dec, maximumFractionDigits: dec }) + \" €\";\n\nexport const fmtPct = (n: number | null | undefined, dec = 1) =>\n n == null || !isFinite(n) ? \"—\" : (n * 100).toFixed(dec) + \"%\";\n\n// ── Commercial / technical alert derivation ───────────────────────────────────\nexport interface Alert { type: \"commercial\" | \"technical\"; issue: string; severity: number; detail?: string }\n\nexport function productAlerts(p: Product): Alert[] {\n const out: Alert[] = [];\n const price = p.price ?? 0;\n // Technical (catalogue actions from pipeline)\n if (p.cact && !p.cact.includes(\"No action\") && !p.cact.includes(\"Listing ready\")) {\n out.push({ type: \"technical\", issue: p.cact, severity: p.cact.includes(\"Create\") || p.cact.includes(\"Activate\") ? 1 : 2 });\n }\n // Commercial\n if (price > 0 && p.be != null && price < p.be) {\n out.push({ type: \"commercial\", issue: \"🔴 Price below breakeven\", severity: 1, detail: `${fmtEur(price)} < BE ${fmtEur(p.be)}` });\n } else if (price > 0 && p.mip != null && price < p.mip) {\n out.push({ type: \"commercial\", issue: \"🟠 Price below min internal price\", severity: 2, detail: `${fmtEur(price)} < MIP ${fmtEur(p.mip)}` });\n }\n if (p.pos === \"above\" && price > 0) {\n out.push({ type: \"commercial\", issue: \"🔴 Above market price\", severity: 2, detail: `Gap ${fmtPct(p.gap)} vs ${p.compname ?? \"competitor\"}` });\n }\n const activeLc = !/(End of Life|Phasing Out|Discontinued|Out of SCP)/i.test(p.lc);\n if (activeLc && p.fc > 0 && (p.st ?? 0) < 0.7 && p.s48 > 0 && p.sales >= 0) {\n out.push({ type: \"commercial\", issue: \"🟡 Low sell-through (<70%)\", severity: 3, detail: `${fmtPct(p.st)} — stock ${fmtInt(p.s48)} u` });\n }\n if (p.fneed && (p.fneed.includes(\"to plan\") || p.fneed.includes(\"to forecast\"))) {\n out.push({ type: \"commercial\", issue: \"📈 Forecast insufficient\", severity: 2, detail: p.fneed });\n }\n return out;\n}\n\n// ── Aggregation ───────────────────────────────────────────────────────────────\nexport function aggregate(products: Product[]) {\n const sales = products.reduce((s, p) => s + (p.sales || 0), 0);\n const fc = products.reduce((s, p) => s + (p.fc || 0), 0);\n const active = products.filter((p) => p.ss === \"Active\").length;\n const alerts = products.reduce((s, p) => s + productAlerts(p).length, 0);\n // Revenue estimate = Σ site price × units sold (only products with a price)\n const rev = products.reduce((s, p) => s + ((p.price ?? 0) * (p.sales || 0)), 0);\n // Revenue-weighted average current margin\n let wm = 0, wrev = 0;\n for (const p of products) {\n if (p.mcur != null && p.price && p.sales > 0) { wm += p.mcur * p.price * p.sales; wrev += p.price * p.sales; }\n }\n const avgMargin = wrev > 0 ? wm / wrev : null;\n return { count: products.length, sales, fc, st: fc > 0 ? sales / fc : null, active, alerts, rev, avgMargin };\n}\n\nexport const fmtEurK = (n: number | null | undefined) => {\n if (n == null || !isFinite(n)) return \"—\";\n if (Math.abs(n) >= 1e6) return (n / 1e6).toFixed(2) + \" M€\";\n if (Math.abs(n) >= 1e3) return (n / 1e3).toFixed(1) + \" k€\";\n return n.toFixed(0) + \" €\";\n};\n\nexport function groupBy(arr: T[], key: (t: T) => string): Record {\n const out: Record = {};\n for (const item of arr) (out[key(item)] ??= []).push(item);\n return out;\n}\n\n// ── CSV export ────────────────────────────────────────────────────────────────\nexport function downloadCSV(filename: string, headers: string[], rows: (string | number | null | undefined)[][]) {\n const esc = (v: string | number | null | undefined) => {\n const s = v == null ? \"\" : String(v);\n return /[\",;\\n]/.test(s) ? `\"${s.replace(/\"/g, '\"\"')}\"` : s;\n };\n const csv = [headers.map(esc).join(\";\"), ...rows.map((r) => r.map(esc).join(\";\"))].join(\"\\n\");\n const blob = new Blob([\"\" + csv], { type: \"text/csv;charset=utf-8\" });\n const a = document.createElement(\"a\");\n a.href = URL.createObjectURL(blob);\n a.download = filename;\n a.click();\n URL.revokeObjectURL(a.href);\n}\n",[],[191,250],"04159cf2-2255-4396-835d-0d2ca8ffa01e","Icons.tsx","96400b58-8a66-11f1-9484-1607ee4eb77e",129,["D",1785230863719],"/** @jsxImportSource https://esm.sh/react@18.2.0 */\n// Monochrome stroke icons (inherit currentColor) — no external assets.\n\nconst base = {\n fill: \"none\",\n stroke: \"currentColor\",\n strokeWidth: 1.7,\n strokeLinecap: \"round\" as const,\n strokeLinejoin: \"round\" as const,\n};\n\nconst Svg = ({ children, size = 20 }: any) => (\n \n);\n\nexport const IconOverview = (p: any) => (\n \n);\nexport const IconProducts = (p: any) => (\n \n);\nexport const IconScorecard = (p: any) => (\n \n);\nexport const IconBusiness = (p: any) => (\n \n);\nexport const IconLogistic = (p: any) => (\n \n);\nexport const IconAction = (p: any) => (\n \n);\nexport const IconChanges = (p: any) => (\n \n);\nexport const IconLogout = (p: any) => (\n \n);\nexport const IconSearch = (p: any) => (\n \n);\nexport const IconRefresh = (p: any) => (\n \n);\n\n// KPI tile icons\nexport const IconBox = (p: any) => (\n \n);\nexport const IconCheck = (p: any) => ();\nexport const IconCart = (p: any) => (\n \n);\nexport const IconEuro = (p: any) => (\n \n);\nexport const IconForecast = (p: any) => (\n \n);\nexport const IconTrend = (p: any) => (\n \n);\nexport const IconAlert = (p: any) => (\n \n);\nexport const IconUnits = (p: any) => (\n \n);\nexport const IconTruck = IconLogistic;\nexport const IconScale = (p: any) => (\n \n);\nexport const IconClock = (p: any) => (\n \n);\nexport const IconReceipt = (p: any) => (\n \n);\nexport const IconReturn = (p: any) => (\n \n);\nexport const IconMargin = (p: any) => (\n \n);\nexport const IconPrint = (p: any) => (\n \n);\nexport const IconDownload = (p: any) => (\n \n);\nexport const IconColumns = (p: any) => (\n \n);\nexport const IconSave = (p: any) => (\n \n);\n",[],[191,259],"09e3fe05-ab22-4c3f-9867-f25a600aa131","App.tsx","f5a60b8a-8992-11f1-807a-1607ee4eb77e",151,["D",1785231018534],71,"/** @jsxImportSource https://esm.sh/react@18.2.0 */\nimport { useEffect, useMemo, useState } from \"https://esm.sh/react@18.2.0\";\nimport {\n Alert, BRAND_COLORS, downloadCSV, fmtEur, fmtEurK, fmtInt, fmtPct, GROUPS, groupBy,\n Product, productAlerts, aggregate,\n} from \"/frontend/helpers.ts\";\nimport * as Ico from \"/frontend/Icons.tsx\";\n\nconst NAVY = \"#1F3864\";\nconst ACCENT = \"#4F46E5\";\nconst BRANDS = [\"CANDY\", \"HOOVER\", \"HAIER\"];\nconst TABS = [\n { id: \"overview\", label: \"Overview\", Icon: Ico.IconOverview },\n { id: \"products\", label: \"Products\", Icon: Ico.IconProducts },\n { id: \"bestsellers\", label: \"Scorecards\", Icon: Ico.IconScorecard },\n { id: \"business\", label: \"Business\", Icon: Ico.IconBusiness },\n { id: \"logistic\", label: \"Logistic\", Icon: Ico.IconLogistic },\n { id: \"actions\", label: \"Action Plan\", Icon: Ico.IconAction },\n { id: \"changes\", label: \"Changes\", Icon: Ico.IconChanges },\n] as const;\n\ntype TabId = typeof TABS[number][\"id\"];\n\nexport default function App() {\n const [data, setData] = useState(null);\n const [error, setError] = useState(null);\n const [tab, setTab] = useState(\"overview\");\n const [changes, setChanges] = useState([]);\n\n const loadChanges = () => {\n fetch(\"/api/changes\").then((r) => r.ok ? r.json() : { entries: [] })\n .then((j) => setChanges(j.entries ?? [])).catch(() => {});\n };\n\n useEffect(() => {\n fetch(\"/api/data\").then(async (r) => {\n if (!r.ok) {\n const j = await r.json().catch(() => ({}));\n setError(j.message ?? `Error ${r.status}`);\n return;\n }\n setData(await r.json());\n }).catch((e) => setError(String(e)));\n loadChanges();\n }, []);\n\n if (error) {\n return (\n

📭

No data available

{error}

\n );\n }\n if (!data) {\n return (\n

Loading dashboard…

\n );\n }\n\n const products: Product[] = data.products;\n const pendingByCode = new Set(changes.filter((c) => c.status === \"pending\").map((c) => c.code));\n const nPending = pendingByCode.size;\n\n const current = TABS.find((t) => t.id === tab)!;\n\n return (\n

\n {/* ── Sidebar ─────────────────────────────────────────────── */}\n

D2C

D2C France

Haier · Candy · Hoover

\n\n

\n {TABS.map((t) => {\n const active = tab === t.id;\n const Icon = t.Icon;\n return (\n \n );\n })}\n

\n\n

\n {data.viewer?.email ?? data.viewer?.username}\n

\n \n view source\n

\n\n {/* ── Main ────────────────────────────────────────────────── */}\n

\n \n

{current.label}

\n \n \n Catalogue {data.generated_at ? new Date(data.generated_at).toLocaleDateString(\"fr-FR\") : \"?\"}\n \n {data.cms_synced_at && (\n Site {new Date(data.cms_synced_at).toLocaleString(\"fr-FR\", { day: \"2-digit\", month: \"2-digit\", hour: \"2-digit\", minute: \"2-digit\" })}\n )}\n

\n\n

\n {tab === \"overview\" && }\n {tab === \"products\" && }\n {tab === \"bestsellers\" && }\n {tab === \"business\" && }\n {tab === \"logistic\" && }\n {tab === \"actions\" && }\n {tab === \"changes\" && }\n

\n );\n}\n\n// ═══════════════════════════════ OVERVIEW ═══════════════════════════════════\nfunction Overview({ products }: { products: Product[] }) {\n const tot = aggregate(products);\n const byBrand = BRANDS.map((b) => ({ brand: b, ...aggregate(products.filter((p) => p.brand === b)) }));\n const byGroup = GROUPS.map((g) => ({ ...g, ...aggregate(products.filter((p) => p.grp === g.key)) }))\n .filter((g) => g.count > 0);\n\n return (\n

\n \n \n \n \n \n \n \n

\n\n

\n \n ({ key: b.brand, label: , ...b }))}\n total={tot} />\n \n \n ({ key: g.key, label: g.label, ...g }))} />\n \n

\n );\n}\n\nfunction PerfTable({ rows, total }: { rows: any[]; total?: any }) {\n return (\n \n \n \n \n \n \n \n {rows.map((r) => (\n \n \n \n \n \n \n \n \n ))}\n {total && (\n \n \n \n \n \n \n \n \n )}\n \n

	Products	Sales (u)	Revenue est.	Forecast (u)	Sell-thru
{r.label}	{fmtInt(r.count)}	{fmtInt(r.sales)}	{fmtEurK(r.rev)}	{fmtInt(r.fc)}
TOTAL	{fmtInt(total.count)}	{fmtInt(total.sales)}	{fmtEurK(total.rev)}	{fmtInt(total.fc)}	{fmtPct(total.st)}

\n );\n}\n\n// ═══════════════════════════════ PRODUCTS ═══════════════════════════════════\ninterface ViewDef { name: string; q: string; brand: string | null; grp: string | null; lc: string; ss: string; alertsOnly: boolean }\n\nfunction loadViews(): ViewDef[] {\n try { return JSON.parse(localStorage.getItem(\"d2c_views\") ?? \"[]\"); } catch { return []; }\n}\n\nfunction Products({ products, pendingByCode, onChanged }:\n { products: Product[]; pendingByCode: Set; onChanged: () => void }) {\n const [q, setQ] = useState(\"\");\n const [brand, setBrand] = useState(null);\n const [grp, setGrp] = useState(null);\n const [lc, setLc] = useState(\"\");\n const [ss, setSs] = useState(\"\");\n const [alertsOnly, setAlertsOnly] = useState(false);\n const [sort, setSort] = useState<{ k: keyof Product; dir: 1 | -1 }>({ k: \"sales\", dir: -1 });\n const [sel, setSel] = useState>(new Set());\n const [modal, setModal] = useState(null);\n const openModal = (kind: any, value = \"\") =>\n setModal({ kind, value, rounding: \"none\", when: \"now\", at: \"\" });\n\n const roundPrice = (v: number, rule: string): number => {\n if (rule === \"ceil\") return Math.ceil(v);\n if (rule === \"floor\") return Math.floor(v);\n if (rule === \"psy\") return Math.ceil((v + 0.01) / 10) * 10 - 0.01; // next price ending in 9.99\n return Math.round(v * 100) / 100;\n };\n const [busy, setBusy] = useState(false);\n const [views, setViews] = useState(loadViews());\n const [issueFilter, setIssueFilter] = useState(\"\");\n const [colsOpen, setColsOpen] = useState(false);\n const [hiddenCols, setHiddenCols] = useState>(() => {\n try { return new Set(JSON.parse(localStorage.getItem(\"d2c_hidden_cols\") ?? \"[]\")); } catch { return new Set(); }\n });\n\n const toggleCol = (k: string) => {\n const s = new Set(hiddenCols);\n s.has(k) ? s.delete(k) : s.add(k);\n setHiddenCols(s);\n localStorage.setItem(\"d2c_hidden_cols\", JSON.stringify([...s]));\n };\n const vis = (k: string) => !hiddenCols.has(k);\n\n const COL_DEFS: { k: string; label: string }[] = [\n { k: \"cat\", label: \"Category\" }, { k: \"lc\", label: \"Lifecycle\" }, { k: \"ss\", label: \"Site\" },\n { k: \"s48\", label: \"Stock 48\" }, { k: \"s47p\", label: \"Area 47 stock\" }, { k: \"s47d\", label: \"Area 47 avail. M3\" },\n { k: \"pvc\", label: \"RRP\" }, { k: \"be\", label: \"Breakeven\" },\n { k: \"price\", label: \"Site price\" }, { k: \"comp\", label: \"Min comp\" }, { k: \"compname\", label: \"Cheapest competitor\" },\n { k: \"gap\", label: \"Gap\" }, { k: \"mcur\", label: \"Margin\" }, { k: \"fc\", label: \"Forecast\" },\n { k: \"sales\", label: \"Sales YTD\" }, { k: \"st\", label: \"Sell-thru\" },\n ];\n\n const lifecycles = useMemo(() => [...new Set(products.map((p) => p.lc))].sort(), [products]);\n const statuses = useMemo(() => [...new Set(products.map((p) => p.ss))].sort(), [products]);\n const allIssues = useMemo(() => {\n const counts: Record = {};\n for (const p of products) for (const a of productAlerts(p)) counts[a.issue] = (counts[a.issue] ?? 0) + 1;\n return Object.entries(counts).sort((a, b) => b[1] - a[1]);\n }, [products]);\n\n const filtered = useMemo(() => {\n const ql = q.trim().toLowerCase();\n let out = products.filter((p) =>\n (!brand || p.brand === brand) &&\n (!grp || p.grp === grp) &&\n (!lc || p.lc === lc) &&\n (!ss || p.ss === ss) &&\n (!alertsOnly || productAlerts(p).length > 0) &&\n (!issueFilter || productAlerts(p).some((a) => a.issue === issueFilter)) &&\n (!ql || String(p.code).includes(ql) || p.name.toLowerCase().includes(ql) ||\n (p.cat ?? \"\").toLowerCase().includes(ql))\n );\n out = [...out].sort((a, b) => {\n const va = a[sort.k] ?? -Infinity, vb = b[sort.k] ?? -Infinity;\n return (va < vb ? -1 : va > vb ? 1 : 0) * sort.dir;\n });\n return out;\n }, [products, q, brand, grp, lc, ss, alertsOnly, issueFilter, sort]);\n\n const toggleSel = (code: number) => {\n const s = new Set(sel);\n s.has(code) ? s.delete(code) : s.add(code);\n setSel(s);\n };\n const selectAllFiltered = () => setSel(new Set(filtered.map((p) => p.code)));\n\n const applyView = (v: ViewDef) => {\n setQ(v.q); setBrand(v.brand); setGrp(v.grp); setLc(v.lc); setSs(v.ss); setAlertsOnly(v.alertsOnly);\n };\n const saveCurrentView = () => {\n const name = prompt(\"Nom de la vue :\");\n if (!name) return;\n const next = [...views.filter((v) => v.name !== name), { name, q, brand, grp, lc, ss, alertsOnly }];\n setViews(next); localStorage.setItem(\"d2c_views\", JSON.stringify(next));\n };\n const deleteView = (name: string) => {\n const next = views.filter((v) => v.name !== name);\n setViews(next); localStorage.setItem(\"d2c_views\", JSON.stringify(next));\n };\n\n const submitChanges = async () => {\n if (!modal) return;\n const selProducts = products.filter((p) => sel.has(p.code));\n const applyAt = modal.when === \"later\" && modal.at\n ? new Date(modal.at).toISOString() : null;\n const changes: any[] = [];\n let skipped = 0;\n for (const p of selProducts) {\n if (modal.kind === \"status\") {\n changes.push({ code: p.code, field: \"status\", newValue: modal.value, oldValue: p.ss, applyAt });\n continue;\n }\n let np: number | null = null;\n if (modal.kind === \"price\") np = Number(modal.value);\n else if (modal.kind === \"pct\") np = p.price ? p.price * (1 + Number(modal.value) / 100) : null;\n else if (modal.kind === \"align_be\") np = p.be ?? null;\n else if (modal.kind === \"align_mip\") np = p.mip ?? null;\n else if (modal.kind === \"align_rrp\") np = p.pvc ?? null;\n else if (modal.kind === \"align_comp\") np = (p.comp && p.comp > 0) ? p.comp : null;\n else if (modal.kind === \"margin\") {\n const m = Number(modal.value) / 100;\n np = (p.cost != null && m < 1) ? ((p.cost + (p.deee ?? 0)) / (1 - m)) * 1.2 : null;\n }\n if (np == null || !isFinite(np) || np <= 0) { skipped++; continue; }\n if ([\"align_comp\", \"margin\", \"pct\"].includes(modal.kind)) np = roundPrice(np, modal.rounding);\n else np = Math.round(np * 100) / 100;\n changes.push({ code: p.code, field: \"price\", newValue: np, oldValue: p.price ?? null, applyAt });\n }\n if (changes.length === 0) { alert(`Aucun produit applicable (référence de prix manquante — ${skipped} ignoré(s))`); return; }\n if (skipped > 0 && !confirm(`${skipped} produit(s) ignoré(s) (référence manquante). Continuer avec ${changes.length} ?`)) return;\n setBusy(true);\n const r = await fetch(\"/api/changes\", {\n method: \"POST\", headers: { \"Content-Type\": \"application/json\" },\n body: JSON.stringify({ changes }),\n });\n const j = await r.json();\n setBusy(false); setModal(null); setSel(new Set());\n onChanged();\n alert(`${j.added} modification(s) en file d'attente.` +\n (j.errors?.length ? `\\n\\nErreurs :\\n${j.errors.join(\"\\n\")}` : \"\"));\n };\n\n const Th = ({ k, children, right = true }: any) => (\n setSort((s) => ({ k, dir: s.k === k ? (s.dir === 1 ? -1 : 1) : -1 }))}>\n {children}{sort.k === k ? (sort.dir === -1 ? \" ↓\" : \" ↑\") : \"\"}\n \n );\n\n return (\n

\n \n {views.length > 0 && (\n

\n Vues :\n {views.map((v) => (\n \n \n \n \n ))}\n

\n )}\n

\n setQ(e.target.value)} placeholder=\"Search SKU / name / category…\"\n className=\"px-3 py-2 border rounded-lg text-sm w-64\" />\n \n \n \n \n setAlertsOnly(e.target.checked)} />\n With alerts only\n \n \n

\n \n {colsOpen && (\n

\n {COL_DEFS.map((c) => (\n \n toggleCol(c.k)} />\n {c.label}\n \n ))}\n

\n )}\n

\n \n

\n setBrand(null)}>All brands\n {BRANDS.map((b) => setBrand(brand === b ? null : b)}>{b})}\n |\n setGrp(null)}>All categories\n {GROUPS.filter((g) => g.key !== \"Other\").map((g) =>\n setGrp(grp === g.key ? null : g.key)}>{g.label})}\n

\n \n\n {/* Bulk action bar */}\n {sel.size > 0 && (\n

\n {sel.size} selected\n \n \n |\n Align to:\n \n \n \n \n \n |\n \n \n \n

\n )}\n\n \n

\n \n \n \n \n \n {vis(\"cat\") && }\n {vis(\"lc\") && }\n {vis(\"ss\") && }\n {vis(\"s48\") && }\n {vis(\"s47p\") && }\n {vis(\"s47d\") && }\n {vis(\"pvc\") && }\n {vis(\"be\") && }\n {vis(\"price\") && }\n {vis(\"comp\") && }\n {vis(\"compname\") && }\n {vis(\"gap\") && }\n {vis(\"mcur\") && }\n {vis(\"fc\") && }\n {vis(\"sales\") && }\n {vis(\"st\") && }\n \n \n {filtered.slice(0, 400).map((p) => (\n \n \n \n \n {vis(\"cat\") && }\n {vis(\"lc\") && }\n {vis(\"ss\") && }\n {vis(\"s48\") && }\n {vis(\"s47p\") && }\n {vis(\"s47d\") && }\n {vis(\"pvc\") && }\n {vis(\"be\") && }\n {vis(\"price\") && }\n {vis(\"comp\") && }\n {vis(\"compname\") && }\n {vis(\"gap\") && }\n {vis(\"mcur\") && }\n {vis(\"fc\") && }\n {vis(\"sales\") && }\n {vis(\"st\") && }\n \n ))}\n \n

0 && sel.size >= filtered.length}\n onChange={(e) => e.target.checked ? selectAllFiltered() : setSel(new Set())} />	SKU	Product	Category	Lifecycle	Site	Stock 48	Area 47 stock	Area 47 avail. M3	RRP	Breakeven	Site price	Min comp	Cheapest comp.	Gap	Margin	Forecast	Sales YTD	Sell-thru
toggleSel(p.code)} />	{p.code}{pendingByCode.has(p.code) ? \" ⏳\" : \"\"}	\n {p.name}\n	{p.cat ?? \"—\"}	{p.lc}		{fmtInt(p.s48)}	{fmtInt(p.s47p)}	{fmtInt(p.s47d)}	{fmtEur(p.pvc)}	{fmtEur(p.be)}		{fmtEur(p.comp)}	{p.compname ?? \"—\"}		{fmtPct(p.mcur)}	{fmtInt(p.fc)}	{fmtInt(p.sales)}

\n {filtered.length > 400 && (\n

Showing first 400 rows — refine filters or export CSV.

\n )}\n

\n \n\n {/* Edit modal */}\n {modal && (\n

!busy && setModal(null)}>\n

e.stopPropagation()}>\n

\n {modal.kind === \"price\" ? \"💶 Set price (€ incl. VAT)\" :\n modal.kind === \"pct\" ? \"％ Adjust price (%)\" :\n modal.kind === \"align_be\" ? \"⚖️ Align to Breakeven\" :\n modal.kind === \"align_mip\" ? \"⚖️ Align to Min Internal Price\" :\n modal.kind === \"align_rrp\" ? \"⚖️ Align to RRP\" :\n modal.kind === \"align_comp\" ? \"⚔️ Align to cheapest competitor\" :\n modal.kind === \"margin\" ? \"🎯 Set price for target margin\" :\n modal.value === \"Active\" ? \"▶️ Activate listings\" : \"⏸️ Deactivate listings\"}\n

{sel.size} product(s) selected. Changes go to the queue and reach Shopify at the next hourly Matrixify import.

\n {[\"price\", \"pct\", \"margin\"].includes(modal.kind) && (\n setModal({ ...modal, value: e.target.value })}\n placeholder={modal.kind === \"price\" ? \"ex: 499.99\" :\n modal.kind === \"margin\" ? \"marge cible en % — ex: 25\" : \"ex: -5 (baisse de 5%)\"}\n className=\"w-full px-3 py-2 border rounded-lg mb-3\" />\n )}\n {[\"align_comp\", \"margin\", \"pct\"].includes(modal.kind) && (\n

\n Rounding rule\n \n

\n )}\n

\n Apply\n

\n \n setModal({ ...modal, when: \"now\" })} /> Now\n \n \n setModal({ ...modal, when: \"later\" })} /> Schedule (FR time)\n \n {modal.when === \"later\" && (\n setModal({ ...modal, at: e.target.value })}\n className=\"px-2 py-1.5 border rounded-lg text-sm\" />\n )}\n

\n \n \n

\n )}\n

\n );\n}\n\nfunction exportProducts(list: Product[]) {\n downloadCSV(\"products_export.csv\",\n [\"SKU\", \"EAN\", \"Name\", \"Brand\", \"Category\", \"Group\", \"Lifecycle\", \"Site status\", \"Stock48\", \"Stock47\", \"Site price\", \"Breakeven\", \"Min internal\", \"RSP\", \"Min competitor\", \"Cheapest competitor\", \"Gap %\", \"Margin %\", \"Forecast\", \"Sales YTD\", \"Sales/wk\", \"Sell-through %\", \"Revenue est.\", \"Catalogue action\"],\n list.map((p) => [p.code, p.ean ?? \"\", p.name, p.brand, p.cat ?? \"\", p.grp, p.lc, p.ss, p.s48, p.s47p,\n p.price ?? \"\", p.be ?? \"\", p.mip ?? \"\", p.rsp ?? \"\", p.comp ?? \"\", p.compname ?? \"\",\n p.gap != null ? (p.gap * 100).toFixed(1) : \"\", p.mcur != null ? (p.mcur * 100).toFixed(1) : \"\",\n p.fc, p.sales, p.spw ?? \"\", p.st != null ? (p.st * 100).toFixed(1) : \"\",\n p.price ? Math.round(p.price * p.sales) : \"\", p.cact]));\n}\n\n// ═══════════════════════════ SCORECARDS (BEST SELLERS) ══════════════════════\nfunction BestSellers({ products }: { products: Product[] }) {\n const [scopeType, setScopeType] = useState<\"all\" | \"brand\" | \"group\">(\"all\");\n const [scopeVal, setScopeVal] = useState(\"\");\n const [rankBy, setRankBy] = useState<\"units\" | \"revenue\">(\"units\");\n const [trends, setTrends] = useState([]);\n\n useEffect(() => {\n fetch(\"/api/trends?days=60\").then((r) => r.ok ? r.json() : { series: [] })\n .then((j) => setTrends(j.series ?? [])).catch(() => {});\n }, []);\n\n const scoped = useMemo(() => {\n if (scopeType === \"brand\" && scopeVal) return products.filter((p) => p.brand === scopeVal);\n if (scopeType === \"group\" && scopeVal) return products.filter((p) => p.grp === scopeVal);\n return products;\n }, [products, scopeType, scopeVal]);\n\n const top = useMemo(() => {\n const arr = [...scoped];\n arr.sort((a, b) => rankBy === \"units\" ? b.sales - a.sales\n : ((b.price ?? 0) * b.sales) - ((a.price ?? 0) * a.sales));\n return arr.slice(0, 20);\n }, [scoped, rankBy]);\n\n const agg = aggregate(scoped);\n const scopeLabel = scopeType === \"all\" ? \"All catalogue\" :\n scopeType === \"brand\" ? scopeVal : GROUPS.find((g) => g.key === scopeVal)?.label ?? scopeVal;\n\n // Trend series for the scope (category scope → that group; else sum of all groups)\n const trendSeries = useMemo(() => {\n const byDate: Record = {};\n for (const row of trends) {\n if (scopeType === \"group\" && scopeVal && row.grp !== scopeVal) continue;\n byDate[row.date] = (byDate[row.date] ?? 0) + (row.sales ?? 0);\n }\n return Object.entries(byDate).sort((a, b) => a[0] < b[0] ? -1 : 1)\n .map(([date, sales]) => ({ date, sales }));\n }, [trends, scopeType, scopeVal]);\n\n const maxRev = Math.max(...top.map((p) => (p.price ?? 0) * p.sales), 1);\n\n return (\n

\n \n

\n { setScopeType(\"all\"); setScopeVal(\"\"); }}>Whole catalogue\n |\n {BRANDS.map((b) => (\n { setScopeType(\"brand\"); setScopeVal(b); }}>{b}\n ))}\n |\n {GROUPS.filter((g) => g.key !== \"Other\").map((g) => (\n { setScopeType(\"group\"); setScopeVal(g.key); }}>{g.label}\n ))}\n

\n setRankBy(\"units\")}>Rank by units\n setRankBy(\"revenue\")}>Rank by revenue\n \n \n

\n \n\n {/* Printable scorecard */}\n

Commercial Scorecard — {scopeLabel}

D2C France · Haier Candy Hoover · {new Date().toLocaleDateString(\"fr-FR\")}

🏆

\n\n

\n \n \n \n \n \n \n

\n\n {trendSeries.length >= 3 && (\n

Sales trend (daily units, last 60 days)

\n \n

\n )}\n\n

Top 20 — ranked by {rankBy === \"units\" ? \"units sold\" : \"revenue\"}

\n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n {top.map((p, i) => {\n const rev = (p.price ?? 0) * p.sales;\n return (\n \n \n \n \n \n \n \n \n \n \n \n \n \n \n );\n })}\n \n

#	SKU	Product	Category	Sales (u)	Revenue est.	Share	Sell-thru	Margin	Price	Stock 48	Position
{i + 1}	{p.code}	{p.name}	{p.cat ?? \"—\"}	{fmtInt(p.sales)}	{fmtEurK(rev)}	\n \n \n \n		{fmtPct(p.mcur)}	{fmtEur(p.price)}	{fmtInt(p.s48)}

\n );\n}\n\n/** SVG line chart of daily sales deltas computed from cumulative snapshots. */\nfunction TrendChart({ series }: { series: { date: string; sales: number }[] }) {\n const deltas = series.slice(1).map((s, i) => ({\n date: s.date,\n v: Math.max(0, s.sales - series[i].sales),\n }));\n if (deltas.length < 2) return

Collecting history — chart appears after a few days of snapshots.

;\n const W = 800, H = 120, PAD = 4;\n const max = Math.max(...deltas.map((d) => d.v), 1);\n const pts = deltas.map((d, i) => {\n const x = PAD + (i / (deltas.length - 1)) * (W - 2 * PAD);\n const y = H - PAD - (d.v / max) * (H - 2 * PAD);\n return `${x},${y}`;\n });\n return (\n \n );\n}\n\nfunction exportBestSellers(top: Product[], scope: string) {\n downloadCSV(`scorecard_${scope.replace(/\\W+/g, \"_\")}.csv`,\n [\"Rank\", \"SKU\", \"Name\", \"Brand\", \"Category\", \"Sales YTD\", \"Revenue est.\", \"Sales/wk\", \"Forecast\", \"Sell-through %\", \"Margin %\", \"Site price\", \"Stock48\", \"Price position\"],\n top.map((p, i) => [i + 1, p.code, p.name, p.brand, p.cat ?? \"\", p.sales,\n p.price ? Math.round(p.price * p.sales) : \"\", p.spw ?? \"\", p.fc,\n p.st != null ? (p.st * 100).toFixed(1) : \"\", p.mcur != null ? (p.mcur * 100).toFixed(1) : \"\",\n p.price ?? \"\", p.s48, p.pos ?? \"\"]));\n}\n\n// ═══════════════════════════ ACTION PLAN ════════════════════════════════════\nfunction ActionPlan({ products }: { products: Product[] }) {\n const [typeFilter, setTypeFilter] = useState<\"all\" | \"commercial\" | \"technical\">(\"all\");\n\n const rows = useMemo(() => {\n const out: { p: Product; a: Alert }[] = [];\n for (const p of products) for (const a of productAlerts(p)) out.push({ p, a });\n return out.sort((x, y) => x.a.severity - y.a.severity || y.p.sales - x.p.sales);\n }, [products]);\n\n const filtered = typeFilter === \"all\" ? rows : rows.filter((r) => r.a.type === typeFilter);\n const byIssue = groupBy(filtered, (r) => r.a.issue);\n const nCom = rows.filter((r) => r.a.type === \"commercial\").length;\n const nTec = rows.filter((r) => r.a.type === \"technical\").length;\n\n return (\n

\n \n \n \n

\n\n

\n \n

\n\n {Object.entries(byIssue).map(([issue, items]) => (\n 1 ? \"s\" : \"\"}`}>\n

\n \n \n \n \n \n \n \n \n \n \n \n {items.slice(0, 100).map(({ p, a }, i) => (\n \n \n \n \n \n \n \n \n \n ))}\n \n

SKU	Product	Lifecycle	Stock 48	Site price	Sales YTD	Detail
{p.code}	{p.name}	{p.lc}	{fmtInt(p.s48)}	{fmtEur(p.price)}	{fmtInt(p.sales)}	{a.detail ?? \"\"}

\n \n ))}\n {filtered.length === 0 && (\n

No open actions for this filter.

\n )}\n

\n );\n}\n\nfunction exportActions(rows: { p: Product; a: Alert }[]) {\n downloadCSV(\"action_plan.csv\",\n [\"Type\", \"Issue\", \"SKU\", \"Name\", \"Brand\", \"Category\", \"Lifecycle\", \"Stock48\", \"Site price\", \"Sales YTD\", \"Detail\"],\n rows.map(({ p, a }) => [a.type, a.issue, p.code, p.name, p.brand, p.cat ?? \"\", p.lc, p.s48, p.price ?? \"\", p.sales, a.detail ?? \"\"]));\n}\n\n// ═══════════════════════════ CHANGES (audit + queue) ═════════════════════════\nfunction ChangesTab({ entries, refresh }: { entries: any[]; refresh: () => void }) {\n const pending = entries.filter((e) => e.status === \"pending\");\n const others = entries.filter((e) => e.status !== \"pending\").slice(0, 100);\n\n const cancel = async (id: string) => {\n await fetch(\"/api/changes/cancel\", {\n method: \"POST\", headers: { \"Content-Type\": \"application/json\" },\n body: JSON.stringify({ id }),\n });\n refresh();\n };\n\n const fmtVal = (e: any, v: any) => e.field === \"price\" ? fmtEur(Number(v)) : String(v ?? \"—\");\n\n const Row = ({ e, showCancel }: any) => (\n \n {new Date(e.at).toLocaleString(\"fr-FR\")}\n {e.user}\n {e.code}\n {e.name ?? \"—\"}\n {e.brand}\n {e.field === \"price\" ? \"💶 Price\" : \"📄 Status\"}\n {fmtVal(e, e.oldValue)}\n {fmtVal(e, e.newValue)}\n \n {e.status === \"pending\" && (\n e.applyAt && new Date(e.applyAt) > new Date()\n ? 🕐 scheduled {new Date(e.applyAt).toLocaleString(\"fr-FR\")}\n : ⏳ pending\n )}\n {e.status === \"sent\" && 📤 sent {e.sentAt ? new Date(e.sentAt).toLocaleString(\"fr-FR\") : \"\"}}\n {e.status === \"applied\" && ✅ live {e.appliedAt ? new Date(e.appliedAt).toLocaleString(\"fr-FR\") : \"\"}}\n {e.status === \"cancelled\" && ✖ cancelled}\n \n {showCancel && (\n \n )}\n \n );\n\n const Tbl = ({ rows, showCancel }: any) => (\n

\n \n \n \n \n \n \n \n \n {rows.map((e: any) => )}\n

Date	User	SKU	Product	Brand	Field	Before	After	Status

\n );\n\n return (\n

\n \n {pending.length === 0\n ?

No pending changes. Select products in the Products tab to queue price or status updates.

\n : }\n

\n ⏳ pending → 📤 sent (picked up by Matrixify) → ✅ live (confirmed on the site by the CMS sync).\n Sent changes stay in the feed for 12 h, so a Matrixify retry re-applies them safely.\n A change stuck on \"sent\" means Matrixify fetched it but the import did not apply it — check the Matrixify job history.\n

\n \n \n {others.length === 0\n ?

No history yet.

\n : }\n \n

\n );\n}\n\n// ═══════════════════════════ LOGISTIC ═══════════════════════════════════════\nfunction LogisticTab({ products }: { products: Product[] }) {\n const [brand, setBrand] = useState(null);\n const [grp, setGrp] = useState(null);\n const [from, setFrom] = useState(() => new Date().getFullYear() + \"-01-01\");\n const [to, setTo] = useState(() => new Date().toISOString().slice(0, 10));\n const [orders, setOrders] = useState(undefined); // undefined=loading, null=absent\n\n useEffect(() => {\n fetch(\"/api/business\").then((r) => r.ok ? r.json() : null)\n .then(setOrders).catch(() => setOrders(null));\n }, []);\n\n const skuInfo = useMemo(() => {\n const m: Record = {};\n for (const p of products) m[String(p.code)] = p;\n return m;\n }, [products]);\n\n const hasOrders = orders !== undefined && orders !== null && Array.isArray(orders?.lines) && orders.lines.length > 0;\n\n // Units per SKU on the selected period:\n // - with orders feed: real units shipped in [from, to]\n // - fallback: catalog Sales YTD (date filter inactive)\n const unitsBySku = useMemo(() => {\n const m: Record = {};\n if (hasOrders) {\n for (const l of orders.lines) {\n if ((l.k ?? \"ord\") !== \"ful\") continue; // logistics cost applies to shipped units\n if (!l.sku || l.d < from || l.d > to) continue;\n const p = skuInfo[l.sku];\n if (!p || p.logi == null) continue;\n if (brand && p.brand !== brand) continue;\n if (grp && p.grp !== grp) continue;\n m[l.sku] = (m[l.sku] ?? 0) + l.q;\n }\n } else {\n for (const p of products) {\n if (p.logi == null || !p.sales) continue;\n if (brand && p.brand !== brand) continue;\n if (grp && p.grp !== grp) continue;\n m[String(p.code)] = p.sales;\n }\n }\n return m;\n }, [hasOrders, orders, skuInfo, products, brand, grp, from, to]);\n\n const rows = useMemo(() => {\n const out = Object.entries(unitsBySku)\n .map(([sku, units]) => ({ p: skuInfo[sku], units }))\n .filter((r) => r.p);\n out.sort((a, b) => ((b.p.logi ?? 0) * b.units) - ((a.p.logi ?? 0) * a.units));\n return out;\n }, [unitsBySku, skuInfo]);\n\n const totUnits = rows.reduce((s, r) => s + r.units, 0);\n const totSpend = rows.reduce((s, r) => s + (r.p.logi ?? 0) * r.units, 0);\n const avgCost = totUnits > 0 ? totSpend / totUnits : null; // true weighted avg per shipped unit\n const nDpd = rows.filter((r) => r.p.carrier === \"DPD\").length;\n const nCcv = rows.filter((r) => r.p.carrier === \"CCV\").length;\n\n // Shipping stats from orders feed (if configured)\n const shipStats = useMemo(() => {\n const lines = orders?.lines;\n if (!Array.isArray(lines) || lines.length === 0) return null;\n const skuBrand: Record = {};\n for (const p of products) skuBrand[String(p.code)] = p.brand;\n const orderMap: Record = {};\n for (const l of lines) {\n if (l.d < from || l.d > to) continue;\n if (brand && l.b !== brand) continue;\n if (grp) {\n const p = products.find((x) => String(x.code) === l.sku);\n if (!p || p.grp !== grp) continue;\n }\n const e = orderMap[l.o] ?? { d: l.d, f: null, ful: false };\n if ((l.k ?? \"ord\") === \"ful\") { e.ful = true; if (l.f && !e.f) e.f = l.f; }\n orderMap[l.o] = e;\n }\n const os = Object.values(orderMap);\n if (os.length === 0) return null;\n const shipped = os.filter((o) => o.ful);\n const inProgress = os.length - shipped.length;\n const days = shipped.filter((o) => o.f && o.d)\n .map((o) => (new Date(o.f!).getTime() - new Date(o.d).getTime()) / 864e5)\n .filter((d) => d >= 0 && d < 60);\n const avgDays = days.length ? days.reduce((s, d) => s + d, 0) / days.length : null;\n return { total: os.length, shipped: shipped.length, inProgress, avgDays };\n }, [orders, products, brand, grp, from, to]);\n\n return (\n

\n \n

\n From\n setFrom(e.target.value)}\n className=\"px-2 py-1.5 border rounded-lg text-sm\" disabled={!hasOrders} />\n to\n setTo(e.target.value)}\n className=\"px-2 py-1.5 border rounded-lg text-sm\" disabled={!hasOrders} />\n {!hasOrders && (\n Date filter needs the Orders exports — using Sales YTD for now.\n )}\n

\n \n\n

\n \n \n \n \n \n

\n\n {shipStats ? (\n

\n \n \n \n

\n ) : orders === null ? (\n \n

\n Configure the Matrixify Orders exports (see the Business tab) to see orders in progress,\n shipped orders and average days to ship (order date → fulfilment date).\n

\n \n ) : null}\n\n \n

\n \n \n \n \n \n \n \n \n \n \n \n \n {rows.slice(0, 300).map(({ p, units }) => (\n \n \n \n \n \n \n \n \n \n \n ))}\n \n

SKU	Product	Category	Weight (kg)	Carrier	Unit cost	Units {hasOrders ? \"(period)\" : \"(YTD)\"}	Spend
{p.code}	{p.name}	{p.cat ?? \"—\"}	{p.wt != null ? p.wt.toFixed(1) : \"—\"}	\n \n {p.carrier}\n \n	{fmtEur(p.logi)}	{fmtInt(units)}	{fmtEurK((p.logi ?? 0) * units)}

\n \n

\n );\n}\n\n// ═══════════════════════════ BUSINESS ═══════════════════════════════════════\nfunction BusinessTab({ products }: { products: Product[] }) {\n const [data, setData] = useState(undefined);\n const [from, setFrom] = useState(() => new Date(Date.now() - 30 * 864e5).toISOString().slice(0, 10));\n const [to, setTo] = useState(() => new Date().toISOString().slice(0, 10));\n const [chans, setChans] = useState>(new Set()); // empty = all channels\n const [brand, setBrand] = useState(null);\n const [grp, setGrp] = useState(null);\n const [basis, setBasis] = useState<\"ful\" | \"ord\">(\"ful\"); // shipped vs ordered\n\n const toggleChan = (c: string) => {\n const s = new Set(chans);\n s.has(c) ? s.delete(c) : s.add(c);\n setChans(s);\n };\n\n useEffect(() => {\n fetch(\"/api/business\").then((r) => r.ok ? r.json() : null)\n .then(setData).catch(() => setData(null));\n }, []);\n\n const skuInfo = useMemo(() => {\n const m: Record = {};\n for (const p of products) m[String(p.code)] = p;\n return m;\n }, [products]);\n\n if (data === undefined) return

Loading business data…

;\n\n if (data === null || !Array.isArray(data.lines)) {\n return (\n \n

To activate this tab, create 3 scheduled Matrixify exports (Orders) — one per store — with:

Format: Matrixify: CSV, not zipped, repeat every 1 day
Custom file names: Export_Hoover_Orders, Export_Haier_Orders, Export_Candy_Orders (no date placeholder)
Columns: Name, Created At, Fulfilled At, Financial Status, Fulfillment Status, Source Name, Line: SKU, Line: Quantity, Line: Price
Date filter: last 12 months (rolling) to keep files light

The dashboard checks the same stable URLs pattern as the product exports — data appears after the first daily sync (or ask Claude to trigger it).

\n \n );\n }\n\n const lines: any[] = data.lines;\n\n // Channel from marketplace tags. Tags hold: marketplace order no. + integrator (lengow)\n // + marketplace identifier. Klarna is a payment method → DtoC. No marketplace tag → DtoC.\n const chanOf = (l: any) => {\n const t = (l.t ?? \"\").toLowerCase();\n if (t.includes(\"but_mirakl\")) return \"BUT\";\n if (t.includes(\"cdiscount_octopia\")) return \"Cdiscount\";\n if (t.includes(\"boulanger\")) return \"Boulanger\";\n if (t.includes(\"showroomprive\")) return \"Showroomprive\";\n return \"DtoC\";\n };\n const CHANNELS = [\"DtoC\", \"BUT\", \"Cdiscount\", \"Boulanger\", \"Showroomprive\"];\n\n // Filtering (chans empty = all channels). basis: \"ful\" = shipped lines, \"ord\" = ordered lines\n const fLines = lines.filter((l) => {\n if ((l.k ?? \"ord\") !== basis) return false;\n if (l.d < from || l.d > to) return false;\n if (chans.size > 0 && !chans.has(chanOf(l))) return false;\n if (brand && l.b !== brand) return false;\n if (grp) {\n const p = skuInfo[l.sku ?? \"\"];\n if (!p || p.grp !== grp) return false;\n }\n return true;\n });\n\n // KPIs — Shopify prices are VAT-inclusive; Business figures are shown excl. VAT\n const VAT_RATE = 1.2;\n const ca = fLines.reduce((s, l) => s + l.p * l.q, 0) / VAT_RATE;\n const units = fLines.reduce((s, l) => s + l.q, 0);\n const orderIds = new Set(fLines.map((l) => l.o));\n const nOrders = orderIds.size;\n const aov = nOrders > 0 ? ca / nOrders : null;\n // Margin estimate from catalog costs (lines with known SKU)\n let mSum = 0, mBase = 0;\n for (const l of fLines) {\n const p = skuInfo[l.sku ?? \"\"];\n if (p?.cost && l.p > 0) {\n const ht = l.p / 1.2;\n mSum += (ht - p.cost - (p.deee ?? 0)) * l.q;\n mBase += ht * l.q;\n }\n }\n const margin = mBase > 0 ? mSum / mBase : null;\n\n // Refunded orders (period)\n const refunded = new Set(fLines.filter((l) => l.rf).map((l) => l.o)).size;\n\n // By channel\n const byChannel: Record; units: number }> = {};\n for (const l of fLines) {\n const src = chanOf(l);\n const c = byChannel[src] ?? { ca: 0, orders: new Set(), units: 0 };\n c.ca += (l.p * l.q) / VAT_RATE; c.orders.add(l.o); c.units += l.q;\n byChannel[src] = c;\n }\n\n // Daily revenue\n const byDate: Record = {};\n for (const l of fLines) byDate[l.d] = (byDate[l.d] ?? 0) + (l.p * l.q) / VAT_RATE;\n const dailySeries = Object.entries(byDate).sort((a, b) => a[0] < b[0] ? -1 : 1);\n const maxDay = Math.max(...dailySeries.map(([, v]) => v), 1);\n\n return (\n

\n \n

\n From\n setFrom(e.target.value)} className=\"px-2 py-1.5 border rounded-lg text-sm\" />\n to\n setTo(e.target.value)} className=\"px-2 py-1.5 border rounded-lg text-sm\" />\n \n Orders data updated {data.updated_at ? new Date(data.updated_at).toLocaleString(\"fr-FR\") : \"?\"}\n \n

\n Basis:\n setBasis(\"ful\")}>📤 Shipped (fulfilled)\n setBasis(\"ord\")}>🛒 Ordered\n \n {basis === \"ful\" ? \"comparable to invoiced revenue\" : \"gross intake, incl. not-yet-shipped\"}\n \n

\n Channels (multi):\n setChans(new Set())}>All\n {CHANNELS.map((c) => (\n toggleChan(c)}>\n {c === \"DtoC\" ? \"🌐 DtoC\" : \"🏪 \" + c}\n \n ))}\n

\n \n\n

\n \n \n \n \n \n \n

\n\n {dailySeries.length > 1 && (\n \n

\n {dailySeries.map(([d, v]) => (\n

\n ))}\n

\n {dailySeries[0][0]}{dailySeries[dailySeries.length - 1][0]}\n

\n \n )}\n\n \n \n \n \n \n \n \n \n {Object.entries(byChannel).sort((a, b) => b[1].ca - a[1].ca).map(([src, c]) => (\n \n \n \n \n \n \n \n \n ))}\n \n

Channel	Revenue	Share	Orders	Units	AOV
{src === \"DtoC\" ? \"🌐 DtoC (sites)\" : \"🏪 \" + src}	{fmtEurK(c.ca)}	{fmtPct(ca > 0 ? c.ca / ca : null)}	{fmtInt(c.orders.size)}	{fmtInt(c.units)}	{fmtEur(c.orders.size > 0 ? c.ca / c.orders.size : null)}

\n Channels from order tags: but_mirakl → BUT, cdiscount_octopia → Cdiscount, boulanger → Boulanger,\n showroomprive_fr → Showroomprive. Everything else (incl. Klarna payments) = DtoC.\n

\n \n

\n );\n}\n\n// ═══════════════════════════ SHARED WIDGETS ═════════════════════════════════\nfunction Card({ title, children, className = \"\", right }: any) {\n return (\n

\n {title && (\n

{title}

\n {right}\n

\n )}\n

{children}

\n );\n}\n\n/** KPI tile: monochrome icon in a soft tinted circle, value, label. */\nfunction Kpi({ label, value, icon, Icon, accent = false, tone = \"indigo\" }: any) {\n const tones: Record = {\n indigo: [\"#EEF2FF\", \"#4F46E5\"], green: [\"#ECFDF5\", \"#059669\"],\n amber: [\"#FFFBEB\", \"#D97706\"], sky: [\"#F0F9FF\", \"#0284C7\"],\n rose: [\"#FFF1F2\", \"#E11D48\"], slate: [\"#F1F5F9\", \"#475569\"],\n };\n const [bg, fg] = tones[accent ? \"amber\" : tone] ?? tones.indigo;\n return (\n

\n {Icon ? : {icon}}\n

{value}

{label}

\n );\n}\n\nfunction Pill({ active, onClick, children }: any) {\n return (\n \n );\n}\n\nfunction BrandBadge({ brand }: { brand: string }) {\n return (\n \n {brand}\n \n );\n}\n\nfunction BrandDot({ brand }: { brand: string }) {\n const c = brand === \"CANDY\" ? \"bg-sky-500\" : brand === \"HOOVER\" ? \"bg-red-500\" : \"bg-blue-900\";\n return ;\n}\n\n/** Product thumbnail (from Shopify \"Image Src\" column) with brand-dot fallback. */\nfunction Thumb({ p }: { p: Product }) {\n if (p.img) {\n return (\n $\"\"$ { e.target.style.display = \"none\"; }} />\n );\n }\n return ;\n}\n\nfunction SiteBadge({ ss }: { ss: string }) {\n const cls = ss === \"Active\" ? \"bg-green-100 text-green-700\" :\n ss === \"Inactive\" ? \"bg-orange-100 text-orange-700\" : \"bg-red-100 text-red-700\";\n return {ss};\n}\n\nfunction StBadge({ st }: { st: number | null | undefined }) {\n if (st == null || !isFinite(st)) return —;\n const cls = st >= 1.1 ? \"text-purple-700 font-bold\" : st >= 0.7 ? \"text-green-700\" : \"text-orange-600\";\n return {fmtPct(st)};\n}\n\nfunction PosBadge({ pos }: { pos?: string | null }) {\n if (!pos) return —;\n const map: Record = {\n competitive: [\"🟢 Competitive\", \"text-green-700\"],\n average: [\"🟡 Average\", \"text-amber-700\"],\n above: [\"🔴 Above market\", \"text-red-700\"],\n };\n const [label, cls] = map[pos] ?? [pos, \"\"];\n return {label};\n}\n\nfunction PriceCell({ p }: { p: Product }) {\n const price = p.price;\n if (price == null || price === 0) return —;\n let cls = \"\";\n let title = \"\";\n if (p.be != null && price < p.be) { cls = \"bg-red-100 text-red-800 px-1 rounded\"; title = `Below breakeven (${fmtEur(p.be)})`; }\n else if (p.mip != null && price < p.mip) { cls = \"bg-orange-100 text-orange-800 px-1 rounded\"; title = `Below min internal price (${fmtEur(p.mip)})`; }\n return {fmtEur(price)};\n}\n\nfunction GapCell({ p }: { p: Product }) {\n if (p.gap == null) return —;\n const cls = p.gap <= -0.01 ? \"text-green-700\" : p.gap <= 0.05 ? \"text-amber-700\" : \"text-red-700 font-bold\";\n return {fmtPct(p.gap)};\n}\n",[],[191,267],["D",1785139819731],[207,208,209,210,211],[191],["D",1785139688485],["D",1789561879908],{"_100":99,"_108":104},{"_100":99,"_101":102,"_103":104,"_18":55,"_105":106,"_107":25},{"_13":89,"_32":90,"_43":42,"_91":44,"_92":-5,"_93":-5,"_94":-5,"_95":-5,"_96":-5,"_97":45,"_98":99},"ctx",{"_82":-5,"_128":316,"_317":318,"_319":320,"_321":25,"_322":25,"_323":25,"_324":59,"_325":-5,"_326":-7,"_327":-7,"_328":63,"_329":25,"_330":25,"_331":-5,"_332":25,"_333":25,"_334":25,"_335":-5},"ENV",{"_287":288,"_289":290,"_291":90,"_292":293,"_294":295,"_296":297,"_298":299,"_300":301,"_302":303,"_304":305,"_306":307,"_308":309,"_310":311,"_312":313,"_314":315},"REACT_APP_SENTRY_DSN","https://586020d86f05489db63a554690acf1e9@o1398359.ingest.sentry.io/6724499","RENDER_GIT_COMMIT","e87eb04e707cf64e7e532c8e8ec395f209e17f15","RENDER_GIT_BRANCH","POSTHOG_API_TOKEN","phc_nmoyuAkStEZuUp69rYlg1DZgrIt19Gx0Y4Hwf8tGgJP","POSTHOG_API_HOST","https://wart.val.town","WEB_API_TEMPLATE","https://{val}.web.val.run","APP_URL","https://www.val.town","MODULE_URL","https://esm.town","VANITY_WEB_API_TEMPLATE","https://{label}.val.run/","DENOLS_URL","https://lsp.val.town","NODE_ENV","production","CLOUDFLARE_TURNSTILE_SITE_KEY","0x4AAAAAACtaIZJH7s9rBMZ6","GOOGLE_CLIENT_ID","875989696899-jtsqkhlbdv5jrlsk8631p7ipjg3c6o62.apps.googleusercontent.com","STRIPE_PUBLISHABLE_KEY","pk_live_51N2zvWEpZTTLipIkVEwXrUG9AT0yeOOEYxszarZT1jpsZV58Ly6wlg3SltZpHN26CUalOBmUSY7adQRQiSkCZz2500qSXNkf8Y","API_URL","https://api.val.town",[],"preferencesKeybindings","default","preferencesTheme","light","preferencesFixers","preferencesCopilot","preferencesSelectionAi","preferencesCloseBrackets","preferencesChatPanelState","preferencesDprint","preferencesDenofmt","notificationCount","flagDenols","isBusinessOrgMember","businessOrgHandle","isBusinessOrgAdmin","isHigherTownieTier","navCollapsed","currentOrgId"]

Diff · v152