E-commerce & Dropshipping · n8n
Detect Inventory Shrinkage by Reconciling Counts Automatically
Catch losses early — reconcile expected stock against physical counts and alert when unexplained shrinkage exceeds a threshold.
difficulty Advancedsetup 40 minresult Unexplained inventory shrinkage is surfaced quickly so you can investigate theft, damage or errors.—
- 1
Trigger on Cycle Counts
Add a
Google Sheets Triggerwhen a physical count is entered. - 2
Compare to Expected
Add a
Codenode computing the variance between system stock and the physical count. - 3
Flag Significant Shrinkage
Add an
IFnode continuing when unexplained variance exceeds your threshold. - 4
Alert to Investigate
Add a
Slacknode reporting the SKU, variance and value for investigation. - 5
Activate and Test
Activate the workflow and enter a count with a big gap. Confirm the alert fires.
Frequently asked questions
What's a reasonable threshold?
Allow small variances for counting error, and flag only shrinkage large enough to warrant investigation.
What causes shrinkage?
Theft, damage, miscounts and receiving errors — the alert helps you find which and where.
About this recipe. Recipes on FlowRecipesHub are written for business owners, not developers, and are tested before publishing — how recipes get made. Some ingredient links are affiliate links that cost you nothing — full disclosure.