[{"_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",{"_11":12,"_13":14,"_15":16,"_18":19,"_17":-7,"_116":-5,"_20":117,"_22":118,"_119":120,"_121":122,"_25":123,"_24":-5,"_124":-5,"_125":-5,"_126":53,"_127":128,"_129":44,"_130":-5,"_131":-5,"_132":133},"routes/_app.x.$handle.$name.branch.$branch.code.$",{"_11":12,"_13":14,"_15":16,"_17":-7,"_18":19,"_20":21,"_22":23,"_24":-7,"_25":26,"_27":-5,"_28":-5,"_29":-5,"_30":-5,"_31":-5},"handle","rneill2000","name","figgy-fulfillment","branchName","main","version","path","","project",{"_33":61,"_13":14,"_45":62,"_63":-5,"_64":53,"_65":66,"_67":66,"_68":69,"_70":-5,"_71":72,"_73":37,"_74":44,"_75":-5,"_76":-5,"_77":78,"_79":80,"_81":-5,"_82":-5,"_83":-5,"_84":-5,"_85":86,"_87":86,"_88":89,"_90":89,"_91":89,"_92":86,"_93":86,"_94":95,"_96":97,"_98":99,"_100":53},"tree",[56],"file","contents",[32],"upstream","pull","ahead","behind","envVars",{"_33":34,"_13":35,"_36":37,"_38":-5,"_39":40,"_41":42,"_43":44,"_45":46,"_17":47,"_48":49,"_50":51,"_52":53,"_54":-5,"_18":55},"id","fcbea563-7969-4533-a06d-37eacb6d6f1d","main.ts","fileId","bddffb76-a557-11f1-a318-1607ee4eb77e","parentId","branchId","2f3ffa77-7058-4406-b385-a38397b59333","branchVersion",3,"latest",true,"createdAt",["D",1788193589181],2,"fileType","http","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}","deleted",false,"label",[35],{"_33":34,"_13":35,"_36":37,"_38":-5,"_39":40,"_41":42,"_43":44,"_45":57,"_17":47,"_48":49,"_50":51,"_52":53,"_54":-5,"_58":59,"_18":60},["D",1788193589181],"children",[],[35],"343da833-a6a5-4ff5-86c7-027971eb06d2",["D",1788193169104],"deletedAt","legacyEnvVars","privacy","public","httpPrivacy","description","Open unfulfilled backlog: aging, exposure, clusters","imageUrl","userId","019c9634-cf0e-7564-a473-6d7ef6471105","pinnedFileId","pinPreview","pinMigrated","screenshotVersion","likeCount",0,"orgId","019c9634-cf0e-7564-a473-73e1670c6fa4","tursoName","tursoHostname","tursoMeasuredAt","pinned","userPerm","r","valPerm","blobPerm","rw","emailPerm","sqlitePerm","projectPerm","telemetryPerm","user",{"_11":12,"_115":111},"org",{"_11":12,"_109":-5,"_110":111,"_71":72,"_112":113,"_114":53},"branch",{"_17":42,"_13":16,"_33":40,"_101":61,"_102":-5,"_103":-5,"_104":-5,"_105":-5,"_106":-5,"_107":14,"_108":12},"isOwned","projectId","forkedBranchId","forkedBranchVersion","forkedProjectPrivacy","forkedProjectId","forkedProjectOrgId","projectName","userHandle","displayName","avatar","https://img.clerk.com/eyJ0eXBlIjoicHJveHkiLCJzcmMiOiJodHRwczovL2ltYWdlcy5jbGVyay5kZXYvb2F1dGhfZ2l0aHViL2ltZ18zQUFzN09QNXRSaXdFZkdubUFOS3F2VGg0bkgifQ","tier","free","canRestrictVals","profileImageUrl","adoptOrgId",{"_33":61,"_13":14,"_45":149,"_63":-5,"_64":53,"_65":66,"_67":66,"_68":69,"_70":-5,"_71":72,"_73":37,"_74":44,"_75":-5,"_76":-5,"_77":78,"_79":80,"_81":-5,"_82":-5,"_83":-5,"_84":-5,"_85":86,"_87":86,"_88":89,"_90":89,"_91":89,"_92":86,"_93":86,"_94":150,"_96":151,"_98":152,"_100":53},[146],"files",[146],"counts",{"_136":78,"_137":138,"_139":78,"_31":140,"_141":142},[134],"upstreamProject","upstreamBranch","emptyEnvVars","flags",[],"hasHttpFiles","grants","orgs","customDomains",{},{"_33":34,"_13":35,"_36":37,"_38":-5,"_39":40,"_41":42,"_43":44,"_45":46,"_17":47,"_48":49,"_50":51,"_52":53,"_54":-5,"_18":135},[35],"pulls","branches",1,"forks",{"_143":138,"_145":78},"connections",{"_143":78,"_144":78},"count","unfilledCount","emptyCount",{"_33":34,"_13":35,"_36":37,"_38":-5,"_39":40,"_41":42,"_43":44,"_45":57,"_17":47,"_48":49,"_50":51,"_52":53,"_54":-5,"_58":147,"_18":148},[],[35],["D",1788193169104],{"_11":12,"_115":111},{"_11":12,"_109":-5,"_110":111,"_71":72,"_112":113,"_114":53},{"_17":42,"_13":16,"_33":40,"_101":61,"_102":-5,"_103":-5,"_104":-5,"_105":-5,"_106":-5,"_107":14,"_108":12},"ctx",{"_94":-5,"_131":186,"_187":188,"_189":190,"_191":53,"_192":53,"_193":53,"_194":44,"_195":-5,"_196":-7,"_197":-7,"_198":78,"_199":53,"_200":53,"_201":-5,"_202":53,"_203":53,"_204":53,"_205":-5},"ENV",{"_157":158,"_159":160,"_161":16,"_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"]

Code