Project Overview We are looking for an experienced n8n developer to build a robust, scalable automated workflow for our retail business. The goal is to automate the replenishment process by pulling data from our Lightspeed X-Series (formerly Vend) POS, calculating order requirements, and managing a multi-stage approval and dispatch system. The initial implementation will target a specific vendor, but the architecture must be modular and scalable so it can be easily cloned for additional vendors by simply updating Supplier IDs—no hardcoding. Scope of Work & Technical Logic 1. Data Retrieval & Intelligent Filtering API Integration: Pull product data from Lightspeed X-Series endpoints (v2026.04). Logic-Based Filtering: Since the API does not filter by supplier, the workflow must retrieve all products and use n8n logic to filter for specific Supplier IDs. Iteration: Iterate through filtered products to fetch real-time inventory details via the List Inventory Records endpoint. Exclusion Rules: Automatically exclude items tagged as "unorderable," marked "discontinued" in custom fields, or set to "disabled." 2. Order Calculation & Document Generation Quantities: Calculate order amounts based on the difference between the reorder point and current inventory. Spreadsheet Creation: Generate an order file (Google Sheets or CSV) containing: Item Name, Internal SKU, Supplier SKU, Supplier Pricing, Retail Pricing (optional/toggleable), and Purchase Quantity. 3. Advanced Approval & "Auto-Bypass" Logic Manual Review: Use a "Send and Wait" Gmail node to deliver an order summary and the spreadsheet for my review. Configurable Auto-Approval: If the total order cost is under a specific threshold (e.g., $2,000) and no manual action is taken within a set timeframe (e.g., 24 hours), the system must automatically approve the order. Minimum Order Threshold: The system should abort the build and send a notification if the total order value fails to meet a configurable minimum (e.g., $400). 4. Dispatch & POS Synchronization Vendor Notification: Upon approval (manual or auto-bypass), email the spreadsheet to the vendor. POS Update: Once sent, create the corresponding Purchase Order in Lightspeed and set the status to "Dispatched." Technical Requirements Platform: n8n API: Lightspeed X-Series REST API. Scheduling: Configure the workflow to trigger every Monday and Thursday morning. Scalability: The solution must be built as a template to avoid hardcoding vendor-specific logic, except for vendor ID. Preferred Qualifications Proven track record of building complex n8n workflows with external API integrations. Familiarity with retail/inventory management logic. Ability to handle API rate limits and large data sets (iterating through full product lists). Bonus: Previous experience with Lightspeed X-Series (Vend) API. API References for your review: List Products: https://x-series-api.lightspeedhq.com/v2026.04/reference/listproducts Inventory Records: https://x-series-api.lightspeedhq.com/v2026.04/reference/listinventoryrecords_v2026-04