Xshowhome: 16,193 product records remediated
The situation
Xshowhome operates a multi-showroom ex-showhome furniture retail business across Warwickshire and the Midlands. The Shopify store had grown organically and the underlying data was in poor shape: thousands of product images attributed to the wrong brand, the Shopify Standard Taxonomy broken with 1,373 products assigned to nonsense categories like "Address Signs" and "Earthquake Alarms", and the store’s own legal entity name leaking into Google indexed page titles.
What I did
Three-phase data remediation via Python/openpyxl scripts and Matrixify bulk import. Phase 1: alt text correction across all 16,193 image rows, 15,668 corrected, 190 generated from scratch. Phase 2: product type standardisation, 71 inconsistent values cleaned to 50 correct types across 1,486 rows. Phase 3: full taxonomy rebuild, all 6,337 products remapped to correct Shopify Standard Taxonomy paths.
The outcome
- ▸16,193 product records remediated across the catalogue
- ▸15,668 alt texts corrected (97% of the catalogue), 190 generated from scratch
- ▸6,337 products remapped to a clean Shopify Standard Taxonomy
- ▸SEO audit score moved from 66 to 84 (before and after remediation)
- ▸Brand-name leaks removed from store name, alt text, and indexed titles
“The scale of what Dan uncovered in our product catalogue was genuinely shocking. Thousands of product records with the wrong information, taxonomy misclassifications we’d never have found ourselves. He fixed all of it systematically and quickly.”Gemma Pountney, Xshowhome