Most eCommerce automation scripts break quietly at SKU #400—corrupted CSV variants, broken CDN images, unescaped Liquid markup, or horizontal overflow on 375px phones. Here is the production architecture I use across multi-thousand-SKU storefronts.
Built resumable Python + SQLite ETL workers with deterministic checkpointing, schema validation, variant deduplication, and automated retry backoffs.
Rebuilt a live Dawn-based Shopify theme and processed thousands of product images with strict aspect-ratio, resolution, and broken-link gates prior to publish.
Headless Chromium + CDP scripts capture desktop and mobile viewports, assert zero horizontal overflow, flag broken images (naturalWidth === 0), and verify live DOM state.
Before shipping storefront updates, email templates, or batch ad creatives, every asset runs through a lightweight command-line verifier that blocks defective builds early:
{
"storefront_check": {
"viewports": ["1280x820 desktop", "375x812 mobile@2x"],
"mobile_horizontal_overflow": false,
"broken_images_natural_width_0": 0,
"klaviyo_tracking_verified": true,
"schema_and_meta_complete": true
},
"media_gate_ffprobe": {
"aspect_ratio_verified": "9:16 | 1:1 | 4:5",
"audio_stream_present": true,
"bitrate_and_codec": "h264 / aac"
}
}