{"product_id":"build-cms-import-rows-collision-safe-redirects-legacy-csv-in-n8n","title":"Build CMS Import Rows \u0026 Collision-Safe Redirects (Legacy CSV) in n8n","description":"\u003ch3\u003eImport legacy CMS content rows with collision-safe slugs—and generate 301 redirects from your CSV\u003c\/h3\u003e\n\u003cp\u003eThis n8n workflow helps you upload a legacy content CSV, normalize source URLs and slugs, generate collision-safe destination slugs, and output ready-to-import CMS import rows plus a 301 redirect map with diagnostics for collisions and rejected records.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cb\u003eAccepts a CSV upload\u003c\/b\u003e via an \u003cb\u003en8n Form Trigger\u003c\/b\u003e, ingesting legacy rows for migration.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cb\u003eApplies migration rules\u003c\/b\u003e using configurable behavior such as \u003cb\u003eredirectStatusCode\u003c\/b\u003e, \u003cb\u003edestinationPrefix\u003c\/b\u003e, and a \u003cb\u003ecollision suffix policy\u003c\/b\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cb\u003eNormalizes each record\u003c\/b\u003e by cleaning the \u003cb\u003esource URL format\u003c\/b\u003e and trimming \u003cb\u003etitle\u003c\/b\u003e and any provided \u003cb\u003eslug\u003c\/b\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cb\u003eGenerates destination slugs\u003c\/b\u003e by:\n    \u003cul\u003e\n      \u003cli\u003eKeeping valid supplied slugs when available, or\u003c\/li\u003e\n      \u003cli\u003eSlugifying titles when slugs are missing\/invalid,\u003c\/li\u003e\n    \u003c\/ul\u003e\n    \u003c\/li\u003e\n  \u003cli\u003e\n\u003cb\u003eResolves duplicate slugs deterministically\u003c\/b\u003e with numeric suffixes, ensuring collision-safe destination slugs.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cb\u003eRejects invalid rows\u003c\/b\u003e that are missing required identity fields, and returns diagnostics.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cb\u003eOutputs two collections\u003c\/b\u003e:\n    \u003cul\u003e\n      \u003cli\u003eCMS content import rows (e.g., \u003cb\u003etitle\u003c\/b\u003e, \u003cb\u003eslug\u003c\/b\u003e, \u003cb\u003edestination path\u003c\/b\u003e)\u003c\/li\u003e\n      \u003cli\u003eA \u003cb\u003eredirect map\u003c\/b\u003e (\u003cb\u003efrom\u003c\/b\u003e → \u003cb\u003eto\u003c\/b\u003e, plus \u003cb\u003estatus code\u003c\/b\u003e)\u003c\/li\u003e\n    \u003c\/ul\u003e\n  \u003c\/li\u003e\n  \u003cli\u003e\n\u003cb\u003eReturns a readiness flag\u003c\/b\u003e (\u003ci\u003eready\u003c\/i\u003e vs. \u003ci\u003ereview_required\u003c\/i\u003e) based on whether collisions or rejected records are present.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003ePreparing a bulk CMS migration from a \u003cb\u003elegacy CSV export\u003c\/b\u003e while preserving old URLs via \u003cb\u003e301 redirects\u003c\/b\u003e.\u003c\/li\u003e\n  \u003cli\u003eGenerating \u003cb\u003ecollision-safe SEO slugs\u003c\/b\u003e before importing content into a new CMS.\u003c\/li\u003e\n  \u003cli\u003eRunning a pre-flight check to identify \u003cb\u003ecollisions\u003c\/b\u003e and \u003cb\u003erejected records\u003c\/b\u003e before any import.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eNodes\/blocks used: \u003cb\u003eForm Trigger\u003c\/b\u003e, \u003cb\u003eif\u003c\/b\u003e, \u003cb\u003eset\u003c\/b\u003e, \u003cb\u003ecode\u003c\/b\u003e, \u003cb\u003emerge\u003c\/b\u003e, and \u003cb\u003esticky note\u003c\/b\u003e.\u003c\/li\u003e\n  \u003cli\u003eBehavior includes slugifying titles, numeric suffix collision resolution, and building both CMS import rows and a redirect map with diagnostics.\u003c\/li\u003e\n\u003c\/ul\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":45785668747443,"sku":"N8N-17911","price":54.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/XUY5S_nPjnX73_0r9F379_ta3pgIIn.png?v=1786180188","url":"https:\/\/buyflowscripts.com\/products\/build-cms-import-rows-collision-safe-redirects-legacy-csv-in-n8n","provider":"N8N Commerce","version":"1.0","type":"link"}