Mavi Jeans Order Parser

\n Demo\n

\n\n

\n Konu (Subject)\n \n

\n Gönderen (From)\n \n

\n Email İçeriği (Body)\n \n

\n \n \n

\n\n

Parsed Summary

\n\n

\n \n \n \n

\n\n

Extraction Notes

\n\n Show raw JSON\n

\n\n\n\n`;\n\n return new Response(html, {\n headers: { \"Content-Type\": \"text/html; charset=utf-8\" },\n });\n}\n","label",[75],"56a4cc9c-4969-11f1-8f7e-42b51c65c3df",["D",1778085219899],"import Anthropic from \"npm:@anthropic-ai/sdk@0.39.0\";\n\n// ── Channel → SAP code mappings ──────────────────────────────────────\nconst CHANNEL_MAP: Record = {\n TR_ECOM: { uretim_yeri: \"8004\", depo_yeri: \"1450\", depo_yeri_2: \"1450\" },\n TR_PERAKENDE: { uretim_yeri: \"8000\", depo_yeri: \"9999\", depo_yeri_2: \"1020\" },\n TR_TOPTAN: { uretim_yeri: \"8000\", depo_yeri: \"9999\", depo_yeri_2: \"1010\" },\n};\n\n// ── Standard size distribution ───────────────────────────────────────\nconst STANDARD_SIZES: { size: string; pct: number }[] = [\n { size: \"XS\", pct: 3.6 },\n { size: \"S\", pct: 8.8 },\n { size: \"M\", pct: 26.4 },\n { size: \"L\", pct: 30.4 },\n { size: \"XL\", pct: 18.4 },\n { size: \"XXL\", pct: 7.8 },\n { size: \"XXXL\", pct: 4.6 },\n];\n\n// ── Distribute total across standard sizes, rounding to integers ─────\nfunction distributeStandard(total: number): { size: string; qty: number }[] {\n const raw = STANDARD_SIZES.map(s => ({ size: s.size, exact: total * s.pct / 100 }));\n const floored = raw.map(r => ({ size: r.size, qty: Math.floor(r.exact), remainder: r.exact - Math.floor(r.exact) }));\n let assigned = floored.reduce((sum, r) => sum + r.qty, 0);\n let diff = total - assigned;\n // assign remaining units to sizes with largest remainders\n const sorted = [...floored].sort((a, b) => b.remainder - a.remainder);\n for (let i = 0; i < diff && i < sorted.length; i++) {\n sorted[i].qty += 1;\n }\n return floored.map(r => ({ size: r.size, qty: r.qty }));\n}\n\n// ── Claude extraction prompt ─────────────────────────────────────────\nconst SYSTEM_PROMPT = `You are an order-parsing assistant for Mavi Jeans. You receive Turkish-language emails about orders and extract structured data.\n\nReturn ONLY valid JSON (no markdown, no explanation) with this exact shape:\n{\n \"type\": \"new_order\" | \"quantity_revision\" | \"price_revision\",\n \"model_name\": string | null,\n \"skus\": [{ \"description\": string, \"color_code\": string }],\n \"channels\": [{ \"name\": string, \"channel_code\": \"TR_ECOM\" | \"TR_PERAKENDE\" | \"TR_TOPTAN\" }],\n \"orders\": [{ \"color_code\": string, \"channel_code\": string, \"quantity\": number }],\n \"size_distribution\": \"standart\" | \"custom\",\n \"custom_sizes\": null | [{ \"size\": string, \"quantity\": number }],\n \"season\": string | null,\n \"order_type\": string | null,\n \"delivery_date\": string | null,\n \"psf\": number | null,\n \"currency\": string | null,\n \"confidence\": number,\n \"extraction_notes\": [string]\n}\n\nRules:\n- \"Ecom\" or \"e-ticaret\" → channel_code \"TR_ECOM\"\n- \"Perakende\" → channel_code \"TR_PERAKENDE\"\n- \"Toptan\" → channel_code \"TR_TOPTAN\"\n- If the email mentions \"standart beden dağılımı\" or just \"standart\", set size_distribution to \"standart\"\n- Parse Turkish number formats: \"4.000\" = 4000, \"2.099,99\" = 2099.99\n- Date format: convert to DD.MM.YYYY. \"27 Haziran\" in context of a business email likely means 2026.\n- For SKU color codes, extract from parentheses like \"(85370)\" → color_code \"85370\"\n- If model code prefix isn't explicit, leave it as the description (e.g. \"Keten\")\n- confidence is 0-1 reflecting how certain you are about the overall extraction\n- extraction_notes should list every inference you made`;\n\n// ── Main handler ─────────────────────────────────────────────────────\nexport default async function handler(req: Request): Promise {\n // CORS headers for the frontend\n const corsHeaders = {\n \"Access-Control-Allow-Origin\": \"*\",\n \"Access-Control-Allow-Methods\": \"POST, OPTIONS\",\n \"Access-Control-Allow-Headers\": \"Content-Type\",\n };\n\n if (req.method === \"OPTIONS\") {\n return new Response(null, { status: 204, headers: corsHeaders });\n }\n\n if (req.method !== \"POST\") {\n return new Response(JSON.stringify({ error: \"POST only\" }), {\n status: 405,\n headers: { ...corsHeaders, \"Content-Type\": \"application/json\" },\n });\n }\n\n try {\n // Check for API key\n const apiKey = Deno.env.get(\"ANTHROPIC_API_KEY\");\n if (!apiKey) {\n return new Response(JSON.stringify({\n error: \"ANTHROPIC_API_KEY not set. Add it in Val Town project settings → Environment Variables.\",\n }), {\n status: 500,\n headers: { ...corsHeaders, \"Content-Type\": \"application/json\" },\n });\n }\n\n const { subject, from, body } = await req.json();\n if (!body) {\n return new Response(JSON.stringify({ error: \"Missing 'body' field\" }), {\n status: 400,\n headers: { ...corsHeaders, \"Content-Type\": \"application/json\" },\n });\n }\n\n // ── Step 1: Call Claude to parse the email ──\n const client = new Anthropic({ apiKey });\n const emailText = [\n subject ? `Konu: ${subject}` : \"\",\n from ? `Gönderen: ${from}` : \"\",\n \"\",\n body,\n ].filter(Boolean).join(\"\\n\");\n\n const msg = await client.messages.create({\n model: \"claude-sonnet-4-20250514\",\n max_tokens: 2048,\n system: SYSTEM_PROMPT,\n messages: [{ role: \"user\", content: emailText }],\n });\n\n const raw = (msg.content[0] as any).text;\n let parsed: any;\n try {\n parsed = JSON.parse(raw);\n } catch {\n // Try extracting JSON from possible markdown wrapping\n const match = raw.match(/```(?:json)?\\s*([\\s\\S]*?)```/);\n if (match) parsed = JSON.parse(match[1]);\n else throw new Error(\"Claude did not return valid JSON: \" + raw.slice(0, 200));\n }\n\n // ── Step 2: Build SAP rows deterministically ──\n const rows: any[] = [];\n const allNotes: string[] = [...(parsed.extraction_notes || [])];\n\n for (const order of parsed.orders) {\n const channelInfo = CHANNEL_MAP[order.channel_code];\n if (!channelInfo) {\n allNotes.push(`Unknown channel code: ${order.channel_code}`);\n continue;\n }\n\n // Find the SKU info for this color\n const skuInfo = parsed.skus.find((s: any) => s.color_code === order.color_code);\n const skuPrefix = parsed.model_name || skuInfo?.description || \"UNKNOWN\";\n const skuFull = `${skuPrefix}-${order.color_code}`;\n\n // Size distribution\n let sizeRows: { size: string; qty: number }[];\n let qtyConfidence: string;\n\n if (parsed.size_distribution === \"standart\") {\n sizeRows = distributeStandard(order.quantity);\n qtyConfidence = \"medium\";\n // Only add this note once\n if (!allNotes.some((n: string) => n.includes(\"standard size curve\"))) {\n allNotes.push(`'standart beden dağılımı' → applied standard size curve to ${order.quantity} units`);\n }\n } else if (parsed.custom_sizes) {\n sizeRows = parsed.custom_sizes.map((cs: any) => ({ size: cs.size, qty: cs.quantity }));\n qtyConfidence = \"high\";\n } else {\n // Fallback: put everything in one row with no size\n sizeRows = [{ size: \"ALL\", qty: order.quantity }];\n qtyConfidence = \"low\";\n allNotes.push(`No size distribution specified for ${skuFull}, channel ${order.channel_code}`);\n }\n\n for (const sr of sizeRows) {\n rows.push({\n sku: skuFull,\n ana_beden: sr.size,\n miktar: sr.qty,\n kanal: order.channel_code,\n uretim_yeri: channelInfo.uretim_yeri,\n depo_yeri: channelInfo.depo_yeri,\n depo_yeri_2: channelInfo.depo_yeri_2,\n teslimat_tarihi: parsed.delivery_date || \"\",\n etiket_psf1: parsed.psf || 0,\n para_birimi: parsed.currency || \"TRY\",\n evrak_sezonu: parsed.season || \"\",\n evrak_turu: parsed.order_type || \"\",\n confidence: {\n sku: skuInfo ? \"high\" : \"low\",\n miktar: qtyConfidence,\n uretim_yeri: \"derived\",\n depo_yeri: \"derived\",\n },\n });\n }\n }\n\n // ── Step 3: Assemble response ──\n const result = {\n parsed: {\n type: parsed.type,\n model_name: parsed.model_name,\n skus: parsed.skus.map((s: any) => `${parsed.model_name || s.description}-${s.color_code}`),\n channels: parsed.orders.map((o: any) => o.channel_code).filter((v: string, i: number, a: string[]) => a.indexOf(v) === i),\n season: parsed.season,\n order_type: parsed.order_type,\n delivery_date: parsed.delivery_date,\n psf: parsed.psf,\n currency: parsed.currency,\n confidence: parsed.confidence,\n },\n rows,\n source: {\n subject: subject || \"\",\n from: from || \"\",\n body: body,\n extraction_notes: allNotes,\n },\n };\n\n return new Response(JSON.stringify(result, null, 2), {\n status: 200,\n headers: { ...corsHeaders, \"Content-Type\": \"application/json\" },\n });\n\n } catch (err: any) {\n return new Response(JSON.stringify({ error: err.message, stack: err.stack }), {\n status: 500,\n headers: { ...corsHeaders, \"Content-Type\": \"application/json\" },\n });\n }\n}\n",[60],"pulls","branches","forks","envVars",{"_174":36,"_176":20},"connections",{"_174":20,"_175":20},"count","unfilledCount","emptyCount",{"_29":163,"_13":60,"_58":59,"_39":-5,"_31":32,"_156":78,"_157":95,"_33":183,"_35":36,"_61":62,"_159":165,"_63":24,"_161":-5,"_180":184,"_131":185},{"_29":155,"_13":75,"_58":74,"_39":-5,"_31":32,"_156":69,"_157":95,"_33":179,"_35":20,"_61":62,"_159":160,"_63":24,"_161":-5,"_180":181,"_131":182},["D",1778085157995],"children",[],[75],["D",1778085219899],[],[60],["D",1778085062145],{"_11":12,"_130":66},{"_11":12,"_126":-5,"_65":66,"_25":64,"_127":128,"_129":24},{"_35":78,"_13":16,"_29":32,"_118":83,"_119":-5,"_120":-5,"_121":-5,"_122":-5,"_123":-5,"_124":14,"_125":12},"ctx",{"_47":-5,"_150":223,"_224":225,"_226":227,"_228":24,"_229":24,"_230":24,"_231":95,"_232":-5,"_233":-7,"_234":-7,"_235":20,"_236":24,"_237":24,"_238":-5,"_239":24,"_240":24,"_241":24,"_242":-5},"ENV",{"_194":195,"_196":197,"_198":16,"_199":200,"_201":202,"_203":204,"_205":206,"_207":208,"_209":210,"_211":212,"_213":214,"_215":216,"_217":218,"_219":220,"_221":222},"REACT_APP_SENTRY_DSN","https://586020d86f05489db63a554690acf1e9@o1398359.ingest.sentry.io/6724499","RENDER_GIT_COMMIT","71c1b20804b3232a7e513be260cfffc1932a9e97","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"]

History