Product catalogue cleanup with complete row traceability

Product catalogue cleanup with complete row traceability

Self-initiated synthetic-data demonstration / AI-assisted

This study demonstrates a product-data cleanup and review workflow using 28 original synthetic records. All 28 rows are retained, with 14 rows flagged for clarification. Two duplicate-key groups contain four records, all retained. The workbook keeps the original text, documents normalization, preserves leading-zero identifiers and currency labels, and flags ambiguous values. It includes 10 text changes, 76 safe type conversions and 15 review events.

Workbook export/reimport and independent CSV/OpenXML checks were completed. Microsoft Excel desktop was not used for this demonstration.

This is a demonstration of the workflow, not a past client engagement. AI-assisted preparation and scripted checks are part of the workflow.