# Catalog Bulk Export Joiner Local source edition 1.0.0. Join product and variant rows from a catalog JSONL export. Download spreadsheet-ready product summaries, variant detail and an unmatched-parent worksheet. ## 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 jsonl as a string with one catalog object per line. For a Shopify bulk query select product id, title, handle and variants { edges { node { id title sku barcode price } } }; select no other fields or node types. Every variant needs its export __parentId. Only id is required on products. Up to 5000 records and 1500000 UTF-8 bytes. Use public-safe product data and a single price currency and basis. ## Results PRODUCTS.csv gives variant counts and price ranges; VARIANTS.csv joins each variant to its product. UNMATCHED.csv preserves orphan IDs and source line numbers for follow-up. Products without variants remain visible. Price and barcode are strings; import barcode and SKU columns as text to retain leading zeros. This builds analysis tables; it does not update a shop. The results folder includes summary.json and the output files produced by this input. The sample produces: PRODUCTS.csv, VARIANTS.csv, UNMATCHED.csv. ## Español · Unificador de exportaciones de catálogo Relaciona productos y variantes de una exportación JSONL y separa los registros sin correspondencia. 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.