Zelviro

Challenge

Zelviro had an online store with over 13,000 products listed, required integration with two major marketplaces (eMAG and Trendyol), order processing through Sameday and ColetOnline, and a monolithic PHP codebase that made each update risky. Product listing loaded in over 90 seconds due to unoptimized queries on tables with hundreds of thousands of rows. Marketplace synchronization was manual, with constant risk of discrepancies between real stock and what was shown on eMAG. And anyone touching production code risked breaking 8 years of accumulated evolution.

Solution

We completely rebuilt the technical stack while preserving the existing database and content intact. For performance, we added composite indexes on the products table (status+slug, parent+status, featured+status) and on ppc (category_id+product_id) that reduced shop TTFB from 94 seconds to 27 milliseconds. We restructured queries to avoid N+1 patterns and implemented OLS-level caching for public pages. For marketplace integrations, we built an automatic workflow: stock sync on every change, automatic push of orders to Sameday/ColetOnline, retry logic for network errors, Telegram alerting for failed syncs. For production security, we implemented a staging-laravel model as canonical source of truth with automatic schema replication on spokes and an automatic backup system before any push. Old URLs were kept identical through reverse proxy, without 301 chains that would have broken SEO rankings.

Process

1. 01Complete audit of existing code and mapping of all active integrations
2. 02Full backup of code + DB + uploads (1.3GB) with tested rollback
3. 03Adding DB indexes with measured impact on critical queries
4. 04Frontend reconstruction preserving client-approved design, semantically modernized
5. 05Implementing marketplace integration layer with retry and alerting
6. 06Setup of canonical staging with schema replication on production
7. 07Gradual migration with maintenance page and IP whitelist for testing