Optimized WooCommerce store for 25,000+ products with automatic feed import system and intelligent car configurator.
JanteOnline.ro is an online store specializing in wheels and tires, built on WordPress + WooCommerce and optimized to handle over 25,000 products without performance compromise. The platform integrates an automatic product feed import and update system from 6 different sources (API and FTP), ensuring continuous synchronization with supplier stocks.
The main feature is the intelligent car configurator which contains a database with over 250+ car brands, models, generations and engines. The system automatically provides accurate recommendations for wheel and tire sizes based on the customer's selected car, eliminating confusion and drastically reducing order errors.
Challenge:
Managing a catalog of over 25,000 products (wheels and tires) with frequent stock updates from 6 different suppliers, each with their own feed format (API, FTP, CSV, XML). Customers struggled to select the right products for their cars, needing complex technical guidance regarding dimensions, PCD, ET and other specifications. Standard WooCommerce cannot efficiently handle such a large product volume without major optimizations.
Solution:
We developed an automatic import and synchronization system that processes feeds from 6 different sources (REST API, FTP, CSV, XML) and updates products in real-time without manual intervention. We created an intelligent car configurator with a database of 250+ brands, models, generations and engines that automatically provides accurate recommendations for wheels and tires. The WooCommerce template was heavily optimized (query optimization, lazy loading, advanced caching) to handle 25,000+ products with <3 second load time. The filtering system was completely rewritten for maximum performance.
Custom system for processing 6 different feeds (REST API, FTP, CSV, XML) with automatic stock, price and technical specification updates. Real-time synchronization without manual intervention, complete error logging and automatic alerts.
Database with 250+ car brands, models, generations and engines. Automatically provides correct wheel dimensions (diameter, width, PCD, ET, CB) and tires (width, height, diameter) based on selected car. Eliminates ordering errors.
Fully optimized WooCommerce template: query optimization (reduces 80% DB queries), image lazy loading, advanced object caching (Redis/Memcached), strategic database indexing. Load time <3 seconds with 25,000 products.
Optimized multi-criteria filtering (brand, size, PCD, ET, season, price) with AJAX live search and faceted navigation. Elastic indexing for instant results even with 25,000 products. Compatible with car configurator.
Automatic real-time stock synchronization from all suppliers. Automatic notifications for out-of-stock products, threshold alerts for low stock and backorder management. Centralized dashboard for multi-supplier monitoring.
Fully responsive design optimized for mobile shopping. Car configurator adapted for touch, mobile-friendly filters, simplified checkout for maximum mobile conversion. PWA-ready for app-like experience.
The system processes 6 different feeds, each with its own access method:
Universal feed parser that normalizes data from various formats (JSON, XML, CSV) into WooCommerce structure. Automatic custom field mapping, technical data validation (PCD, ET, CB), duplicate detection and conflict resolution when the same product comes from multiple suppliers.
Cron jobs configured to check feeds at scheduled intervals (every 6 hours for API, daily for FTP). Incremental update only for modified products (not complete re-import). Automatic rollback in case of critical error and email notifications for administrators.
Custom database with 250+ car brands (Audi, BMW, Mercedes, VW, Dacia, Ford, etc.), each with complete models, generations (including facelifts) and detailed engines. Over 15,000 unique car-engine configurations with exact OEM specifications.
Based on selection (brand → model → generation → engine), the system automatically displays OEM dimensions for wheels (diameter 15"-22", width, PCD, ET, CB) and tires (width, profile, diameter). Includes alternative variants (plus-sizing, minus-sizing) with technical explanations.
After selecting the car, the catalog automatically filters to show ONLY compatible products. Visual badges "Compatible with your car" and clear explanations about differences from OEM (if applicable). Drastically reduces returns due to incompatible products.
WordPress 6.x - Stable and flexible CMS. WooCommerce 8.x - eCommerce engine with extensive customizations for high product volumes.
PHP 8.x - Custom plugins for feed import and car configurator. MySQL - Database optimization with strategic indexing for query performance. JavaScript/jQuery - Frontend interactivity for configurator and filters.
Redis - Object caching for WooCommerce queries. Cloudflare CDN - Content delivery and image optimization. Lazy Loading - On-demand image loading. Database Indexing - Custom indexes for fast filtering.
Supplier APIs - REST connections for feeds. FTP/SFTP - Automated file retrieval. Payment Gateways - Stripe, card processing. Shipping - FAN Courier, DPD, Cargus integration.
Load time: <3 secunde with 25,000 products
Order error reduction: 85% through car configurator
Stock updates: 100% automat without manual intervention
Checkout conversion: +45% vs previous version
Contact us for a free consultation and let's discuss your online store.
Contact us now