{"product_id":"n8n-workflow-clean-messy-url-lists-find-shopify-clothing-stores","title":"n8n Workflow: Clean Messy URL Lists \u0026 Find Shopify Clothing Stores","description":"\u003ch3\u003eClean up messy URL lists and quickly find Shopify clothing stores worth contacting\u003c\/h3\u003e\n\u003cp\u003eThis manual n8n workflow takes a pasted pile of messy links, extracts clean domains, verifies which ones are live Shopify stores, and filters for clothing-focused shops that match your product, pricing, activity, and currency rules—returning two outputs: qualified store candidates and rejected sites with clear reasons.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eRun manually in n8n:\u003c\/strong\u003e click-to-execute using a Manual Trigger.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eParse and normalize pasted links:\u003c\/strong\u003e extracts domains, removes duplicates and junk (social links, publishers, tracking URLs, and non-store pages), drops likely non-US\/foreign domains, and enforces a batch size limit per run (via \u003ccode\u003eMAX_PER_RUN\u003c\/code\u003e).\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eConfirm Shopify catalog availability:\u003c\/strong\u003e for each remaining domain, requests \u003ccode\u003e\/products.json\u003c\/code\u003e to verify it is a live Shopify storefront and to collect product\/vendor\/pricing data.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eCompute clothing and storefront quality signals:\u003c\/strong\u003e calculates product count, median variant price, clothing share based on product titles\/types\/tags, print-on-demand signals, and recent activity from product timestamps.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eValidate homepage context:\u003c\/strong\u003e fetches the homepage to detect store currency and adds warning flags such as store locator, wholesale\/stockists, or careers pages.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eSplit into two results:\u003c\/strong\u003e one list of stores that pass the catalog checks and filters, and another list of rejected domains including the exact (or capped) product count and a specific rejection reason.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eProspecting for \u003cstrong\u003eShopify clothing stores\u003c\/strong\u003e from scraped or exported URL lists.\u003c\/li\u003e\n  \u003cli\u003eShortlisting potential partners by \u003cstrong\u003eproduct count\u003c\/strong\u003e, \u003cstrong\u003emedian variant price\u003c\/strong\u003e, and \u003cstrong\u003erecent activity\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003eBuilding outreach targets with transparent rejection reasons (e.g., non-clothing focus, weak signals, or unexpected currency\/context).\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eNodes\/logic:\u003c\/strong\u003e if, code, sticky note, manual trigger (in n8n).\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eData checks:\u003c\/strong\u003e domain parsing, Shopify \u003ccode\u003e\/products.json\u003c\/code\u003e verification, homepage currency detection, and rules-based filtering.\u003c\/li\u003e\n\u003c\/ul\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":45876909342899,"sku":"N8N-18028","price":38.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/phfobOO6sM_trEeV4UIsJ_ZQ200cRX.png?v=1787304040","url":"https:\/\/buyflowscripts.com\/products\/n8n-workflow-clean-messy-url-lists-find-shopify-clothing-stores","provider":"N8N Commerce","version":"1.0","type":"link"}