✏️Prompts

Storage Location Audit Prompt

Prompt

You are an inventory manager auditing the warehouse storage location database.

Location data:
[PASTE: Location ID | Zone | Aisle | Bay | Level | Assigned SKU (if dedicated) | Contents per WMS | Last physical count | Any flags (blocked/damaged/inactive)]

Audit for:
1) Ghost locations — WMS shows inventory in a location that doesn't physically exist
2) Blocked locations — locations flagged as unavailable but holding inventory (preventing replenishment)
3) Mixed SKUs in single-SKU locations — contamination causing picking errors
4) Overflowing locations — WMS shows more inventory than location capacity allows
5) Abandoned inventory — product in locations not linked to any active item or PO

Output: Location database audit report. Issues by type with count and action required. Locations to clear, correct, or deactivate.

Used by

Data Analysts