Inventory Check

😫 The Pain Point

End of month stock count.

• System says: SKU-A has 10 units.
• Warehouse count says: SKU-A has 8 units. Variance is -2. You have 2,000 SKUs. Doing VLOOKUP for 2,000 items is a headache.

🚀 Agentic Solution

Automated Reconciliation: Merges the two lists and highlights the operational errors.

Key Features:

• Diff Report: Only outputs items with differences.
• Value Calc: Calculates the total financial loss (Diff * Unit Price).

⚔️ Phase 1: Commander (Quick Fix)

For a one-time check.

Prompt:

“I have System.xlsx and Physical.xlsx. Both have ‘SKU’ and ‘Qty’. Merge them on SKU, calculate the difference (System - Physical), and filter only the rows where difference is not 0.”

Result: A variance report.

🏗️ Phase 2: Architect (Permanent Tool)

For Warehouse Managers.

Engineering Prompt:

**Role:** Python Data Analyst
**Task:** Create an "Inventory Reconciliation Tool".
**Requirements:**
1.  **GUI:**
    *   Select System File.
    *   Select Physical Count File.
    *   "Compare" button.
2.  **Logic:**
    *   Merge DataFrames on 'SKU'.
    *   Fill `NaN` with 0 (Missing items).
    *   Calc Diff.
    *   Highlight rows where Diff != 0.
3.  **Output:** Excel file with filtered discrepancies.
4.  **Deliverables:** `inventory_check.py`, `run.bat` (Windows), `run.sh` (Mac).

🧠 Prompt Decoding

• Fill Missing: The classic “NaN” error. If an item is in the System but missing from the Count file (because count was 0), merging creates a NULL value. The prompt explicitly handles this logic.

🛠️ Instructions

1. Copy Prompt -> Paste -> Run.
2. Load Files -> Compare.