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. 1

    Trigger on Cycle Counts

    Add a Google Sheets Trigger when a physical count is entered.

  2. 2

    Compare to Expected

    Add a Code node computing the variance between system stock and the physical count.

  3. 3

    Flag Significant Shrinkage

    Add an IF node continuing when unexplained variance exceeds your threshold.

  4. 4

    Alert to Investigate

    Add a Slack node reporting the SKU, variance and value for investigation.

  5. 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.