{"product_id":"n8n-workflow-quote-draft-from-csv-uploads-price-list","title":"n8n Workflow: Quote Draft from CSV Uploads \u0026 Price List","description":"\u003ch3\u003eGenerate a quotation draft from CSV uploads—automatically, SKU-accurate, and review-ready\u003c\/h3\u003e\n\u003cp\u003eThis n8n workflow creates a \u003cstrong\u003equotation draft\u003c\/strong\u003e from a \u003cstrong\u003erequest CSV\u003c\/strong\u003e and an \u003cstrong\u003eapproved price list CSV\u003c\/strong\u003e. It calculates line totals per currency, then \u003cstrong\u003eholds unknown, blocked, duplicate, or unit-mismatched items for review\u003c\/strong\u003e—so parts distributors and sales teams get clean, compliant quotes fast.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eReceives an n8n Form submission\u003c\/strong\u003e with two uploaded CSV files (request + price list) and a chosen delimiter.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eValidates uploads\u003c\/strong\u003e as UTF-8 \u003ccode\u003e.csv\u003c\/code\u003e within size limits and reads them as text.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eParses and enforces required headers\u003c\/strong\u003e for both files.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eBuilds a SKU catalogue\u003c\/strong\u003e from the price list while flagging invalid rows and blocking \u003cstrong\u003eduplicate SKUs\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eValidates each request line\u003c\/strong\u003e (expects \u003ccode\u003eline_id\u003c\/code\u003e, \u003ccode\u003equantity\u003c\/code\u003e, \u003ccode\u003eunit\u003c\/code\u003e) and matches it to exactly \u003cstrong\u003eone case-sensitive SKU\u003c\/strong\u003e in the catalogue.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eHolds problematic lines for review\u003c\/strong\u003e: unknown SKUs, blocked SKUs, duplicate SKU matches, or \u003cstrong\u003eunit mismatches\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eCalculates pricing\u003c\/strong\u003e for accepted lines and generates separate totals per currency.\u003c\/li\u003e\n  \u003cli\u003eOutputs \u003cstrong\u003ereport.json\u003c\/strong\u003e, \u003cstrong\u003equotation-draft.csv\u003c\/strong\u003e, and \u003cstrong\u003ereview.csv\u003c\/strong\u003e, then packages them into a single \u003cstrong\u003eZIP\u003c\/strong\u003e download with a status summary.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eSales teams draft quotes from customer requests exported as CSV—using exact SKUs from an approved price list.\u003c\/li\u003e\n  \u003cli\u003eParts distributors reconcile inconsistent requests by flagging unknown\/block\/unit-mismatched items for human review.\u003c\/li\u003e\n  \u003cli\u003eSaaS operators streamline quoting workflows while keeping outputs structured for downstream systems.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003en8n Form Trigger\u003c\/strong\u003e for file upload and delimiter selection.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eCode\u003c\/strong\u003e node(s) for CSV parsing, header validation, SKU matching, duplicate blocking, and calculations.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eConvert to File\u003c\/strong\u003e and \u003cstrong\u003eCompression\u003c\/strong\u003e to return \u003ccode\u003equotation-review.zip\u003c\/code\u003e.\u003c\/li\u003e\n  \u003cli\u003eUses \u003cstrong\u003ecase-sensitive SKU matching\u003c\/strong\u003e and supports delimiters: comma, semicolon, or tab.\u003c\/li\u003e\n\u003c\/ul\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":46192819503283,"sku":"N8N-20682","price":9.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/0Jhnn3IVpv3yEEOW6x544_DVS2k96T.png?v=1791536753","url":"https:\/\/buyflowscripts.com\/products\/n8n-workflow-quote-draft-from-csv-uploads-price-list","provider":"N8N Commerce","version":"1.0","type":"link"}