Inventory sync by product_id in n8n

# Compare two warehouse datasets by product_id for sync in n8n

This automation template helps identify discrepancies in product inventories between two warehouses (A and B) using n8n and the Compare Datasets node. Warehouse A is treated as the source of truth. The workflow classifies each item as ´to add´, ´to update´, ´to delete´, or ´no action needed´, enabling accurate data synchronization without manual checks. Designed for inventory specialists, data analysts, and system administrators using n8n.

## Who it´s for
- Inventory specialists synchronizing data across warehouses
- Data analysts who need to detect dataset mismatches
- System administrators using n8n for automation

## What the automation does
- Triggered manually on demand
- Fetches product lists from two sources: Warehouse A and Warehouse B
- Splits data into individual items using SplitOut
- Compares entries by product_id using the Compare Datasets node
- Routes results into four categories: add to B, update in B, remove from B, no change
- Flags items like ´Webcam´ (missing in B) for addition
- Identifies items with mismatched stock (e.g., ´Mouse´) for update
- Detects orphaned items in B (e.g., ´Monitor´) for removal

## What´s included
- Ready-to-use n8n workflow
- Trigger and handler logic based on manual_trigger
- Integrations with Warehouse A and Warehouse B via standard nodes
- Basic textual guide for setup and adaptation

## Requirements for setup
- Access to an n8n instance
- Product data from both warehouses available for import (e.g., JSON, CSV, API)
- Consistent use of product_id as unique identifier in both datasets

## Benefits and outcomes
- Eliminates manual cross-checking of inventory
- Quickly identifies data mismatches
- Reduces errors in synchronization processes
- Formalizes comparison through a repeatable workflow
- Saves time during periodic audits
- Provides clear visibility into required changes

## Important: template only
Important: you are purchasing a ready-made automation workflow template only. Rollout into your infrastructure, connecting specific accounts and services, 1:1 setup help, custom adjustments for non-standard stacks and any consulting support are provided as a separate paid service at an individual rate. To discuss custom work or 1:1 help, contact via chat