Supplier Stock Sync Dashboard
dashboardFeaturedApril 2026

Supplier Stock Sync Dashboard

Built a multi-supplier stock synchronization system for Inlinex that keeps Shopify inventory policies in sync with three upstream suppliers: Powerslide (via CSV upload), FR Skates and Seba (via automated Universkate B2B portal scraping with session authentication), and Flying Eagle (via Excel upload). The Flask-based web dashboard provides drag-and-drop file uploads, one-click sync triggers, live log streaming, and per-supplier stats including variants checked, updated, unchanged, and errored. Each supplier pipeline runs in a background thread with its own state and lock, enabling concurrent syncs. The system uses EAN barcode matching to map Shopify variants to supplier stock levels — when a supplier is in stock, the variant is set to 'continue selling when sold out'; when out of stock, it switches to 'deny'. FR Skates and Seba syncs also run automatically on a cron schedule at 06:00 and 18:00 SGT via APScheduler. Deployed on Railway with Docker.

Tech Stack

PythonFlaskBeautifulSoupShopify APIAPSchedulerDockerRailway