{"product_id":"n8n-form-validate-sales-csv-export-review-zip","title":"n8n Form: Validate Sales CSV \u0026 Export Review ZIP","description":"\u003ch3\u003eValidate Sales CSVs, decide approvals, and export a complete review ZIP in n8n\u003c\/h3\u003e\n\u003cp\u003eThis n8n workflow accepts a UTF-8 sales CSV through an authenticated \u003cstrong\u003en8n Form\u003c\/strong\u003e, validates and audits orders (including duplicates and conflicts against prior releases), then produces a review ZIP and an approval\/rejection trail—exporting everything you need for safe, traceable manual import.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eAuthenticated intake:\u003c\/strong\u003e Receive a sales CSV and a unique \u003cem\u003ebatch ID\u003c\/em\u003e via an authenticated n8n Form. Only configured users can submit or review batches.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eCSV validation \u0026amp; de-duplication:\u003c\/strong\u003e Validate required headers, calendar dates, amounts, and currency precision. Preserve additional columns, keep one copy of identical rows, and hold conflicting duplicate order groups.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eRelease registry comparison:\u003c\/strong\u003e Compare eligible orders with a previously released “release registry” stored in an \u003cstrong\u003en8n Data Table\u003c\/strong\u003e. Exclude identical previously released orders and hold historical conflicts.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eImmutable review snapshot:\u003c\/strong\u003e Save an exact review snapshot (including a hash, source-record references, issue details, and separate totals per currency) and return a `draft` review ZIP.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eApprove or reject through a second form:\u003c\/strong\u003e A second authenticated n8n Form downloads the exact saved review using the required hash, then approves accepted rows or rejects the batch with explicit confirmation.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eConditional commit \u0026amp; audit outputs:\u003c\/strong\u003e Commit the decision receipt and released orders through a conditional registry update. Repeated identical decisions do not re-release orders. Stale reviews and competing updates are blocked.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eExported files:\u003c\/strong\u003e Provide \u003ccode\u003ereport.json\u003c\/code\u003e, \u003ccode\u003eissues.csv\u003c\/code\u003e, \u003ccode\u003eaudit.json\u003c\/code\u003e, and either \u003ccode\u003edraft-sales.csv\u003c\/code\u003e or \u003ccode\u003ereleased-sales.csv\u003c\/code\u003e.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eOperators upload sales exports and need deterministic validation before any manual import.\u003c\/li\u003e\n  \u003cli\u003eTeams detect duplicates, conflicting orders, or currency\/precision issues early.\u003c\/li\u003e\n  \u003cli\u003eSaaS workflows require an approval UI with a verifiable hash and decision audit trail.\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, form, no op, data table, sticky note\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eCore features:\u003c\/strong\u003e CSV header\/date\/amount\/currency precision checks, duplicate grouping, release registry comparison, immutable hashed review snapshots, authenticated approvals, ZIP export with audit artifacts.\u003c\/li\u003e\n\u003c\/ul\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":46232431296691,"sku":"N8N-21042","price":47.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/dYPxp9ny1JZ4BpNSvn7_Y_Q5M1EHZw.png?v=1792142190","url":"https:\/\/buyflowscripts.com\/products\/n8n-form-validate-sales-csv-export-review-zip","provider":"N8N Commerce","version":"1.0","type":"link"}