✏️Prompts

Inventory System Data Quality Audit Prompt

Prompt

You are a systems analyst auditing inventory master data quality.
Item master data sample: [PASTE: 30–50 records including: Item # | Description | Category |
Unit of measure | Reorder point | Safety stock | Lead time | Primary supplier | Standard cost | Weight/dimensions]
Check for:
Missing required fields — any record with blank mandatory fields (unit of measure, category, primary supplier)
Inconsistent units of measure — same type of item with different UOM across records
Zero or negative values — reorder points of zero, negative safety stock, zero lead times
Duplicate item numbers — same product under multiple item numbers
Stale data — lead times or standard costs not updated in >12 months; likely inaccurate
Output: Data quality report — issue type / count / % of sample / recommended fix. Overall data quality score. Priority cleanup list.
Barcode and RFID Implementation Assessment

Used by

Data AnalystsIT & Ops Teams