Moving 314 SKUs from PrestaShop to Upgates, with the data nobody wants to clean. from PrestaShop to Upgates

The visible migration was the easy part: 314 products, descriptions, images, prices. The unglamorous part was a catalogue of 895 EAN entries with mixed Czech and Slovak text, accented characters, and missing GS1 codes — the kind of CSV that breaks every off-the-shelf import tool.

I built a Python + Playwright toolkit against the Upgates API, plus a Czech/Slovak normalisation layer that hit a 94% match rate across the catalogue and generated 374 valid EAN-13 codes for SKUs that needed them. New product creation is now a single n8n workflow.

The unglamorous fixes. Diacritic-aware regex for Slovak titles, Playwright for the bits of Upgates the API didn’t expose, an EAN-13 generator with a real GS1 check-digit (off-by-one is silently wrong), and a normaliser that knows "Pergola Klasik 3×4 m" and "PERGOLA KLASIK 3x4" are the same product. Every step writes to a JSON progress file so the run is resumable.