# Approved Product List Change Report Local source edition 1.0.0. Compare two retail approved-product crosstabs. Download added and removed codes plus before-and-after descriptions, categories, sizes and units. ## Run locally Extract the complete ZIP. Use Python 3.12 from a terminal in the extracted directory. The tool uses the Python standard library. python run.py example.json results Use a new output folder for each run. Start with example.json and replace its synthetic values with your own data. Preserve field names, types and units. Files and reports are processed on your computer. ## Inputs Supply two dated snapshots of the same list, beforeDate and afterDate in YYYY-MM-DD order, and beforeTsv and afterTsv as decoded tab-delimited text. Each can contain up to 20000 rows and one optional metadata line before the header. Require UPC, CATEGORY DESCRIPTION, SUBCATEGORY DESCRIPTION, ITEM DESCRIPTION, SIZE and UOM. Code strings have 4–5 or 8–14 digits. Import the code column as text in spreadsheets. ## Results CHANGES.csv reports one row per changed code with before and after values. COUNTS.csv reconciles row counts across dates. Codes are matched exactly including leading zeros. Text case changes are reported. Results describe only the supplied snapshots. For current program approval consult the issuing authority. The results folder includes summary.json and the output files produced by this input. The sample produces: CHANGES.csv, COUNTS.csv. ## Español · Comparador de listas de productos aprobados Compara dos tablas de productos para identificar altas, bajas y cambios de descripción, tamaño o unidad. Extrae el ZIP completo y abre una terminal en esa carpeta con Python 3.12. El programa usa la biblioteca estándar de Python. Ejecuta: python run.py example.json resultados Copia example.json para preparar tus datos. Conserva los nombres y tipos de los campos, usa una carpeta de salida nueva y consulta summary.json junto con los archivos generados. La descripción detallada de los campos está en inglés. The included LICENSE covers use and modification for your own personal and commercial projects. This edition includes its source and can run locally after setup.