n8n Workflow: Compare Supplier Quote Subtotals with JavaScript

Compare Supplier Quote Subtotals with JavaScript in n8n

This n8n workflow takes multiple supplier quotes for the same quantity and currency, validates the inputs, calculates goods/freight/setup subtotals, and ranks suppliers by the lowest quoted subtotal—using JavaScript Code nodes for transparent, audit-friendly calculations.

What this workflow does

• Runs on manual execution (Manual Trigger) so you can test and rerun with your own data.
• Loads a sample JSON payload containing the required quantity, currency, and an array of supplier quotes.
• Validates quote consistency:
  • Ensures every quote uses the same currency and same quantity.
  • Verifies unique supplier names.
  • Checks that monetary amounts are nonnegative integers and the deposit percentage is 0–100.
• Calculates key totals per supplier, including goods cost, freight, setup, overall subtotal, and subtotal per unit.
• Computes a goods-only deposit amount based on the provided deposit percentage.
• Sorts suppliers by the lowest quoted subtotal and outputs a report, including ties for the lowest subtotal.

Use cases

• Procurement teams comparing vendor quotes for the same order quantity and currency.
• SaaS operators standardizing quote calculations and reducing manual spreadsheet errors.
• Automation engineers validating quote JSON payloads before downstream approvals or purchasing decisions.

Technical details

• Nodes/tech stack: Code (JavaScript), Sticky Note, Manual Trigger
• Setup requirements: Import the workflow and run the fictional example first. Inspect the calculation step, then replace Example input with your normalized quotes.
• Money format: Provide values as integer minor units (e.g., GBP: 420 means GBP 4.20). Include freight and setup explicitly, using zero only when actually zero.