[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8,"_9":10},"actionData","errors","root",{"_153":154,"_155":156},"routes/_app.x.$handle.$name",{"_95":94,"_32":45,"_103":85,"_27":104,"_13":14,"_105":-5,"_11":106,"_107":108,"_109":110,"_111":112,"_113":114,"_20":-5,"_115":-5,"_116":-5,"_117":25,"_118":119,"_120":58,"_121":-5,"_122":-5,"_123":124},"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":31,"_57":58,"_59":-5,"_60":-5,"_61":62,"_63":64,"_65":-5,"_66":-5,"_67":-5,"_68":-5,"_69":70,"_71":70,"_72":73,"_74":73,"_75":73,"_76":70,"_77":70,"_78":79,"_80":81,"_82":83,"_84":25},"version",3,"changes",[19],"aiChatInfo","userId",{"_20":21,"_22":23,"_24":25,"_26":25,"_27":28,"_29":28},"file",{"_30":31,"_32":28,"_33":37,"_35":36,"_38":39,"_40":14,"_41":42,"_24":25},"previous",{"_30":31,"_32":28,"_33":34,"_35":36},"deleted",false,"deletedHere","path","main.ts","latestPath","fileId","bddffb76-a557-11f1-a318-1607ee4eb77e","name","fileType","script","content","/**\n * FIGGY FULFILLMENT - Val Town HTTP handler\n *\n * Reports the OPEN unfulfilled backlog with shape, not just a count:\n * aging buckets, dollar exposure, oldest orders, and same-day clusters.\n *\n * Env vars required:\n * SHOPIFY_STORE e.g. shenanigan-kids.myshopify.com\n * SHOPIFY_TOKEN Admin API token (read_orders)\n * FULFIL_KEY access key for this page\n *\n * Access: https://.web.val.run/?key=FULFIL_KEY\n * add &format=json for raw data\n *\n * Why this exists: the ops dashboard counted unfulfilled orders without\n * excluding cancelled/closed ones, so oldestUnfulfilledDays reported 162\n * days from an archived March order instead of the real open backlog.\n * This filters status:open at the query level so that cannot recur.\n */\n\nconst API_VERSION = \"2025-07\";\nconst PAGE_SIZE = 250;\nconst MAX_PAGES = 6;\n\ninterface Order {\n name: string;\n createdAt: string;\n totalAmount: number;\n financial: string;\n titles: string[];\n ageDays: number;\n}\n\nconst QUERY = `\nquery Backlog($cursor: String) {\n orders(first: ${PAGE_SIZE}, after: $cursor,\n query: \"fulfillment_status:unfulfilled AND status:open\",\n sortKey: CREATED_AT) {\n pageInfo { hasNextPage endCursor }\n edges {\n node {\n name\n createdAt\n displayFinancialStatus\n currentTotalPriceSet { shopMoney { amount } }\n lineItems(first: 10) { edges { node { title } } }\n }\n }\n }\n}`;\n\nasync function shopify(store: string, token: string, cursor: string | null) {\n const res = await fetch(\n `https://${store}/admin/api/${API_VERSION}/graphql.json`,\n {\n method: \"POST\",\n headers: {\n \"Content-Type\": \"application/json\",\n \"X-Shopify-Access-Token\": token,\n },\n body: JSON.stringify({ query: QUERY, variables: { cursor } }),\n },\n );\n if (!res.ok) throw new Error(`Shopify HTTP ${res.status}`);\n const json = await res.json();\n if (json.errors) {\n throw new Error(\n `Shopify GraphQL: ${JSON.stringify(json.errors).slice(0, 300)}`,\n );\n }\n return json.data.orders;\n}\n\nfunction daysBetween(iso: string, now: Date): number {\n const then = new Date(iso);\n return Math.floor((now.getTime() - then.getTime()) / 86400000);\n}\n\nasync function collect(store: string, token: string, now: Date) {\n const out: Order[] = [];\n let cursor: string | null = null;\n let pages = 0;\n let truncated = false;\n\n while (pages < MAX_PAGES) {\n const page = await shopify(store, token, cursor);\n for (const e of page.edges) {\n const n = e.node;\n out.push({\n name: n.name,\n createdAt: n.createdAt,\n totalAmount: Number(n.currentTotalPriceSet?.shopMoney?.amount ?? 0),\n financial: n.displayFinancialStatus ?? \"\",\n titles: (n.lineItems?.edges ?? []).map((x: any) => x.node.title),\n ageDays: daysBetween(n.createdAt, now),\n });\n }\n pages += 1;\n if (!page.pageInfo.hasNextPage) {\n cursor = null;\n break;\n }\n cursor = page.pageInfo.endCursor;\n }\n if (cursor) truncated = true;\n return { orders: out, truncated };\n}\n\nconst BUCKETS: [string, (d: number) => boolean][] = [\n [\"14+ days\", (d) => d >= 14],\n [\"7-13 days\", (d) => d >= 7 && d < 14],\n [\"4-6 days\", (d) => d >= 4 && d < 7],\n [\"2-3 days\", (d) => d >= 2 && d < 4],\n [\"0-1 days\", (d) => d < 2],\n];\n\nfunction analyse(orders: Order[]) {\n const buckets = BUCKETS.map(([label, test]) => {\n const hits = orders.filter((o) => test(o.ageDays));\n return {\n label,\n orders: hits.length,\n value: Number(hits.reduce((s, o) => s + o.totalAmount, 0).toFixed(2)),\n };\n });\n\n // Same-day clusters: 5+ orders created on one date and still unshipped.\n const byDate = new Map();\n for (const o of orders) {\n const d = o.createdAt.slice(0, 10);\n byDate.set(d, [...(byDate.get(d) ?? []), o]);\n }\n const clusters = [...byDate.entries()]\n .filter(([, v]) => v.length >= 5)\n .map(([date, v]) => ({\n date,\n orders: v.length,\n value: Number(v.reduce((s, o) => s + o.totalAmount, 0).toFixed(2)),\n }))\n .sort((a, b) => a.date.localeCompare(b.date));\n\n const paid = orders.filter((o) => o.totalAmount > 0);\n const zeroValue = orders.filter((o) => o.totalAmount === 0);\n\n // Backlog shape: healthy queues are fat at the young end.\n const old = orders.filter((o) => o.ageDays >= 7).length;\n const fresh = orders.filter((o) => o.ageDays < 2).length;\n const inverted = old > fresh * 2 && old >= 5;\n\n return {\n total: orders.length,\n totalValue: Number(\n orders.reduce((s, o) => s + o.totalAmount, 0).toFixed(2),\n ),\n revenueBearing: paid.length,\n zeroValue: zeroValue.length,\n oldestDays: orders.length ? Math.max(...orders.map((o) => o.ageDays)) : 0,\n buckets,\n clusters,\n inverted,\n oldest: [...orders]\n .sort((a, b) => b.ageDays - a.ageDays)\n .slice(0, 15)\n .map((o) => ({\n name: o.name,\n ageDays: o.ageDays,\n value: o.totalAmount,\n items: o.titles.slice(0, 3),\n })),\n };\n}\n\nfunction esc(s: string) {\n return String(s).replace(\n /[&<>\"]/g,\n (c) => ({ \"&\": \"&\", \"<\": \"<\", \">\": \">\", '\"': \""\" }[c]!),\n );\n}\n\nfunction render(\n a: ReturnType,\n store: string,\n generatedAt: string,\n truncated: boolean,\n) {\n const admin = `https://${\n store.replace(\".myshopify.com\", \"\")\n }.myshopify.com/admin`;\n const money = (n: number) =>\n \"$\" +\n n.toLocaleString(\"en-US\", {\n minimumFractionDigits: 2,\n maximumFractionDigits: 2,\n });\n\n return `\n\nFiggy Fulfillment Backlog\n

Fulfillment backlog

Open, unfulfilled orders only · cancelled and closed excluded · generated ${\n esc(generatedAt)\n }

\n\n

${a.total} orders · ${money(a.totalValue)}

\n Oldest ${a.oldestDays} days · ${a.revenueBearing} revenue-bearing · ${a.zeroValue} at $0\n

\n\n${\n a.inverted\n ? `

Backlog shape is inverted.\n More orders are older than a week than were placed in the last two days. A queue that is\n being worked normally is fat at the young end; this one is not.

`\n : \"\"\n }\n\n${\n a.clusters.length\n ? `

Same-day clusters.\n ${\n a.clusters.map((c) =>\n `${c.orders} orders from ${c.date} (${money(c.value)})`\n ).join(\"; \")\n }.\n A single date going untouched usually means a stockout or a skipped batch rather than slow shipping.

`\n : \"\"\n }\n\n

\n\n${\n a.buckets.map((b) =>\n ``\n ).join(\"\")\n }\n

Age	Orders	Value
${b.label}	${b.orders}	${\n money(b.value)\n }

\n\n

\n\n${\n a.oldest.map((o) =>\n `\n \n \n \n `\n ).join(\"\")\n }\n

Oldest orders	Age	Value	Items
${esc(o.name)}	= 7 ? \" old\" : \"\"}\">${o.ageDays}d	${money(o.value)}	${esc(o.items.join(\", \")).slice(0, 70)}

\n\n${\n truncated\n ? `

Result truncated at ${\n MAX_PAGES * PAGE_SIZE\n } orders.

`\n : \"\"\n }\n

`;\n}\n\nexport default async function (req: Request): Promise {\n const url = new URL(req.url);\n const store = Deno.env.get(\"SHOPIFY_STORE\");\n const token = Deno.env.get(\"SHOPIFY_TOKEN\");\n const key = Deno.env.get(\"FULFIL_KEY\");\n\n if (!store || !token) {\n return new Response(\"Missing SHOPIFY_STORE or SHOPIFY_TOKEN env var\", {\n status: 500,\n });\n }\n if (key && url.searchParams.get(\"key\") !== key) {\n return new Response(\"Not found\", { status: 404 });\n }\n\n const now = new Date();\n try {\n const { orders, truncated } = await collect(store, token, now);\n const a = analyse(orders);\n const generatedAt = now.toISOString();\n\n if (url.searchParams.get(\"format\") === \"json\") {\n return new Response(\n JSON.stringify({ generatedAt, store, truncated, ...a }, null, 2),\n {\n headers: { \"Content-Type\": \"application/json; charset=utf-8\" },\n },\n );\n }\n return new Response(render(a, store, generatedAt, truncated), {\n headers: { \"Content-Type\": \"text/html; charset=utf-8\" },\n });\n } catch (err) {\n return new Response(\n `Error: ${err instanceof Error ? err.message : String(err)}`,\n { status: 500 },\n );\n }\n}","http","createdAt",["D",1788193589181],"branchVersion","branchId","2f3ffa77-7058-4406-b385-a38397b59333","id","343da833-a6a5-4ff5-86c7-027971eb06d2","figgy-fulfillment",["D",1788193169104],"deletedAt","legacyEnvVars","privacy","public","httpPrivacy","description","Open unfulfilled backlog: aging, exposure, clusters","imageUrl","019c9634-cf0e-7564-a473-6d7ef6471105","pinnedFileId","pinPreview",true,"pinMigrated","screenshotVersion","likeCount",0,"orgId","019c9634-cf0e-7564-a473-73e1670c6fa4","tursoName","tursoHostname","tursoMeasuredAt","pinned","userPerm","r","valPerm","blobPerm","rw","emailPerm","sqlitePerm","projectPerm","telemetryPerm","user",{"_95":94,"_102":98},"org",{"_95":94,"_96":-5,"_97":98,"_18":55,"_99":100,"_101":25},"branch",{"_13":14,"_32":85,"_43":42,"_86":44,"_87":-5,"_88":-5,"_89":-5,"_90":-5,"_91":-5,"_92":45,"_93":94},"isOwned","main","projectId","forkedBranchId","forkedBranchVersion","forkedProjectPrivacy","forkedProjectId","forkedProjectOrgId","projectName","userHandle","rneill2000","handle","displayName","avatar","https://img.clerk.com/eyJ0eXBlIjoicHJveHkiLCJzcmMiOiJodHRwczovL2ltYWdlcy5jbGVyay5kZXYvb2F1dGhfZ2l0aHViL2ltZ18zQUFzN09QNXRSaXdFZkdubUFOS3F2VGg0bkgifQ","tier","free","canRestrictVals","profileImageUrl","branchName","","adoptOrgId",{"_43":44,"_32":45,"_38":149,"_47":-5,"_48":25,"_49":50,"_51":50,"_52":53,"_54":-5,"_18":55,"_56":31,"_57":58,"_59":-5,"_60":-5,"_61":62,"_63":64,"_65":-5,"_66":-5,"_67":-5,"_68":-5,"_69":70,"_71":70,"_72":73,"_74":73,"_75":73,"_76":70,"_77":70,"_78":150,"_80":151,"_82":152,"_84":25},"tree",[144],"files",[144],"counts",{"_133":62,"_134":135,"_136":62,"_137":138,"_139":140},"contents",[125],"upstreamProject","upstreamBranch","emptyEnvVars","flags",[],"hasHttpFiles","grants","orgs","customDomains",{},{"_43":126,"_32":28,"_30":31,"_127":-5,"_41":42,"_40":14,"_128":58,"_38":129,"_13":130,"_33":37,"_35":36,"_24":25,"_131":-5,"_27":132},"fcbea563-7969-4533-a06d-37eacb6d6f1d","parentId","latest",["D",1788193589181],2,"label",[28],"pulls","branches",1,"forks","envVars",{"_141":135,"_143":62},"connections",{"_141":62,"_142":62},"count","unfilledCount","emptyCount",{"_43":126,"_32":28,"_30":31,"_127":-5,"_41":42,"_40":14,"_128":58,"_38":145,"_13":130,"_33":37,"_35":36,"_24":25,"_131":-5,"_146":147,"_27":148},["D",1788193589181],"children",[],[28],["D",1788193169104],{"_95":94,"_102":98},{"_95":94,"_96":-5,"_97":98,"_18":55,"_99":100,"_101":25},{"_13":14,"_32":85,"_43":42,"_86":44,"_87":-5,"_88":-5,"_89":-5,"_90":-5,"_91":-5,"_92":45,"_93":94},"ctx",{"_78":-5,"_122":186,"_187":188,"_189":190,"_191":25,"_192":25,"_193":25,"_194":58,"_195":-5,"_196":-7,"_197":-7,"_198":62,"_199":25,"_200":25,"_201":-5,"_202":25,"_203":25,"_204":25,"_205":-5},"ENV",{"_157":158,"_159":160,"_161":85,"_162":163,"_164":165,"_166":167,"_168":169,"_170":171,"_172":173,"_174":175,"_176":177,"_178":179,"_180":181,"_182":183,"_184":185},"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 · v3