BizonGarage — 170 000-product store with custom wholesaler sync

What we built

• Custom wholesaler integration — built specifically around the wholesaler’s API structure and data scale. No off-the-shelf module handled 170 000 SKUs without queue overflow.
• Real-time stock and price sync — full sync of 170 000+ products, automatic change detection, queued batch updates without blocking the admin panel.
• Product mapping wholesaler ↔ store — custom SKU, category and attribute mapping with operator-side manual override.
• SEO positioning — technical audit, Core Web Vitals optimization, Product / Offer / AggregateRating Schema.org markup, dynamic sitemap for 170k pages, clean URLs.
• Sync cron — delta-sync every few minutes, nightly full-sync, alerts when stock drifts from the wholesaler source.

Why custom

Off-the-shelf sync plugins fall apart at 30-50k products. Above 100k every wholesaler row is a potential race condition, queue overflow or memory leak. We designed the system from scratch: chunked batches, idempotent ops, optimistic locking on price changes, retry with exponential backoff on wholesaler API errors.

Outcome

170 000+ active SKUs, sync running without manual intervention, SEO rankings climbing across category and product visibility. The store scales further without rewriting the architecture.