In-Store Products Catalog ${\n categoryFilter ? `

[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8,"_9":10},"actionData","errors","root",{"_152":153,"_154":155},"routes/_app.x.$handle.$name",{"_11":12,"_13":14,"_15":16,"_18":19,"_17":-7,"_115":-5,"_20":116,"_22":117,"_118":119,"_120":121,"_25":122,"_24":-5,"_123":-5,"_124":-5,"_125":53,"_126":127,"_128":44,"_129":-5,"_130":-5,"_131":132},"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","cmvp","name","mainArticle","branchName","main","version","path","","project",{"_33":61,"_13":14,"_45":62,"_63":-5,"_64":53,"_65":66,"_67":66,"_68":-5,"_69":-5,"_70":71,"_72":-5,"_73":53,"_74":-5,"_75":-5,"_76":77,"_78":79,"_80":-5,"_81":-5,"_82":-5,"_83":-5,"_84":85,"_86":85,"_87":88,"_89":88,"_90":88,"_91":85,"_92":85,"_93":94,"_95":96,"_97":98,"_99":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","11a5e368-f8b6-41de-b488-e2afcc04304d","main.ts","fileId","065c2690-5dbe-11f1-966f-1607ee4eb77e","parentId","branchId","06585614-5dbe-11f1-966f-1607ee4eb77e","branchVersion",22,"latest",true,"createdAt",["D",1781546547091],21,"fileType","http","content","export default async function rssFeed(req: Request): Promise {\n const SPREADSHEET_ID = \"1HfglQc2Bc1DzsA7ocrMrzB5nRRieffCmdUtZk6daurE\";\n const csvUrl =\n `https://docs.google.com/spreadsheets/d/${SPREADSHEET_ID}/export?format=csv`;\n\n try {\n if (req.method === \"OPTIONS\") {\n return new Response(null, {\n headers: {\n \"Access-Control-Allow-Origin\": \"*\",\n \"Access-Control-Allow-Methods\": \"GET, OPTIONS\",\n \"Access-Control-Allow-Headers\": \"*\",\n },\n });\n }\n\n const urlObj = new URL(req.url);\n const categoryFilter = urlObj.searchParams.get(\"cat\");\n const mainCategoryFilter = urlObj.searchParams.get(\"main_cat\");\n const formatFilter = urlObj.searchParams.get(\"format\");\n\n // Decode URL parameters safely to match unencoded spreadsheet text strings\n const decodedCatFilter = categoryFilter\n ? decodeURIComponent(categoryFilter)\n : null;\n const decodedMainFilter = mainCategoryFilter\n ? decodeURIComponent(mainCategoryFilter)\n : null;\n\n const response = await fetch(csvUrl);\n if (!response.ok) {\n throw new Error(`Google Sheets returned status: ${response.status}`);\n }\n\n const csvText = await response.text();\n\n // Parse CSV rows cleanly\n const allRows = csvText.split(/\\r?\\n/).map((row) => {\n return row.split(/,(?=(?:(?:[^\"]*\"){2})*[^\"]*$)/).map((cell) =>\n cell.replace(/^\"|\"$/g, \"\").trim()\n );\n });\n\n // Automatically locate the true header row by finding where column data starts\n let headerIndex = -1;\n for (let i = 0; i < allRows.length; i++) {\n if (\n allRows[i].some((cell) =>\n cell.toLowerCase().includes(\"timestamp\") ||\n cell.toLowerCase().includes(\"nom de l'article\")\n )\n ) {\n headerIndex = i;\n break;\n }\n }\n\n if (headerIndex === -1) headerIndex = 0;\n\n const headers = allRows[headerIndex].map((h) => h.trim());\n const productRows = allRows.slice(headerIndex + 1);\n\n // Dynamic key locator using strict keyword matches (no dropdown artifacts)\n const findValueByKeyword = (\n rowData: string[],\n keywords: string[],\n ): string => {\n const matchIndex = headers.findIndex((h) =>\n keywords.some((kw) => h.toLowerCase().includes(kw.toLowerCase()))\n );\n return matchIndex !== -1 && rowData[matchIndex]\n ? rowData[matchIndex].trim()\n : \"\";\n };\n\n let products = productRows.map((row) => {\n let subCategoryFound = \"\";\n headers.forEach((header, index) => {\n const cellValue = row[index] ? row[index].trim() : \"\";\n if (\n header.toLowerCase().includes(\"catégorie secondaire\") &&\n cellValue !== \"\"\n ) {\n subCategoryFound = cellValue;\n }\n });\n\n // Extract details based on clean header text matching\n const title = findValueByKeyword(row, [\"nom de l'article\", \"titre\"]) ||\n \"Sans titre\";\n const price = findValueByKeyword(row, [\"prix\"]) || \"0.00\";\n const imageUrlRaw = findValueByKeyword(row, [\n \"image de l'article\",\n \"lien photo\",\n \"url\",\n ]);\n const mainCategory = findValueByKeyword(row, [\"catégorie principale\"]) ||\n \"\";\n const extraFeature = findValueByKeyword(row, [\n \"caractéristiques supplémentaire\",\n \"caractéristiques\",\n ]) || \"\";\n const etatValue = findValueByKeyword(row, [\"état\"]) || \"0\";\n const quantity = findValueByKeyword(row, [\"quantité\"]) || \"0\";\n\n const length = findValueByKeyword(row, [\"longueur\"]);\n const depth = findValueByKeyword(row, [\"profondeur\"]);\n const height = findValueByKeyword(row, [\"hauteur\"]);\n\n // Format Google Drive image paths to direct image streams\n let imageUrl = \"\";\n if (imageUrlRaw) {\n const firstUrl = imageUrlRaw.split(\",\")[0].trim();\n const match = firstUrl.match(/\\/d\\/([a-zA-Z0-9-_]+)/) ||\n firstUrl.match(/id=([a-zA-Z0-9-_]+)/);\n imageUrl = (match && match[1])\n ? \"https://lh3.googleusercontent.com/d/\" + match[1]\n : firstUrl;\n }\n\n // Safe category array assembly\n let categoryParts = [];\n if (mainCategory) categoryParts.push(mainCategory);\n if (subCategoryFound) categoryParts.push(subCategoryFound);\n if (extraFeature) categoryParts.push(extraFeature);\n const combinedCategories = categoryParts.join(\" / \");\n\n const dimensionsStr = (length || depth || height)\n ? `${length || \"0\"}\" x ${depth || \"0\"}\" x ${height || \"0\"}\"`\n : \"\";\n\n return {\n title,\n price,\n imageUrl,\n mainCategory,\n subCategory: subCategoryFound,\n categories: combinedCategories,\n dimensions: dimensionsStr,\n etat: etatValue,\n quantity,\n link: \"https://your-square-site.square.site/#pickup\",\n };\n });\n\n // Filters out completely blank row entries at the bottom of sheets\n products = products.filter((item) =>\n item.title !== \"Sans titre\" || item.price !== \"0.00\"\n );\n\n // 2. FIXED Category Routing Logic (Now using decoded parameter constants)\n if (decodedCatFilter || decodedMainFilter) {\n const cleanCatFilter = decodedCatFilter\n ? decodedCatFilter.trim().toLowerCase()\n : \"\";\n const cleanMainFilter = decodedMainFilter\n ? decodedMainFilter.trim().toLowerCase()\n : \"\";\n\n products = products.filter((item) => {\n // Fonction utilitaire pour enlever les accents et mettre en minuscule\n const normalize = (str) =>\n str.toLowerCase().normalize(\"NFD\").replace(/[\\u0300-\\u036f]/g, \"\");\n\n const itemMainCat = normalize(item.mainCategory);\n const itemSubCat = normalize(item.subCategory);\n const filterCat = normalize(cleanCatFilter);\n const filterMain = normalize(cleanMainFilter);\n\n // Scenario A: Both parent and child context parameters are passed\n if (cleanCatFilter && cleanMainFilter) {\n return itemMainCat.includes(filterMain) &&\n itemSubCat.includes(filterCat);\n }\n\n // Scenario B: Only main category was targeted\n if (cleanMainFilter) {\n return itemMainCat.includes(filterMain);\n }\n\n // Scenario C: Only targeted fallback context check\n return itemMainCat.includes(filterCat) ||\n itemSubCat.includes(filterCat);\n });\n }\n\n // JSON Format Output Route\n if (formatFilter === \"json\") {\n return new Response(JSON.stringify(products), {\n headers: {\n \"Content-Type\": \"application/json; charset=utf-8\",\n \"Access-Control-Allow-Origin\": \"*\",\n },\n });\n }\n\n // RSS XML Output Route\n let rssString = `\n\n\n In-Store Products Catalog ${\n categoryFilter ? ` - ${categoryFilter}` : \"\"\n }\n https://your-square-site.square.site\n Live look at our current in-store inventory for local pickup.\n ${new Date().toUTCString()}\\n`;\n\n for (const item of products) {\n let rssDesc = item.categories;\n if (item.dimensions) rssDesc += ` \\n • Dimensions: ${item.dimensions}`;\n\n rssString += ` \n <![CDATA[${item.title} - $${item.price}]]>\n
${rssDesc}]]>\n ${item.link}\n ${new Date().toUTCString()}\n \\n`;\n }\n\n rssString += `\\n`;\n\n return new Response(rssString, {\n headers: {\n \"Content-Type\": \"application/xml; charset=utf-8\",\n \"Access-Control-Allow-Origin\": \"*\",\n },\n });\n } catch (error: any) {\n return new Response(\"Error building Catalog: \" + error.message, {\n status: 500,\n headers: { \"Access-Control-Allow-Origin\": \"*\" },\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",1781546547091],"children",[],[35],"065795f8-5dbe-11f1-966f-1607ee4eb77e",["D",1780320615676],"deletedAt","legacyEnvVars","privacy","public","httpPrivacy","description","imageUrl","userId","e27aca1d-acfb-4eb6-84e3-f9b6d7b05fed","pinnedFileId","pinPreview","pinMigrated","screenshotVersion","likeCount",0,"orgId","019e74c1-94e8-71fd-8555-1fd09f43fdcb","tursoName","tursoHostname","tursoMeasuredAt","pinned","userPerm","r","valPerm","blobPerm","rw","emailPerm","sqlitePerm","projectPerm","telemetryPerm","user",{"_11":12,"_114":-5},"org",{"_11":12,"_108":109,"_110":-5,"_70":-5,"_111":112,"_113":53},"branch",{"_17":42,"_13":16,"_33":40,"_100":61,"_101":-5,"_102":-5,"_103":-5,"_104":-5,"_105":-5,"_106":14,"_107":12},"isOwned","projectId","forkedBranchId","forkedBranchVersion","forkedProjectPrivacy","forkedProjectId","forkedProjectOrgId","projectName","userHandle","displayName","CMVP","avatar","tier","free","canRestrictVals","profileImageUrl","adoptOrgId",{"_33":61,"_13":14,"_45":148,"_63":-5,"_64":53,"_65":66,"_67":66,"_68":-5,"_69":-5,"_70":71,"_72":-5,"_73":53,"_74":-5,"_75":-5,"_76":77,"_78":79,"_80":-5,"_81":-5,"_82":-5,"_83":-5,"_84":85,"_86":85,"_87":88,"_89":88,"_90":88,"_91":85,"_92":85,"_93":149,"_95":150,"_97":151,"_99":53},[145],"files",[145],"counts",{"_135":77,"_136":137,"_138":77,"_31":139,"_140":141},[133],"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":134},[35],"pulls","branches",1,"forks",{"_142":77,"_144":77},"connections",{"_142":77,"_143":77},"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":146,"_18":147},[],[35],["D",1780320615676],{"_11":12,"_114":-5},{"_11":12,"_108":109,"_110":-5,"_70":-5,"_111":112,"_113":53},{"_17":42,"_13":16,"_33":40,"_100":61,"_101":-5,"_102":-5,"_103":-5,"_104":-5,"_105":-5,"_106":14,"_107":12},"ctx",{"_93":-5,"_130":185,"_186":187,"_188":189,"_190":53,"_191":53,"_192":53,"_193":44,"_194":-5,"_195":-7,"_196":-7,"_197":77,"_198":53,"_199":53,"_200":-5,"_201":53,"_202":53,"_203":53,"_204":-5},"ENV",{"_156":157,"_158":159,"_160":16,"_161":162,"_163":164,"_165":166,"_167":168,"_169":170,"_171":172,"_173":174,"_175":176,"_177":178,"_179":180,"_181":182,"_183":184},"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